mysql特权_检查MySQL中特定用户的特权（授予）？

最新推荐文章于 2024-03-11 23:36:10 发布

weixin_39918043

最新推荐文章于 2024-03-11 23:36:10 发布

阅读量161

点赞数

文章标签： mysql特权

本文链接：https://blog.csdn.net/weixin_39918043/article/details/113584784

版权

如果要检查特定用户的特权，请使用以下语法-SHOW GRANTS FOR 'yourUserName'@'yourHostName';

上面的语法将检查特定用户的特权。

要检查特定用户的特权，请使用FOR。假设我们有一个用户名“ JOHN”，主机是“％”。以下是获取用户“ JOHN”特权的查询-mysql> SHOW GRANTS FOR 'JOHN'@'%';

这将产生以下输出-+---------------------------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------------

--------------+

| Grants for JOHN@%

+---------------------------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------------

--------------+

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,

PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE

TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION

CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE

USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO

`JOHN`@`%` WITH GRANT OPTION |

| GRANT

BACKUP_ADMIN,BINLOG_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GR

OUP_REPLICATION_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_SLAVE_A

DMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SET_USE

R_ID,SYSTEM_VARIABLES_ADMIN,XA_RECOVER_ADMIN ON *.* TO `JOHN`@`%` WITH

GRANT OPTION |

+---------------------------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------------

--------------+

2 rows in set (0.00 sec)

关注