SHOW

Examples

help SHOW;
SHOW DATABASES;
SHOW GRANTS [FOR user];
SHOW GRANTS;
SHOW GRANTS FOR 'root'@'localhost';
SHOW GRANTS FOR CURRENT_USER;
SHOW GRANTS FOR CURRENT_USER();
(after executing “USE databasename”)
- SHOW TABLES;
- SHOW COLUMNS FROM tablename;