-- The system tables of MySQL Server
USE MYSQL
(root access!)
select Host, Db, User,
select Host, User, Password,
tables_priv ( Host , Db , User , Table_name , Grantor , Timestamp ,
columns_priv ( Host , Db , User , Table_name , Column_name , Timestamp , Column_priv set(Select,Insert,Update,References ,
primary key (Host,Db,User,Table_name,Column_name) ) comment='Column privileges';
proc ( db , name , type enum(FUNCTION,PROCEDURE) , specific_name , language enum(SQL DEFAULT 'SQL' ),
sql_data_access enum(CONTAINS_SQL, NO_SQL, READS_SQL_DATA, MODIFIES_SQL_DATA ) DEFAULT 'CONTAINS_SQL' ,
is_deterministic , security_type enum(INVOKER,DEFINER DEFAULT DEFINER,
param_list , returns , body long, definer , created timestamp, modified timestamp,
sql_mode set(
REAL_AS_FLOAT | PIPES_AS_CONCAT | ANSI_QUOTES | IGNORE_SPACE | NOT_USED |
POSTGRESQL | ORACLE | MSSQL | MYSQL323 | MYSQL40 DB2 MAXDB |
NO_KEY_OPTIONS | NO_TABLE_OPTIONS | NO_FIELD_OPTIONS | ANSI | NO_DIR_IN_CREATE |
NO_AUTO_VALUE_ON_ZERO | NO_BACKSLASH_ESCAPES | STRICT_TRANS_TABLES | STRICT_ALL_TABLES | |
NO_ZERO_IN_DATE | NO_ZERO_DATE | INVALID_DATES | NO__SUBTRACTION | ERROR_FOR_DIVISION_BY_ZERO |
NO_AUTO_CREATE_USER | HIGH_NOT_PRECEDENCE | ONLY_FULL_GROUP_BY | TRADITIONAL |
procs_priv ( Host , Db , User , Routine_name , Routine_type enum(FUNCTION,PROCEDURE ,
Grantor , Proc_priv set(Execute,Alter Routine,Grant , Timestamp ,
primary key (Host,Db,User,Routine_name,Routine_type), key Grantor (Grantor) ) comment='Procedure privileges';
time_zone_name ( Name , Time_zone_id , primary key Name (Name) )
time_zone ( Time_zone_id auto_increment, Use_leap_seconds)
time_zone_transition ( Time_zone_id , Transition_time , Transition_type_id
time_zone_transition_type ( Time_zone_id , Transition_type_id , Offset , Is_DST , Abbreviation )
time_zone_leap_second ( Transition_time , Correction )
help_topic ( help_topic_id , name , help_category_id small , description, example , url )
help_category ( help_category_id small , name , parent_category_id , url )
help_relation ( help_topic_id references help_topic, help_keyword_id references help_keyword)
help_keyword ( help_keyword_id , name )