Solutions for #1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs' (100% working)
The error looks like
To solve this problem by just destroying user-session
the PHPMyAdmin session by given way
clicking the icon Phpmyadmin remove all current session
By logging out we force phpMyAdmin to "forget" the current user and let us input the login credentials for the MySQL server.
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.


Post a Comment
Leave a comment first....