#1142-用户'@'localhost'的表'pma_table_uiprefs'的SELECT命令被拒绝 [英] #1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'

问题描述

希望有人可以帮助我，因为我在网上查询此错误没有成功或具体答案.我正在使用Windows和Xampp.这是我最近将数据库导入phpmyadmin后出现的错误……

Hopefully someone can help me, for I have queried the web with no success or concrete answer to this error. I’m using Windows and Xampp. Here is the error I am getting after I have recently imported the database into phpmyadmin…

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

导入数据库后，在phpmyadmin中一切正常，直到注销并重新登录，这才是问题所在.当我从导入的数据库中单击任何表时，出现以下错误……

After I import the database, everything is fine in phpmyadmin until I log out and then log back in, this is where the problem lies. When I click on any of the tables from the imported database, I get the following errors…

SELECT 'prefs'
FROM 'phpmyadmin'.'pma_table_uiprefs'
WEHRE 'username' = 'root'
AND 'db_name' = 'afdb'
AND 'table_name' = 'role'

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

再次感谢您抽出时间阅读我的文章，希望有人可以帮助我解决此错误.

Thank you again for taking time to read my post and hopefully someone can help me with this error.

推荐答案

我偶然发现了这个问题，并且仅通过注销再次从phpMyAdmin中解决了该问题.

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

看看错误消息查询:

SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'

发生这种情况是由于MySQL拒绝访问服务器localhost上的用户"(空白).默认设置是阻止来自匿名用户的所有请求.

This happens due to MySQL denying access to user "" (blank) at server localhost. The default setting is to block all requests from anonymous users.

通过注销，我们强制phpMyAdmin忘记"当前用户，并让我们输入MySQL服务器的登录凭据.

By logging out we force phpMyAdmin to "forget" the current user and let us input the login credentials for the MySQL server.

这篇关于#1142-用户'@'localhost'的表'pma_table_uiprefs'的SELECT命令被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！