poniedziałek, 23 stycznia 2012

MySQL ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’

After some unexpected things I got "MySQL ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock"


Solution #1:

So - delete everything in "/etc" and "/var" that has "mysql". Delete, purge, reinstall. I know... that;s not the way. But...

link

Solution #2:
It happens again, after I issued sudo service mysql stop 
I've got the error 2002 messaged trying to run sqlbrowser.

I've checked if sql server is running:
ps auxww | grep mysql
I've got empty message.
So I issued "mysqld" - fails.
So I issued "sudo mysqld - everything works.


I've checked if sql server is running:
ps auxww | grep mysql
I'got two lines, the first was:

mysql     1237  0.0  0.8 145456 18164 ?        Ssl  09:01   0:00 /usr/sbin/mysqld

You can check if server is running by:
netstat -tap | grep mysql
So mysql server is running


3. Summary
sudo service mysql start - for start server
sudo service mysql stop - for stop server
sudo service mysql status - for server status

Brak komentarzy:

Prześlij komentarz