telson
Joined: 29 Nov 2006 Posts: 123
|
Posted: Fri Oct 31, 2008 7:18 pm Post subject: ERROR: Can't connect to local MySQL server through socket. |
|
|
| Quote: | | MySQL Upgrade - ERROR: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) |
Recently I upgraded MySQL on one of our server.
After the upgradation, I received the following error while connecting to MySQL.
| Quote: | | ERROR: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) |
I tried editing the /etc/my.cnf file, but it was in vain.
Finally to fix the issue, I did the following:
Moved the my.cnf file to bkp and then forced MySQL to update.
| Code: | mv /etc/my.cnf /etc/my.cnf.bkp
/scripts/mysqlup --force |
Normally, the above fix will work for allmost all the issues related to MySQL connectivity.[/quote] _________________ Regards,
Telson Thomas
Linux Web Server Administrator |
|