PHPmyadmin Error - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist

Posted March 13, 2015 23.4k views

I’m getting the following error when I try and open a table

SQL query: DocumentationEdit Edit

SELECT  `prefs` 
FROM  `phpmyadmin`.`pma_table_uiprefs`
WHERE  `username` =  'root'
AND  `db_name` =  'wordpress'
AND  `table_name` =  'wp_options'

MySQL said: Documentation

#1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist 
1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
2 answers

This question was answered by @greg1082858:

Find the issue

sudo dpkg-reconfigure phpmyadmin

You can see the comment here.

Adding in another solution for this error which i have found on web: