LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   MYSQL question (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-question-299109/)

Kevnathan 03-08-2005 08:00 AM

MYSQL question
 
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.


All times are GMT -5. The time now is 02:53 PM.