rendered paste bodymysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| doudou |
| mangos |
| mysql |
| realmd |
+--------------------+
5 rows in set (0.11 sec)
mysql> use information_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema |
+---------------------------------------+
| CHARACTER_SETS |
| COLLATIONS |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS |
| COLUMN_PRIVILEGES |
| KEY_COLUMN_USAGE |
| ROUTINES |
| SCHEMATA |
| SCHEMA_PRIVILEGES |
| STATISTICS |
| TABLES |
| TABLE_CONSTRAINTS |
| TABLE_PRIVILEGES |
| TRIGGERS |
| USER_PRIVILEGES |
| VIEWS |
+---------------------------------------+
16 rows in set (0.12 sec)
mysql> select * from USER_PRIVILEGES;
+--------------------------------+---------------+-------------------------+--------------+
| GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+--------------------------------+---------------+-------------------------+--------------+
| 'root'@'localhost' | NULL | SELECT | YES |
| 'root'@'localhost' | NULL | INSERT | YES |
| 'root'@'localhost' | NULL | UPDATE | YES |
| 'root'@'localhost' | NULL | DELETE | YES |
| 'root'@'localhost' | NULL | CREATE | YES |
| 'root'@'localhost' | NULL | DROP | YES |
| 'root'@'localhost' | NULL | RELOAD | YES |
| 'root'@'localhost' | NULL | SHUTDOWN | YES |
| 'root'@'localhost' | NULL | PROCESS | YES |
| 'root'@'localhost' | NULL | FILE | YES |
| 'root'@'localhost' | NULL | REFERENCES | YES |
| 'root'@'localhost' | NULL | INDEX | YES |
| 'root'@'localhost' | NULL | ALTER | YES |
| 'root'@'localhost' | NULL | SHOW DATABASES | YES |
| 'root'@'localhost' | NULL | SUPER | YES |
| 'root'@'localhost' | NULL | CREATE TEMPORARY TABLES | YES |
| 'root'@'localhost' | NULL | LOCK TABLES | YES |
| 'root'@'localhost' | NULL | EXECUTE | YES |
| 'root'@'localhost' | NULL | REPLICATION SLAVE | YES |
| 'root'@'localhost' | NULL | REPLICATION CLIENT | YES |
| 'root'@'localhost' | NULL | CREATE VIEW | YES |
| 'root'@'localhost' | NULL | SHOW VIEW | YES |
| 'root'@'localhost' | NULL | CREATE ROUTINE | YES |
| 'root'@'localhost' | NULL | ALTER ROUTINE | YES |
| 'root'@'localhost' | NULL | CREATE USER | YES |
| 'root'@'PCServeur1' | NULL | SELECT | YES |
| 'root'@'PCServeur1' | NULL | INSERT | YES |
| 'root'@'PCServeur1' | NULL | UPDATE | YES |
| 'root'@'PCServeur1' | NULL | DELETE | YES |
| 'root'@'PCServeur1' | NULL | CREATE | YES |
| 'root'@'PCServeur1' | NULL | DROP | YES |
| 'root'@'PCServeur1' | NULL | RELOAD | YES |
| 'root'@'PCServeur1' | NULL | SHUTDOWN | YES |
| 'root'@'PCServeur1' | NULL | PROCESS | YES |
| 'root'@'PCServeur1' | NULL | FILE | YES |
| 'root'@'PCServeur1' | NULL | REFERENCES | YES |
| 'root'@'PCServeur1' | NULL | INDEX | YES |
| 'root'@'PCServeur1' | NULL | ALTER | YES |
| 'root'@'PCServeur1' | NULL | SHOW DATABASES | YES |
| 'root'@'PCServeur1' | NULL | SUPER | YES |
| 'root'@'PCServeur1' | NULL | CREATE TEMPORARY TABLES | YES |
| 'root'@'PCServeur1' | NULL | LOCK TABLES | YES |
| 'root'@'PCServeur1' | NULL | EXECUTE | YES |
| 'root'@'PCServeur1' | NULL | REPLICATION SLAVE | YES |
| 'root'@'PCServeur1' | NULL | REPLICATION CLIENT | YES |
| 'root'@'PCServeur1' | NULL | CREATE VIEW | YES |
| 'root'@'PCServeur1' | NULL | SHOW VIEW | YES |
| 'root'@'PCServeur1' | NULL | CREATE ROUTINE | YES |
| 'root'@'PCServeur1' | NULL | ALTER ROUTINE | YES |
| 'root'@'PCServeur1' | NULL | CREATE USER | YES |
| 'debian-sys-maint'@'localhost' | NULL | SELECT | YES |
| 'debian-sys-maint'@'localhost' | NULL | INSERT | YES |
| 'debian-sys-maint'@'localhost' | NULL | UPDATE | YES |
| 'debian-sys-maint'@'localhost' | NULL | DELETE | YES |
| 'debian-sys-maint'@'localhost' | NULL | CREATE | YES |
| 'debian-sys-maint'@'localhost' | NULL | DROP | YES |
| 'debian-sys-maint'@'localhost' | NULL | RELOAD | YES |
| 'debian-sys-maint'@'localhost' | NULL | SHUTDOWN | YES |
| 'debian-sys-maint'@'localhost' | NULL | PROCESS | YES |
| 'debian-sys-maint'@'localhost' | NULL | FILE | YES |
| 'debian-sys-maint'@'localhost' | NULL | REFERENCES | YES |
| 'debian-sys-maint'@'localhost' | NULL | INDEX | YES |
| 'debian-sys-maint'@'localhost' | NULL | ALTER | YES |
| 'debian-sys-maint'@'localhost' | NULL | SHOW DATABASES | YES |
| 'debian-sys-maint'@'localhost' | NULL | SUPER | YES |
| 'debian-sys-maint'@'localhost' | NULL | CREATE TEMPORARY TABLES | YES |
| 'debian-sys-maint'@'localhost' | NULL | LOCK TABLES | YES |
| 'debian-sys-maint'@'localhost' | NULL | EXECUTE | YES |
| 'debian-sys-maint'@'localhost' | NULL | REPLICATION SLAVE | YES |
| 'debian-sys-maint'@'localhost' | NULL | REPLICATION CLIENT | YES |
| 'thedoudou'@'%' | NULL | SELECT | NO |
| 'thedoudou'@'%' | NULL | INSERT | NO |
| 'thedoudou'@'%' | NULL | UPDATE | NO |
| 'thedoudou'@'%' | NULL | DELETE | NO |
| 'thedoudou'@'%' | NULL | CREATE | NO |
| 'thedoudou'@'%' | NULL | DROP | NO |
| 'thedoudou'@'%' | NULL | RELOAD | NO |
| 'thedoudou'@'%' | NULL | SHUTDOWN | NO |
| 'thedoudou'@'%' | NULL | PROCESS | NO |
| 'thedoudou'@'%' | NULL | FILE | NO |
| 'thedoudou'@'%' | NULL | REFERENCES | NO |
| 'thedoudou'@'%' | NULL | INDEX | NO |
| 'thedoudou'@'%' | NULL | ALTER | NO |
| 'thedoudou'@'%' | NULL | SHOW DATABASES | NO |
| 'thedoudou'@'%' | NULL | SUPER | NO |
| 'thedoudou'@'%' | NULL | CREATE TEMPORARY TABLES | NO |
| 'thedoudou'@'%' | NULL | LOCK TABLES | NO |
| 'thedoudou'@'%' | NULL | EXECUTE | NO |
| 'thedoudou'@'%' | NULL | REPLICATION SLAVE | NO |
| 'thedoudou'@'%' | NULL | REPLICATION CLIENT | NO |
| 'thedoudou'@'%' | NULL | CREATE VIEW | NO |
| 'thedoudou'@'%' | NULL | SHOW VIEW | NO |
| 'thedoudou'@'%' | NULL | CREATE ROUTINE | NO |
| 'thedoudou'@'%' | NULL | ALTER ROUTINE | NO |
| 'thedoudou'@'%' | NULL | CREATE USER | NO |
+--------------------------------+---------------+-------------------------+--------------+
95 rows in set (0.30 sec)