共計 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 行業資訊頻道，感謝各位的閱讀！
