Tuesday, January 29, 2013

Table ‘mysql.servers’ doesn’t exist

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.

1 comment:

Anonymous said...

Bless you! I was getting ready to throw things when I saw this. Worked for me too!