MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist

Question

Recently I have updated from MySQL 5.1 to 5.5 and after few weeks the following error message was displayed each time I access the phpMyAdmin application:

1146 - Table 'data_dictionary.CHARACTER_SETS' doesn't exist

I have investigated the issue to the point where I have been forced to downgrade the MySQL service to 5.0.95 and then to upgrade the service once again to 5.1.

None of the above outlines steps however resolved the issue and the error message in questions still persist . This error disables me to access any database/table via the phpMyAdmin interface.

The error logs on the server are not providing additional information at all. The checked logs were:

-> mysql.err log -> the cpanel error log

Any help will be highly appreciated

Answer 1

Run sudo mysql_upgrade -u root -p --force

Then restart mysql

i.e. sudo service mysql restart or sudo service mysqld restart depending on the version and distribution you have

You need to logout of phpMyAdmin then login for the change to take effect.