首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >MariaDB显示数据库特权

问MariaDB显示数据库特权
EN

Stack Overflow用户
提问于 2017-11-08 13:47:58
回答 1查看 835关注 0票数 1

在控制台SHOW DATABASES;中运行时,我会收到以下错误:

代码语言:javascript
复制
ERROR 1227 (42000): Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation

我已经使用SHOW GRANTS FOR CURRENT_USER;检查了用户权限,并且我似乎拥有所有的权限:

代码语言:javascript
复制
GRANT USAGE ON *.* TO 'tec'@'%' IDENTIFIED BY PASSWORD ' *F0AAB5B469***16C3449'

GRANT ALL PRIVILEGES ON `tec`.* TO 'tec'@'%' 

原因是什么?

代码语言:javascript
复制
Server version: 10.0.32-MariaDB-0+deb8u1 (Debian)
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2017-11-08 14:32:26

我无法重现这个问题:

代码语言:javascript
复制
$ mysql -u tec -p
Enter password:
代码语言:javascript
复制
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

代码语言:javascript
复制
...

[mysqld]
...
skip_show_database
...
代码语言:javascript
复制
$ mysql -u tec -p
Enter password:
代码语言:javascript
复制
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

代码语言:javascript
复制
MariaDB [(none)]> SHOW VARIABLES
    -> WHERE `Variable_name` = 'skip_show_database';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| skip_show_database | ON    |
+--------------------+-------+
1 row in set (0.00 sec)
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/47181380

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档