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

SQL

#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

Source

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

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

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

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

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us