Answers for "#1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'"

SQL
0

#1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'

I stumble upon this issue and I solved it just by logging out of phpMyAdmin and in again.

-logout button image
https://i.stack.imgur.com/TeSCb.png

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
Posted by: Guest on September-07-2021

Code answers related to "#1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'"

Code answers related to "SQL"

Browse Popular Code Answers by Language