如何在MySQL中显示root的GRANTS？-tutorial mysql-php.cn

如何在MySQL中显示root的GRANTS？

WBOY

Lepaskan： 2023-09-07 20:05:08

ke hadapan

593 orang telah melayarinya

如何在MySQL中显示root的GRANTS？

对于此操作，请使用以下语法，其中我们使用了 SHOW GRANTS −

SHOW GRANTS FOR &#39;yourUserName&#39;@&#39;yourHostName&#39;;

Salin selepas log masuk

HostName 可以是“%”或 localhost。

让我们实现上述语法以显示来自 ROOT 的授权 -

mysql> SHOW GRANTS FOR &#39;root&#39;@&#39;%&#39; ;

Salin selepas log masuk

输出

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@%                                                                                                                                                                                                                                                                                                                                                                                |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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 `root`@`%` WITH GRANT OPTION |
| GRANT BACKUP_ADMIN,BINLOG_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GROUP_REPLICATION_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SET_USER_ID,SYSTEM_VARIABLES_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`%`                                                                                                                            |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.17 sec)

Salin selepas log masuk

Atas ialah kandungan terperinci 如何在MySQL中显示root的GRANTS？. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!