Plesk Fatal Exception - MySQL Gone!

[joecostello]

Out of the blue no sites work, mysql has disappeared and i can't login to plesk:

ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

0: /usr/local/psa/admin/plib/common_func.php3:190
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)')
1: /usr/local/psa/admin/auto_prepend/auth.php3:93

Upon starting PSA:
[root@halal mysql]# /etc/rc.d/init.d/psa start
Starting xinetd service... done
Starting named service... done
Starting mysqld service... not installed
Starting qmail service... done
Starting courier-imap service... done
Starting postgresql service... not installed
Starting psa-spamassassin service... done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
websrvmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
System error 2: No such file or directory
websrvmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
System error 2: No such file or directory
websrvmng: Unable to connect to the mysql database

System error 2: No such file or directory
websrvmng: Unable to connect to the mysql database

System error 2: No such file or directory
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Starting Plesk... done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

 

[Factor41]

I'm having the same problem.

I've just done a yum update and everything seems to have installed fine, but now the mysql Daemon won't start up. I'm not exactly fluent on Linux so have no clue where to look.

My Plesk is giving the same error:
ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

0: common_func.php3:95
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)')
1: auth.php3:124

And if I use the SSH login and try to start mysqld, it just says:
MySQL Daemon failed to start.

If anybody could spell out what I should try, I'd really appreciate it.

 

[Factor41]

Sussed it, don't worry. I'd updated everything, but the new version of MySQL required me to remove the Berkeley bdb bit from the my.cfg file and I hadn't. Did that and the daemon started right up. Step 3 on http://www.atomicorp.com/wiki/index.php/Mysql