from /usr/local/mysql/share

-- The system tables of MySQL Server
USE MYSQL (root access!)

select Host, Db, User,

select Host, Db,

select Host, User, Password,

tables_priv ( Host , Db , User , Table_name , Grantor , Timestamp ,

    primary key (Host,Db,User,Table_name), key Grantor (Grantor) )

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 MSSQLMYSQL323 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
) , comment ,
    primary key (db,name,type) ) comment='Stored Procedures';

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 )