ERROR 2002: Can't connect to local MySQL server through socket

[teknovision]

Hi all!

I hope someone can help me because I am in a little bit of a pickle!!

I tried to update from 7.5.x to the next version. I chose only to update 'Base Plesk' and 'Backup' - trying to backup and move to Plesk 8.1.0 on another provider but kept on getting errors relating to MySQL.

Got the email to say it was being updated, then got email errors so tried to login and got the following error:

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

So I followed some links and tried to restart PSA and MySQl with the following results:

# /etc/init.d/psa restart
===> Reading /etc/psa/psa.conf ...
/usr/local/psa/admin/bin/httpsdctl restart: httpd not running, trying to start
db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Key register failed
/usr/local/psa/admin/bin/httpsdctl: line 227: 23995 Terminated $HTTPD
/usr/local/psa/admin/bin/httpsdctl restart: httpd could not be started
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


# /etc/init.d/mysqld restart
Stopping MySQL: [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]


Not really sure what to do next, any ideas would be muchly appreciated as I currently can't get mail or do any of the backups I intended to do! Any help would be muchly appreciated!!

Many thanks,

Philippe

 

[rembrandt]

check mysqld.log

check your /var/log/mysqld.log MySQL isn't started and thus you can't do anything untill MySQL is up and running again.

 

[teknovision]

Thanks for your response unfortuntaely, this require SWSoft to get involved.

It later transpires that database was corruptyed during upgrade, this occured because MySQL had been uprgaded to un unsupported version prior to me starting upgrade.

Couple of things worth sharing 1) read compatibility/supported notes before upgrading and 2) backup should you ignore 1), it will save the day!!