在控制台SHOW DATABASES;中运行时,我会收到以下错误:
ERROR 1227 (42000): Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation我已经使用SHOW GRANTS FOR CURRENT_USER;检查了用户权限,并且我似乎拥有所有的权限:
GRANT USAGE ON *.* TO 'tec'@'%' IDENTIFIED BY PASSWORD ' *F0AAB5B469***16C3449'
GRANT ALL PRIVILEGES ON `tec`.* TO 'tec'@'%' 原因是什么?
Server version: 10.0.32-MariaDB-0+deb8u1 (Debian)发布于 2017-11-08 14:32:26
我无法重现这个问题:
$ mysql -u tec -p
Enter password:MariaDB [(none)]> SELECT VERSION(), CURRENT_USER();
+-----------------+----------------+
| VERSION() | CURRENT_USER() |
+-----------------+----------------+
| 10.0.33-MariaDB | tec@% |
+-----------------+----------------+
1 row in set (0.00 sec)
MariaDB [(none)]> SHOW GRANTS FOR CURRENT_USER;
+--------------------------------------------------------------------------------+
| Grants for tec@% |
+--------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'tec'@'%' IDENTIFIED BY PASSWORD '*F0AAB5B469***16C3449' |
| GRANT ALL PRIVILEGES ON `tec`.* TO 'tec'@'%' |
+--------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| tec |
+--------------------+
2 rows in set (0.01 sec)更新
检查skip_show_database服务器系统变量。
my.cnf
...
[mysqld]
...
skip_show_database
...$ mysql -u tec -p
Enter password:MariaDB [(none)]> SELECT VERSION(), CURRENT_USER();
+-----------------+----------------+
| VERSION() | CURRENT_USER() |
+-----------------+----------------+
| 10.0.33-MariaDB | tec@% |
+-----------------+----------------+
1 row in set (0.00 sec)
MariaDB [(none)]> SHOW GRANTS FOR CURRENT_USER;
+--------------------------------------------------------------------------------+
| Grants for tec@% |
+--------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'tec'@'%' IDENTIFIED BY PASSWORD '*F0AAB5B469***16C3449' |
| GRANT ALL PRIVILEGES ON `tec`.* TO 'tec'@'%' |
+--------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
MariaDB [(none)]> SHOW DATABASES;
ERROR 1227 (42000): Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation更新2
MariaDB [(none)]> SHOW VARIABLES
-> WHERE `Variable_name` = 'skip_show_database';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| skip_show_database | ON |
+--------------------+-------+
1 row in set (0.00 sec)https://stackoverflow.com/questions/47181380
复制相似问题