show databases; \u information_schema describe USER_PRIVILEGES; select distinct grantee from user_Privileges; select * from user_Privileges; select distinct TABLE_SCHEMA from tables; +--------------------+ | TABLE_SCHEMA | +--------------------+ | information_schema | | dandrRace | | mysql | +--------------------+ select distinct TABLE_NAME from tables;
+---------------------------------------+ | TABLE_NAME | +---------------------------------------+ | CHARACTER_SETS | | COLLATIONS | | COLLATION_CHARACTER_SET_APPLICABILITY | | COLUMNS | | COLUMN_PRIVILEGES | | ENGINES | | EVENTS | | FILES | | GLOBAL_STATUS | | GLOBAL_VARIABLES | | KEY_COLUMN_USAGE | | PARTITIONS | | PLUGINS | | PROCESSLIST | | PROFILING | | REFERENTIAL_CONSTRAINTS | | ROUTINES | | SCHEMATA | | SCHEMA_PRIVILEGES | | SESSION_STATUS | | SESSION_VARIABLES | | STATISTICS | | TABLES | | TABLE_CONSTRAINTS | | TABLE_PRIVILEGES | | TRIGGERS | | USER_PRIVILEGES | | VIEWS | |
TABLE_ CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ ROWS | AVG_ ROW_ LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_ LENGTH | DATA_ FREE | AUTO_ INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_ OPTIONS | TABLE_COMMENT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | realger1_birding | birdingObservations | BASE TABLE | MyISAM | 10 | Dynamic | 3395 | 254 | 862912 | 281474976710655 | 193536 | 0 | NULL | 2016-05-11 09:17:42 | 2016-05-11 16:11:07 | 2016-05-11 09:17:42 | utf8_unicode_ci | NULL |