Error: Connection to the database server has failed:
Table ‘mysql.servers’ doesn’t exist
To fix this issue
- SSH to server
- Issue this command
mysql_fix_privilege_tables --user=admin --password= --verbose
Should see multiple lines pass through and will end with “done”
Now you should be able to add the user to the database without any problems. This error generally occurs while compiling Mysql to new version, apparently due to incomplete Mysql upgrade. You often need to run mysql_fix_privilige_tables command to ensure that the mysql database contains all the required contents.