Server: mysql wampserver »Database: information_schema »Table: USER_PRIVILEGES
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
Showing rows 0 - 24 (85 total, Query took 0.0007 sec)
SELECT * FROM `USER_PRIVILEGES`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]


GRANTEE TABLE_CATALOG PRIVILEGE_TYPE IS_GRANTABLE
'root'@'localhost' def SELECT YES
'root'@'localhost' def INSERT YES
'root'@'localhost' def UPDATE YES
'root'@'localhost' def DELETE YES
'root'@'localhost' def CREATE YES
'root'@'localhost' def DROP YES
'root'@'localhost' def RELOAD YES
'root'@'localhost' def SHUTDOWN YES
'root'@'localhost' def PROCESS YES
'root'@'localhost' def FILE YES
'root'@'localhost' def REFERENCES YES
'root'@'localhost' def INDEX YES
'root'@'localhost' def ALTER YES
'root'@'localhost' def SHOW DATABASES YES
'root'@'localhost' def SUPER YES
'root'@'localhost' def CREATE TEMPORARY TABLES YES
'root'@'localhost' def LOCK TABLES YES
'root'@'localhost' def EXECUTE YES
'root'@'localhost' def REPLICATION SLAVE YES
'root'@'localhost' def REPLICATION CLIENT YES
'root'@'localhost' def CREATE VIEW YES
'root'@'localhost' def SHOW VIEW YES
'root'@'localhost' def CREATE ROUTINE YES
'root'@'localhost' def ALTER ROUTINE YES
'root'@'localhost' def CREATE USER YES

Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view