Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Connection to the database server has failed Table ‘mysql.servers’ doesn’t exist  (Read 3484 times)

0 Members and 1 Guest are viewing this topic.

sajugovind

  • Guest
If you are unable to create database users in Plesk and displaying the errors as follows upon creation:

Code: [Select]
Error: Connection to the database server has failed:
Table ‘mysql.servers’ doesn’t exist

This error generally occurs while compiling MySQL to new version, apparently due to incomplete MySQL upgrade.

So give the following from shell as root to solve the issue.
Code: [Select]
mysql_fix_privilege_tables --user=admin --password=<admin password> --verbose
Replace <admin password> with the exact password

That will fix all issues!

Thank you,