宝塔用户_jtfohj 发表于 2024-7-5 11:21:23

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

为了能快速了解并处理您的问题,请提供以下基础信息:面板、插件版本: Linux正式版8.2.0
Linux正式版8.2.0
系统版本:php 8.1.27   phpmyadminn 5.0mysql 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 : PhpMyAdmin\Response->response() #12 {main} thrown in /www/server/phpmyadmin/phpmyadmin_45e1ef917e5cdd2b/libraries/classes/Dbi/DbiMysqli.php on line 199

运维技术阿闯 发表于 2024-7-5 12:06:18

您好,您这个是因为mysql数据库的错误,其中提示了用户'admin'在尝试从本地主机访问名为'user'的表时被拒绝
可以查看一下是否因为权限的原因
给用户授权
GRANT SELECT ON your_database_name.user TO 'admin'@'localhost';
页: [1]
查看完整版本: 【待反馈】新装的几台服务器都是这个问题 求助