system_mysql_db.result 6.64 KB
Newer Older
1
show tables;
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Tables_in_db	table_type
columns_priv	BASE TABLE
db	BASE TABLE
func	BASE TABLE
help_category	BASE TABLE
help_keyword	BASE TABLE
help_relation	BASE TABLE
help_topic	BASE TABLE
host	BASE TABLE
proc	BASE TABLE
tables_priv	BASE TABLE
time_zone	BASE TABLE
time_zone_leap_second	BASE TABLE
time_zone_name	BASE TABLE
time_zone_transition	BASE TABLE
time_zone_transition_type	BASE TABLE
user	BASE TABLE
19 20 21
show create table db;
Table	Create Table
db	CREATE TABLE `db` (
22 23 24
  `Host` char(60) character set latin1 collate latin1_bin NOT NULL default '',
  `Db` char(64) character set latin1 collate latin1_bin NOT NULL default '',
  `User` char(16) character set latin1 collate latin1_bin NOT NULL default '',
25 26 27 28 29 30 31 32 33 34 35 36
  `Select_priv` enum('N','Y') NOT NULL default 'N',
  `Insert_priv` enum('N','Y') NOT NULL default 'N',
  `Update_priv` enum('N','Y') NOT NULL default 'N',
  `Delete_priv` enum('N','Y') NOT NULL default 'N',
  `Create_priv` enum('N','Y') NOT NULL default 'N',
  `Drop_priv` enum('N','Y') NOT NULL default 'N',
  `Grant_priv` enum('N','Y') NOT NULL default 'N',
  `References_priv` enum('N','Y') NOT NULL default 'N',
  `Index_priv` enum('N','Y') NOT NULL default 'N',
  `Alter_priv` enum('N','Y') NOT NULL default 'N',
  `Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') NOT NULL default 'N',
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
37 38
  `Create_view_priv` enum('N','Y') NOT NULL default 'N',
  `Show_view_priv` enum('N','Y') NOT NULL default 'N',
39 40
  PRIMARY KEY  (`Host`,`Db`,`User`),
  KEY `User` (`User`)
41
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Database privileges'
42 43 44
show create table host;
Table	Create Table
host	CREATE TABLE `host` (
45 46
  `Host` char(60) character set latin1 collate latin1_bin NOT NULL default '',
  `Db` char(64) character set latin1 collate latin1_bin NOT NULL default '',
47 48 49 50 51 52 53 54 55 56 57 58
  `Select_priv` enum('N','Y') NOT NULL default 'N',
  `Insert_priv` enum('N','Y') NOT NULL default 'N',
  `Update_priv` enum('N','Y') NOT NULL default 'N',
  `Delete_priv` enum('N','Y') NOT NULL default 'N',
  `Create_priv` enum('N','Y') NOT NULL default 'N',
  `Drop_priv` enum('N','Y') NOT NULL default 'N',
  `Grant_priv` enum('N','Y') NOT NULL default 'N',
  `References_priv` enum('N','Y') NOT NULL default 'N',
  `Index_priv` enum('N','Y') NOT NULL default 'N',
  `Alter_priv` enum('N','Y') NOT NULL default 'N',
  `Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') NOT NULL default 'N',
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
59 60
  `Create_view_priv` enum('N','Y') NOT NULL default 'N',
  `Show_view_priv` enum('N','Y') NOT NULL default 'N',
61
  PRIMARY KEY  (`Host`,`Db`)
62
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Host privileges;  Merged with database privileges'
63 64 65
show create table user;
Table	Create Table
user	CREATE TABLE `user` (
66 67 68
  `Host` varchar(60) character set latin1 collate latin1_bin NOT NULL default '',
  `User` varchar(16) character set latin1 collate latin1_bin NOT NULL default '',
  `Password` varchar(41) character set latin1 collate latin1_bin NOT NULL default '',
69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89
  `Select_priv` enum('N','Y') NOT NULL default 'N',
  `Insert_priv` enum('N','Y') NOT NULL default 'N',
  `Update_priv` enum('N','Y') NOT NULL default 'N',
  `Delete_priv` enum('N','Y') NOT NULL default 'N',
  `Create_priv` enum('N','Y') NOT NULL default 'N',
  `Drop_priv` enum('N','Y') NOT NULL default 'N',
  `Reload_priv` enum('N','Y') NOT NULL default 'N',
  `Shutdown_priv` enum('N','Y') NOT NULL default 'N',
  `Process_priv` enum('N','Y') NOT NULL default 'N',
  `File_priv` enum('N','Y') NOT NULL default 'N',
  `Grant_priv` enum('N','Y') NOT NULL default 'N',
  `References_priv` enum('N','Y') NOT NULL default 'N',
  `Index_priv` enum('N','Y') NOT NULL default 'N',
  `Alter_priv` enum('N','Y') NOT NULL default 'N',
  `Show_db_priv` enum('N','Y') NOT NULL default 'N',
  `Super_priv` enum('N','Y') NOT NULL default 'N',
  `Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') NOT NULL default 'N',
  `Execute_priv` enum('N','Y') NOT NULL default 'N',
  `Repl_slave_priv` enum('N','Y') NOT NULL default 'N',
  `Repl_client_priv` enum('N','Y') NOT NULL default 'N',
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
90 91
  `Create_view_priv` enum('N','Y') NOT NULL default 'N',
  `Show_view_priv` enum('N','Y') NOT NULL default 'N',
92 93 94 95 96 97 98 99
  `ssl_type` enum('','ANY','X509','SPECIFIED') NOT NULL default '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int(11) unsigned NOT NULL default '0',
  `max_updates` int(11) unsigned NOT NULL default '0',
  `max_connections` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Host`,`User`)
100
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Users and global privileges'
101 102 103
show create table func;
Table	Create Table
func	CREATE TABLE `func` (
104
  `name` char(64) character set latin1 collate latin1_bin NOT NULL default '',
105 106 107 108
  `ret` tinyint(1) NOT NULL default '0',
  `dl` char(128) NOT NULL default '',
  `type` enum('function','aggregate') NOT NULL default 'function',
  PRIMARY KEY  (`name`)
109
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='User defined functions'
110 111 112
show create table tables_priv;
Table	Create Table
tables_priv	CREATE TABLE `tables_priv` (
113 114 115 116
  `Host` char(60) character set latin1 collate latin1_bin NOT NULL default '',
  `Db` char(64) character set latin1 collate latin1_bin NOT NULL default '',
  `User` char(16) character set latin1 collate latin1_bin NOT NULL default '',
  `Table_name` char(64) character set latin1 collate latin1_bin NOT NULL default '',
117
  `Grantor` char(77) NOT NULL default '',
118
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
119 120 121 122
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') NOT NULL default '',
  `Column_priv` set('Select','Insert','Update','References') NOT NULL default '',
  PRIMARY KEY  (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
123
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table privileges'
124 125 126
show create table columns_priv;
Table	Create Table
columns_priv	CREATE TABLE `columns_priv` (
127 128 129 130 131
  `Host` char(60) character set latin1 collate latin1_bin NOT NULL default '',
  `Db` char(64) character set latin1 collate latin1_bin NOT NULL default '',
  `User` char(16) character set latin1 collate latin1_bin NOT NULL default '',
  `Table_name` char(64) character set latin1 collate latin1_bin NOT NULL default '',
  `Column_name` char(64) character set latin1 collate latin1_bin NOT NULL default '',
132
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
133 134
  `Column_priv` set('Select','Insert','Update','References') NOT NULL default '',
  PRIMARY KEY  (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
135
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Column privileges'
136
show tables;
serg@serg.mylan's avatar
serg@serg.mylan committed
137
Tables_in_test	table_type