共计 2725 个字符，预计需要花费 7 分钟才能阅读完成。
丸趣 TV 小编给大家分享一下如何查看 MYSQL 数据库中所有用户及拥有权限，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！
查看 MYSQL 数据库中所有用户
mysql SELECT DISTINCT CONCAT(User: ,user, @ ,host,) AS query FROM mysql.user;
+—————————————+
| query |
+—————————————+
| User: cactiuser @ % |
| User: common_user @ % |
| User: dba @ % |
| User: root @ % |
| User: slave @ % |
| User: wtgame @ % |
| User: root @ 127.0.0.1 |
| User: webman @ 127.0.0.1 |
| User: root @ 192.168.166.200 |
| User: cactiuser @ 192.168.166.202 |
| User: root @ 192.168.166.202 |
| User: @ localhost |
| User: cacti @ localhost |
| User: cactiuser @ localhost |
| User: dba @ localhost |
| User: extmail @ localhost |
| User: javauser @ localhost |
| User: root @ localhost |
| User: webman @ localhost |
| User: @ localhost.localdomain |
| User: root @ localhost.localdomain |
+—————————————+
21 rows in set (0.01 sec)
查看数据库中具体某个用户的权限
mysql show grants for cactiuser @ %
+——————————————————————————————————————-+
| Grants for cactiuser@% |
+——————————————————————————————————————-+
| GRANT PROCESS, SUPER ON *.* TO cactiuser @ % IDENTIFIED BY PASSWORD *DAFF917B80E3314B1ABECBA9DF8785AFD342CE89 |
| GRANT ALL PRIVILEGES ON `cacti`.* TO cactiuser @ % |
+——————————————————————————————————————-+
2 rows in set (0.00 sec)
mysql select * from mysql.user where user= cactiuser \G
*************************** 1. row ***************************
Host: %
User: cactiuser
Password: *DAFF917B80E3314B1ABECBA9DF8785AFD342CE89
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: Y
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: Y
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: N
Repl_client_priv: N
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
Event_priv: N
Trigger_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
查看 user 表结构 需要具体的项可结合表结构来查询
mysql desc mysql.user;
+———————–+———————————–+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+———————–+———————————–+——+—–+———+——-+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum(N , Y) | NO | | N | |
******************
******************
+———————–+———————————–+——+—–+———+——-+
39 rows in set (0.00 sec)
看完了这篇文章，相信你对“如何查看 MYSQL 数据库中所有用户及拥有权限”有了一定的了解，如果想了解更多相关知识，欢迎关注丸趣 TV 行业资讯频道，感谢各位的阅读！
