SELECT * FROM `SCHEMA_PRIVILEGES`
过滤行: |
GRANTEE | TABLE_CATALOG | TABLE_SCHEMA | PRIVILEGE_TYPE | IS_GRANTABLE | |
---|---|---|---|---|---|
'pma'@'localhost' | def | phpmyadmin | SELECT | NO | |
'pma'@'localhost' | def | phpmyadmin | INSERT | NO | |
'pma'@'localhost' | def | phpmyadmin | UPDATE | NO | |
'pma'@'localhost' | def | phpmyadmin | DELETE | NO | |
'root'@'%' | def | mysql | SELECT | YES | |
'root'@'%' | def | mysql | INSERT | YES | |
'root'@'%' | def | mysql | UPDATE | YES | |
'root'@'%' | def | mysql | DELETE | YES | |
'root'@'%' | def | mysql | CREATE | YES | |
'root'@'%' | def | mysql | DROP | YES | |
'root'@'%' | def | mysql | REFERENCES | YES | |
'root'@'%' | def | mysql | INDEX | YES | |
'root'@'%' | def | mysql | ALTER | YES | |
'root'@'%' | def | mysql | CREATE TEMPORARY TABLES | YES | |
'root'@'%' | def | mysql | LOCK TABLES | YES | |
'root'@'%' | def | mysql | EXECUTE | YES | |
'root'@'%' | def | mysql | CREATE VIEW | YES | |
'root'@'%' | def | mysql | SHOW VIEW | YES | |
'root'@'%' | def | mysql | CREATE ROUTINE | YES | |
'root'@'%' | def | mysql | ALTER ROUTINE | YES | |
'root'@'%' | def | mysql | EVENT | YES | |
'root'@'%' | def | mysql | TRIGGER | YES | |
'mysqld'@'%' | def | mysql | SELECT | YES | |
'mysqld'@'%' | def | mysql | INSERT | YES | |
'mysqld'@'%' | def | mysql | UPDATE | YES |
过滤行: |