【待反馈】新装的几台服务器都是这个问题 求助

为了能快速了解并处理您的问题，请提供以下基础信息：

面板、插件版本： [size=1.2]Linux正式版8.2.0

[size=1.2]Linux正式版8.2.0

系统版本：php 8.1.27   phpmyadminn 5.0  mysql 5.7.44 Nginx 1.24

问题描述：数据库无权限打开

相关截图（日志、错误

Fatal error: Uncaught mysqli_sql_exception: SELECT command denied to user 'admin'@'localhost' for table 'user' in /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Dbi/DbiMysqli.php:199 Stack trace: #0 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Dbi/DbiMysqli.php(199): mysqli->query() #1 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/DatabaseInterface.php(316): PhpMyAdmin\Dbi\DbiMysqli->realQuery() #2 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/DatabaseInterface.php(2390): PhpMyAdmin\DatabaseInterface->tryQuery() #3 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/DatabaseInterface.php(2332): PhpMyAdmin\DatabaseInterface->isUserType() #4 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Menu.php(562): PhpMyAdmin\DatabaseInterface->isSuperuser() #5 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Menu.php(107): PhpMyAdmin\Menu->_getServerTabs() #6 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Menu.php(70): PhpMyAdmin\Menu->_getMenu() #7 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Header.php(445): PhpMyAdmin\Menu->getDisplay() #8 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Response.php(323): PhpMyAdmin\Header->getDisplay() #9 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Response.php(336): PhpMyAdmin\Response->_getDisplay() #10 /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Response.php(495): PhpMyAdmin\Response->_htmlResponse() #11 [internal function]: PhpMyAdmin\Response->response() #12 {main} thrown in /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Dbi/DbiMysqli.php on line 199

您好，您这个是因为mysql数据库的错误，其中提示了用户'admin'在尝试从本地主机访问名为'user'的表时被拒绝
可以查看一下是否因为权限的原因
给用户授权

1. GRANT SELECT ON your_database_name.user TO 'admin'@'localhost';

复制代码