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

mysql sql phpmyadmin data-dictionary
Simeon Mitev picture Simeon Mitev · Oct 1, 2013 · Viewed 7.1k times · Source

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

ralphowino picture ralphowino · May 30, 2016

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.

Related questions

MySQL: Can't create table (errno: 150)

I am trying to import a .sql file and its failing on creating tables. Here's the query that fails: CREATE TABLE `data` ( `id` int(10) unsigned NOT NULL, `name` varchar(100) NOT NULL, `value` varchar(15) NOT NULL, UNIQUE KEY `id` (`id`,`name`), …

Read More
Error Dropping Database (Can't rmdir '.test\', errno: 17)

Basically, I was taught on how to create a root password using the "mysqladmin -u root -p password" command, this was done all through the windows command editor. Now, the next process was to display the default databases (info. schema, …

Read More
PHP: maximum execution time when importing .SQL data file

I am trying to import a large .sql data file using phpMyAdmin in XAMPP. However this is taking a lot of time and I keep getting: Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\…

Read More