mysql error

[eduac]

guys,
when i try to run mysql into the shell, appers this message:

eduardo:~ # mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

anybody can help me?

[tsinka]

Is eduardo the name of the server or did you log in as user eduardo. Can you connect to the MySQL server as user root ? What happens if you try

mysql -uroot -p -h localhost
or
mysql -uroot -p -h theserver

Also check if the socket /var/lib/mysql/mysql.sock exists and the access rights of the socket.

Check /etc/my.cnf (or wherever my.cnf is) and try to change all socket configuration variables to

socket = /tmp/mysql.sock

and restart MySQL.

Hope this helps you a little bit 🙂

Is MySQL running at all ?

Thomas

[tsinka]

I forgot something ...

If you compiled and installed MySQL manually you have to execute mysql_install_db to initialize the mysql database before you can connect to MySQL.