mysql> 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)