Admin-Ahead Community

Windows => Control Panels => Plesk => Topic started by: sajugovind on August 02, 2014, 09:58:32 pm

Title: Connection to the database server has failed Table ‘mysql.servers’ doesn’t exist
Post by: sajugovind on August 02, 2014, 09:58:32 pm

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,