MYSQL question

Kevnathan · 03-08-2005, 08:00 AM

Hi I am trying to run mysql but i am getting this error

[root@OneBox bin]# ./mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Regards,
Kevin N Khushal

hamish · 03-08-2005, 08:13 AM

Hi sometimes mysql gets itself in a mess regarding the socks file.

do:
$ ps aux | grep my

to see if there is any mysql services running. If there are none, then you have to start it:
# /etc/init.d/mysql start

hamish

Kevnathan · 03-08-2005, 08:24 AM

Hi Hamish,
The mysql service is running on my linux box.

What shall i do now.

KEvin

overlord73 · 03-08-2005, 08:31 AM

Quote:

Hi I am trying to run mysql but i am getting this error

Quote:

The mysql service is running on my linux box.

what do you want to do? :-)

bathory · 03-08-2005, 08:39 AM

Edit /etc/my.cnf (or wherever my.cnf is) and change the "socket = ..." to socket = /tmp/mysql.sock" for the client [mysql] and the server [mysqld]. Of course you have to restart the server.