Error: 1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist

FacebookTwitterGoogle+LinkedIn

I recently upgraded my OS from Precise (ubuntu 12.04) to Trusty (ubuntu 14.04) . Everything went good and the upgrade seemed successful without any issues, until I browsed my local instance of phpmyadmin application. I was not able to browse any of the table in any database and every time I clicked on any table link, I got an error message stating “1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist”. 

After spending hours on the issue, I finally fixed it by using the following steps:

Modify the configuration file /etc/phpmyadmin/config.inc.php from:

To:

*Note the double underscores in the modified version of  line.

Restart apache:

sudo service apache2 restart;

and the problem solved!

FacebookTwitterGoogle+LinkedIn

2 thoughts on “Error: 1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist

  1. phen375

    Hello there, I discovered your site by the use of Google even as looking for a similar matter, your site got here up, it looks great.
    I’ve bookmarked it in my google bookmarks.

    I will appreciate in case you continue this in future.
    Many people will probably be benefited from your writing.
    Cheers!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *