Windows > Plesk

Connection to the database server has failed Table ‘mysql.servers’ doesn’t exist

(1/1)

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


--- Code: ---Error: Connection to the database server has failed:
Table ‘mysql.servers’ doesn’t exist
--- End code ---

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: ---mysql_fix_privilege_tables --user=admin --password=<admin password> --verbose
--- End code ---

Replace <admin password> with the exact password

That will fix all issues!

Thank you,

Navigation

[0] Message Index