Resolved ERROR: PleskDBException: Unable to connect to database

[core2]

version: 12.5.30 Ubuntu 14.04 1205160608.09

We are getting the following error while trying to access the plesk panel

"ERROR: PleskDBException: Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible. (Abstract.php:69)"

MySQL works fine and even the web applications running without any problems. We have checked the KB and there similar issues but not the same scenario. (in our case mysql seems to be running)

Any help greatly appreciated

 

[IgorG]

https://kb.plesk.com/en/128936

 

[core2]

@IgorG Thank you! We have checked through those instructions and didn't find it helpful as it only explains the solution to start mysql if it's not running. In our case mysql service running without any issues. Only plesk interface is not working!

 

[IgorG]

What about mentioned https://kb.plesk.com/en/128949 ?
Is it your case?

 

[core2]

@IgorG Haven't tried it yet, is it safe to run the command 'plesk repair db -v' or restoring a backup version? we are trying to fix the issue without interrupting the application!

 

[IgorG]

is it safe to run the command 'plesk repair db -v' or restoring a backup version?

You will be asked to confirm each step.

 

[core2]

@IgorG actually problem seems to be the same as the issue https://talk.plesk.com/threads/ubuntu-14-04-mysql-error-after-restart.336741/#post-795493

issuing the following command made the plesk to work!

sudo service mysql stop
sudo service mysql start

very strange I thought this issue was fixed with the last few updates!