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                                 |
 


| racers                                | 
| columns_priv                          | 
| db                                    | 
| event                                 | 
| func                                  | 
| general_log                           | 
| help_category                         | 
| help_keyword                          | 
| help_relation                         | 
| help_topic                            | 
| host                                  | 
| ndb_binlog_index                      | 
| plugin                                | 
| proc                                  | 
| procs_priv                            | 
| servers                               | 
| slow_log                              | 
| tables_priv                           | 
| time_zone                             | 
| time_zone_leap_second                 | 
| time_zone_name                        | 
| time_zone_transition                  | 
| time_zone_transition_type             | 
| user                                  | 
+---------------------------------------+

describe  TABLES;
+-----------------+---------------------+------+-----+---------+-------+
| Field           | Type                | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------+-------+
| TABLE_CATALOG   | varchar(512)        | YES  |     | NULL    |       | 
| TABLE_SCHEMA    | varchar(64)         | NO   |     |         |       | 
| TABLE_NAME      | varchar(64)         | NO   |     |         |       | 
| TABLE_TYPE      | varchar(64)         | NO   |     |         |       | 
| ENGINE          | varchar(64)         | YES  |     | NULL    |       | 
| VERSION         | bigint(21) unsigned | YES  |     | NULL    |       | 
| ROW_FORMAT      | varchar(10)         | YES  |     | NULL    |       | 
| TABLE_ROWS      | bigint(21) unsigned | YES  |     | NULL    |       | 
| AVG_ROW_LENGTH  | bigint(21) unsigned | YES  |     | NULL    |       | 
| DATA_LENGTH     | bigint(21) unsigned | YES  |     | NULL    |       | 
| MAX_DATA_LENGTH | bigint(21) unsigned | YES  |     | NULL    |       | 
| INDEX_LENGTH    | bigint(21) unsigned | YES  |     | NULL    |       | 
| DATA_FREE       | bigint(21) unsigned | YES  |     | NULL    |       | 
| AUTO_INCREMENT  | bigint(21) unsigned | YES  |     | NULL    |       | 
| CREATE_TIME     | datetime            | YES  |     | NULL    |       | 
| UPDATE_TIME     | datetime            | YES  |     | NULL    |       | 
| CHECK_TIME      | datetime            | YES  |     | NULL    |       | 
| TABLE_COLLATION | varchar(32)         | YES  |     | NULL    |       | 
| CHECKSUM        | bigint(21) unsigned | YES  |     | NULL    |       | 
| CREATE_OPTIONS  | varchar(255)        | YES  |     | NULL    |       | 
| TABLE_COMMENT   | varchar(80)         | NO   |     |         |       | 
+-----------------+---------------------+------+-----+---------+-------+


describe  COLUMNS;

+--------------------------+---------------------+------+-----+---------+-------+
| Field                    | Type                | Null | Key | Default | Extra |
+--------------------------+---------------------+------+-----+---------+-------+
| TABLE_CATALOG            | varchar(512)        | YES  |     | NULL    |       | 
| TABLE_SCHEMA             | varchar(64)         | NO   |     |         |       | 
| TABLE_NAME               | varchar(64)         | NO   |     |         |       | 
| COLUMN_NAME              | varchar(64)         | NO   |     |         |       | 
| ORDINAL_POSITION         | bigint(21) unsigned | NO   |     | 0       |       | 
| COLUMN_DEFAULT           | longtext            | YES  |     | NULL    |       | 
| IS_NULLABLE              | varchar(3)          | NO   |     |         |       | 
| DATA_TYPE                | varchar(64)         | NO   |     |         |       | 
| CHARACTER_MAXIMUM_LENGTH | bigint(21) unsigned | YES  |     | NULL    |       | 
| CHARACTER_OCTET_LENGTH   | bigint(21) unsigned | YES  |     | NULL    |       | 
| NUMERIC_PRECISION        | bigint(21) unsigned | YES  |     | NULL    |       | 
| NUMERIC_SCALE            | bigint(21) unsigned | YES  |     | NULL    |       | 
| CHARACTER_SET_NAME       | varchar(32)         | YES  |     | NULL    |       | 
| COLLATION_NAME           | varchar(32)         | YES  |     | NULL    |       | 
| COLUMN_TYPE              | longtext            | NO   |     | NULL    |       | 
| COLUMN_KEY               | varchar(3)          | NO   |     |         |       | 
| EXTRA                    | varchar(27)         | NO   |     |         |       | 
| PRIVILEGES               | varchar(80)         | NO   |     |         |       | 
| COLUMN_COMMENT           | varchar(255)        | NO   |     |         |       | 
+--------------------------+---------------------+------+-----+---------+-------+

describe  CHARACTER_SETS;
describe  COLLATIONS;
describe  COLLATION_CHARACTER_SET_APPLICABILITY;
describe  COLUMN_PRIVILEGES;
describe  KEY_COLUMN_USAGE;
describe  PROFILING;
describe  ROUTINES;
describe  SCHEMATA;
describe  SCHEMA_PRIVILEGES;
describe  STATISTICS;
describe  TABLE_CONSTRAINTS; 
describe  TABLE_PRIVILEGES;
describe  TRIGGERS;

describe  VIEWS;

SELECT 
 ENGINE, 
 TABLE_TYPE,
 TABLE_NAME,
 TABLE_SCHEMA,
 TABLE_CATALOG,
 MAX_DATA_LENGTH,
 DATA_LENGTH,
 AVG_ROW_LENGTH,
 TABLE_ROWS,
 ROW_FORMAT,
 VERSION, 
 DATA_FREE,
 AUTO_INCREMENT,
 CREATE_TIME, UPDATE_TIME, CHECK_TIME,
 TABLE_COLLATION,
 CHECKSUM,
 CREATE_OPTIONS,
 TABLE_COMMENT,
 DATA_FREE,
 INDEX_LENGTH

 FROM TABLES ;