Connection to the database server failed error in Plesk

Connection to the database server failed
This article will help you to resolve the issue "Connection to the database server failed table ‘mysql.servers’ doesn’t exist".

If you are unable to create database users in Plesk and displaying the errors as follows upon creation “Connection to the database server failed table ‘mysql.servers’ doesn’t exist”.

This error generally occurs while compiling MySQL to the new version, apparently due to an incomplete MySQL upgrade. So give the following from shell as root to solve the issue.

mysql_fix_privilege_tables --user=admin --password=<admin password> --verbose

Replace <admin password> with the exact password

That command will correct the installation issues, and the error will be gone.
There is another solution for this issue – Complete the Upgrade process. You can use the following command to do so.( Note: This is not recommended. Only proceed if the first solution didn’t work for you. )

mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

After this, you need to restart MySQL and PSA services to update the changes. Also, check and verify the issue is gone.

So that’s how you fix – Connection to the database server failed table ‘mysql.servers’ doesn’t exist.

Share this post

Services to Explore

Stay up to date!

Stay up to date with the Web Hosting, Cloud and Server Management Industry News and Tutorials!

We will send you only the relevant emails, and we respect your privacy. Please review our privacy policy for more info.

Plesk Management Services

Focus on your business, and let us take care of your Plesk Servers!
From what you are reading, it seems you are interested in Plesk and related technologies. If you have a moment to spare, please take a look at our Plesk Server Management Services plan, and which might interest you even more!
Plesk Server Management Plan

Value-Added Services

We have services that can help you run a successful business. With us, you don't have to worry about these areas because our experts will take care of it for you.

ServerHealers uses cookies.