Table ‘mysql.servers’ doesn’t exist

We were getting an error while adding a database user by using Plesk,Error received:

[wpfmb type=’error’ theme=2]Error: Connection to the database server has failed:
Table ‘mysql.servers’ doesn’t exist[/wpfmb]

This error generally happens while compiling MySQL to new version, obviously due to incomplete MySQL  update. You often need to run mysql_fix_privilige_tables command to make sure that the MySQL  database contains all the required material.

To resolve the error you can follow the steps:

1) Login to the server as root.

2)Run following command:

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

This script updates all the MySQL privilege tables to be usable by the current version of MySQL.

That’s it! Now try adding the user to the database. You should now be able to add the user without any error.

 

Leave a Reply

Your email address will not be published. Required fields are marked *