Came across this little issue while trying to install Centreon (monitoring server).
During the install it attempts to create a database use and then failed during that process with the following error
"Table ‘mysql.servers’ doesn’t exist"
Apparently during a MySQL upgrade it is common for something to not quite finish completely.
To fix the problem I had to run the following command from a console window. By the way this was run on a Centos 5.9 server.
mysql_upgrade -u root -p
After the above command I restarted mysqld
service mysqld restart
After the above I was successfully able to continue the Centreon install.
Labels: command line, linux, open source