13.5.4.10.SHOWGRANTS語法
13.5.4.10. SHOW
GRANTS語法
SHOW GRANTS FOR user
本語句列出了在為MySQL用戶賬戶復制權限時必須發布的GRANT語句。
mysql> SHOW GRANTS FOR 'root'@'localhost';
+---------------------------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
要對當前的會話列出權限,您可以使用以下語句之一:
SHOW GRANTS;
SHOW GRANTS FOR CURRENT_USER;
SHOW GRANTS FOR CURRENT_USER();