We were getting an error while adding a database user by using Plesk,Error received:
Error: Connection to the database server has failed:
Table ‘mysql.servers’ doesn’t exist
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.