Solutions for #1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs' (100% working)

Solutions for #1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs' (100% working)

 The error looks like
phpmyadmin-error

To solve this problem by just destroying user-session

the PHPMyAdmin session by given way
clicking the icon Phpmyadmin remove all current session

EXPLANATION

Take a look at the error message query:
SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'
This happens due to MySQL denying access to user "" (blank) at server localhost. The default setting is to block all requests from anonymous users.
By logging out we force phpMyAdmin to "forget" the current user and let us input the login credentials for the MySQL server.

You may like these posts