SELECT * FROM `USER_PRIVILEGES` ORDER BY `PRIVILEGE_TYPE` DESC
过滤行: |
GRANTEE | TABLE_CATALOG |
PRIVILEGE_TYPE ![]() |
IS_GRANTABLE | |
---|---|---|---|---|
''@'localhost' | def | USAGE | NO | |
'pma'@'localhost' | def | USAGE | NO | |
'root'@'%' | def | UPDATE | YES | |
'root'@'127.0.0.1' | def | UPDATE | YES | |
'root'@'::1' | def | UPDATE | YES | |
'root'@'localhost' | def | UPDATE | YES | |
'root'@'::1' | def | TRIGGER | YES | |
'root'@'localhost' | def | TRIGGER | YES | |
'root'@'%' | def | TRIGGER | YES | |
'root'@'127.0.0.1' | def | TRIGGER | YES | |
'root'@'127.0.0.1' | def | SUPER | YES | |
'root'@'::1' | def | SUPER | YES | |
'root'@'localhost' | def | SUPER | YES | |
'root'@'%' | def | SUPER | YES | |
'root'@'localhost' | def | SHUTDOWN | YES | |
'root'@'%' | def | SHUTDOWN | YES | |
'root'@'127.0.0.1' | def | SHUTDOWN | YES | |
'root'@'::1' | def | SHUTDOWN | YES | |
'root'@'%' | def | SHOW VIEW | YES | |
'root'@'127.0.0.1' | def | SHOW VIEW | YES | |
'root'@'::1' | def | SHOW VIEW | YES | |
'root'@'localhost' | def | SHOW VIEW | YES | |
'root'@'127.0.0.1' | def | SHOW DATABASES | YES | |
'root'@'::1' | def | SHOW DATABASES | YES | |
'root'@'localhost' | def | SHOW DATABASES | YES |
过滤行: |