Help with MySQL.

[Lucélio Gomes de Freitas]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Hi,

Issuing the commands:
[Lucelio@MAQ02 Documentos]$ mysqladmin --version
mysqladmin  Ver 8.42 Distrib 5.1.58, for redhat-linux-gnu on x86_64

I guess that MySQL is installed and operating.   But, issuing the command:

[Lucelio@MAQ02 Documentos]$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[Lucelio@MAQ02 Documentos]$

Any help creating the configuration/data files for a first cluster use?

Thanks,

- -- 
Lucélio Gomes de Freitas
ETFCSF-> U.G.F.-> P.U.C.(RJ)
Engº, Analista Suporte(Free Mind).
Email: aa.lucelio(a)gmail.com
Tel: 55 0XX 21 85964911

> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
>
> iF4EAREIAAYFAk5IYgwACgkQENqGaHfBA/f6wAD/ThnHCBRsy9BNvjmA618ejY+X
> pRYHkFQ0u1OWlEMoSSwBAJDpTksW+xSiUXxnzUv5cM0w4VXMDLBluh3Ywq3r6gDo
> =klX8
> -----END PGP SIGNATURE-----

[Mikkel L. Ellertson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 08/14/2011 07:02 PM, Lucélio Gomes de Freitas wrote:
>  
>  Hi,
>  
>  Issuing the commands:
>  [Lucelio@MAQ02 Documentos]$ mysqladmin --version
>  mysqladmin  Ver 8.42 Distrib 5.1.58, for redhat-linux-gnu on x86_64
>  
>  I guess that MySQL is installed and operating.   But, issuing the command:
>   
That shows that mysqladmin is installed. It does not say that mysql
is running.

>  [Lucelio@MAQ02 Documentos]$ mysql
>  ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>  '/var/lib/mysql/mysql.sock' (2)
>  [Lucelio@MAQ02 Documentos]$
>  
>  Any help creating the configuration/data files for a first cluster use?
>  
>  Thanks,
>   
If you run the command "service mysqld status" it will show you if
the mysql daemon is running. By default, it is not set to run when
installed. You have to turn the service on. If you want to do it
from the command line, run, as root:

chkconfig mysqld on
service mysqld start

You will not have to run the two commands again. If the service
command does not return OK, then you have an error in configuration.

Mikkel
- -- 

  Do not meddle in the affairs of dragons,
for thou art crunchy and taste good with Ketchup!
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iEYEARECAAYFAk5Ia8YACgkQqbQrVW3JyMSJfgCffADpJhYx364w1lk4ntFYXT1N
> 9OMAn305ZX8I+Sv4k8JLEcFR16lTeJ9S
> =Usko
> -----END PGP SIGNATURE-----

[Leonardo Silveira]

he is installed, but isn't operational. try this:
http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos...
http://www.linuxquestions.org/questions/linux-server-73/mysql-server-fail...


Em 14 de agosto de 2011 21:02, Lucélio Gomes de Freitas
<aa.lucelio(a)gmail.com&gt; escreveu:
>  -----BEGIN PGP SIGNED MESSAGE-----
>  Hash: SHA256
>
>  Hi,
>
>  Issuing the commands:
>  [Lucelio@MAQ02 Documentos]$ mysqladmin --version
>  mysqladmin  Ver 8.42 Distrib 5.1.58, for redhat-linux-gnu on x86_64
>
>  I guess that MySQL is installed and operating.   But, issuing the command:
>
>  [Lucelio@MAQ02 Documentos]$ mysql
>  ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>  '/var/lib/mysql/mysql.sock' (2)
>  [Lucelio@MAQ02 Documentos]$
>
>  Any help creating the configuration/data files for a first cluster use?
>
>  Thanks,
>
>  - --
>  Lucélio Gomes de Freitas
>  ETFCSF-> U.G.F.-> P.U.C.(RJ)
>  Engº, Analista Suporte(Free Mind).
>  Email: aa.lucelio(a)gmail.com
>  Tel: 55 0XX 21 85964911
>
> >  -----BEGIN PGP SIGNATURE-----
> >  Version: GnuPG v1.4.11 (GNU/Linux)
> >  Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
> >
> >  iF4EAREIAAYFAk5IYgwACgkQENqGaHfBA/f6wAD/ThnHCBRsy9BNvjmA618ejY+X
> >  pRYHkFQ0u1OWlEMoSSwBAJDpTksW+xSiUXxnzUv5cM0w4VXMDLBluh3Ywq3r6gDo
> >  =klX8
> >  -----END PGP SIGNATURE----- 
>  --
>  users mailing list
>  users(a)lists.fedoraproject.org
>  To unsubscribe or change subscription options:
>  https://admin.fedoraproject.org/mailman/listinfo/users
>  Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
>

[Reindl Harald]

Am 15.08.2011 02:02, schrieb Lucélio Gomes de Freitas:
>  
>  Hi,
>  
>  Issuing the commands:
>  [Lucelio@MAQ02 Documentos]$ mysqladmin --version
>  mysqladmin  Ver 8.42 Distrib 5.1.58, for redhat-linux-gnu on x86_64
>  
>  I guess that MySQL is installed and operating.   But, issuing the command:
>  
>  [Lucelio@MAQ02 Documentos]$ mysql
>  ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>  '/var/lib/mysql/mysql.sock' (2) 
how do you guess it is running?
have you started it and is it enabled?
what version of fedora?

[Lucélio Gomes de Freitas]

Em 14-08-2011 20:39, Steven Stern escreveu:
>  On 08/14/2011 07:02 PM, Lucélio Gomes de Freitas wrote:
> > Hi,
> >
> > Issuing the commands:
> > [Lucelio@MAQ02 Documentos]$ mysqladmin --version
> > mysqladmin  Ver 8.42 Distrib 5.1.58, for redhat-linux-gnu on x86_64
> >
> > I guess that MySQL is installed and operating.   But, issuing the command:
> >
> > [Lucelio@MAQ02 Documentos]$ mysql
> > ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> > '/var/lib/mysql/mysql.sock' (2)
> > [Lucelio@MAQ02 Documentos]$
> >
> > Any help creating the configuration/data files for a first cluster use?
> >
> > Thanks,
> >
>  The MySQL daemon isn't running. You need to start it.
>
>
>  sudo /sbin/service chkconfig mysqld on 
Thank you, "sudo /sbin/service mysqld
on".
>  sudo /sbin/service mysqld start 
It works now.

Can you please indicate, where to find an short example of using it
inside a "C" program?

thanks again.

-- 
Lucélio Gomes de Freitas
ETFCSF-> U.G.F.-> P.U.C.(RJ)
Engº, Analista Suporte(Free Mind).
Email: aa.lucelio(a)gmail.com
Tel: 55 0XX 21 85964911

[SternData]

On 08/14/2011 07:02 PM, Lucélio Gomes de Freitas wrote:
>  
>  Hi,
>  
>  Issuing the commands:
>  [Lucelio@MAQ02 Documentos]$ mysqladmin --version
>  mysqladmin  Ver 8.42 Distrib 5.1.58, for redhat-linux-gnu on x86_64
>  
>  I guess that MySQL is installed and operating.   But, issuing the command:
>  
>  [Lucelio@MAQ02 Documentos]$ mysql
>  ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>  '/var/lib/mysql/mysql.sock' (2)
>  [Lucelio@MAQ02 Documentos]$
>  
>  Any help creating the configuration/data files for a first cluster use?
>  
>  Thanks,
>   
The MySQL daemon isn't running. You need to start it.


sudo /sbin/service chkconfig mysqld on
sudo /sbin/service mysqld start


-- 
-- Steve