ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/my..

Goce · 11-30-2008, 03:52 PM

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

That is my error. I did a find / -name mysql.sock as root and found that it does not exsist. What should I do now in order to get mysql running? Thankx!

geek_man · 11-30-2008, 04:00 PM

Hi!

Is MySQL running?
Try this:

$ ps -ef | grep mysql

And post the output.

Goce · 11-30-2008, 04:18 PM

root:# ps -ef | grep mysql
root 4336 4202 0 22:16 pts/0 00:00:00 grep mysql

That's what I got.

geek_man · 11-30-2008, 09:57 PM

That is because MySQL is not running, and you can not connect to it.

If I remember well and at this moment I don't have a computer with GNU/Linux, you have to do the following:

As root:

# cd /etc/init.d
# ls
And you will find that there is a file with the name mysqld (This is if you installed mysql-server).
# ./mysqld start

And now MySQL service is up.

You can connect by typing:

$ mysql