SELECT * FROM `USER_PRIVILEGES`
ORDER BY `USER_PRIVILEGES`.`PRIVILEGE_TYPE` ASC
过滤行: |
GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE 1 | IS_GRANTABLE | |
---|---|---|---|---|
'root'@'localhost' | def | ALTER | YES | |
'mysqld'@'%' | def | ALTER | YES | |
'root'@'::1' | def | ALTER | YES | |
'root'@'127.0.0.1' | def | ALTER | YES | |
'mysqld'@'%' | def | ALTER ROUTINE | YES | |
'root'@'::1' | def | ALTER ROUTINE | YES | |
'root'@'127.0.0.1' | def | ALTER ROUTINE | YES | |
'root'@'localhost' | def | ALTER ROUTINE | YES | |
'root'@'::1' | def | CREATE | YES | |
'root'@'127.0.0.1' | def | CREATE | YES | |
'root'@'localhost' | def | CREATE | YES | |
'mysqld'@'%' | def | CREATE | YES | |
'mysqld'@'%' | def | CREATE ROUTINE | YES | |
'root'@'::1' | def | CREATE ROUTINE | YES | |
'root'@'127.0.0.1' | def | CREATE ROUTINE | YES | |
'root'@'localhost' | def | CREATE ROUTINE | YES | |
'root'@'localhost' | def | CREATE TABLESPACE | YES | |
'mysqld'@'%' | def | CREATE TABLESPACE | YES | |
'root'@'::1' | def | CREATE TABLESPACE | YES | |
'root'@'127.0.0.1' | def | CREATE TABLESPACE | YES | |
'root'@'127.0.0.1' | def | CREATE TEMPORARY TABLES | YES | |
'root'@'localhost' | def | CREATE TEMPORARY TABLES | YES | |
'mysqld'@'%' | def | CREATE TEMPORARY TABLES | YES | |
'root'@'::1' | def | CREATE TEMPORARY TABLES | YES | |
'mysqld'@'%' | def | CREATE USER | YES |
过滤行: |