Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[Windhan]

1. What is this Issue?
myserver:~ # mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2. How to resolve this?

3. What is the command to check mysql installed in my server?

[daark.child]

Try starting mysql by doing

#/etc/init.d/mysql start

Post back any error messages.

[Windhan]

But not able to start by that command.


myserver:~ # ../etc/init.d/mysql start
Starting MySQL................................... failed

[Kane274]

did you try restart instead of just start ? maybe stop then start ? Im not sure if sock and socket are the same, maybe it has something to do with the port.... but im not sure at all, just a wild guess

[Windhan]

myserver:~ # ../etc/init.d/mysql stop
MySQL manager or server PID file could not be found! failed


Do not know what is going on !!!!!!!!!!!!!!
Help me !!!!!!!!!!

[daark.child]

Look at the error log which should be somewhere in /var/log.

[Windhan]

Can u please tell me in details which log file to check in that folder /var/log.
I could not find any log file with the date?

[daark.child]

On my system its /var/log/mysqld.log. Out of curiosity, did you install using official SUSE rpms?

[Windhan]

But i dont have any mysqld.log file here in my system.

[daark.child]

You didn't reply all questions. Did you use the official openSUSE rpms for mysql? On my openSUSE 10.3 system, I used the official mysql packages from SUSE and I do have that log file.