MyISAM |
9 |
Dynamic |
2 |
88 |
216 |
4294967295 |
2048 |
40 |
|
2006/19/07/2006 |
2006/18/11/2006 |
|
utf8_bin |
|
|
Host |
varchar(60) |
|
PRI |
|
|
User |
varchar(16) |
|
PRI |
|
|
Password |
varchar(41) |
|
|
|
|
Select_priv |
enum('N', 'Y') |
|
|
|
|
Insert_priv |
enum('N', 'Y') |
|
|
|
|
Update_priv |
enum('N', 'Y') |
|
|
|
|
Delete_priv |
enum('N', 'Y') |
|
|
|
|
Create_priv |
enum('N', 'Y') |
|
|
|
|
Drop_priv |
enum('N', 'Y') |
|
|
|
|
Reload_priv |
enum('N', 'Y') |
|
|
|
|
Shutdown_priv |
enum('N', 'Y') |
|
|
|
|
Process_priv |
enum('N', 'Y') |
|
|
|
|
File_priv |
enum('N', 'Y') |
|
|
|
|
Grant_priv |
enum('N', 'Y') |
|
|
|
|
References_priv |
enum('N', 'Y') |
|
|
|
|
Index_priv |
enum('N', 'Y') |
|
|
|
|
Alter_priv |
enum('N', 'Y') |
|
|
|
|
Show_db_priv |
enum('N', 'Y') |
|
|
|
|
Super_priv |
enum('N', 'Y') |
|
|
|
|
Create_tmp_table_priv |
enum('N', 'Y') |
|
|
|
|
Lock_tables_priv |
enum('N', 'Y') |
|
|
|
|
Execute_priv |
enum('N', 'Y') |
|
|
|
|
Repl_slave_priv |
enum('N', 'Y') |
|
|
|
|
Repl_client_priv |
enum('N', 'Y') |
|
|
|
|
ssl_type |
enum('', 'ANY', 'X509', 'SPECIFIED') |
|
|
|
|
ssl_cipher |
blob |
|
|
|
|
x509_issuer |
blob |
|
|
|
|
x509_subject |
blob |
|
|
|
|
max_questions |
int(11) unsigned |
|
|
|
|
max_updates |
int(11) unsigned |
|
|
|
|
max_connections |
int(11) unsigned |
|
|
Total: 31 column(s)
Total: 1 indexes(s)
CREATE TABLE `user` (
`Host` varchar(60) collate utf8_bin NOT NULL default '',
`User` varchar(16) collate utf8_bin NOT NULL default '',
`Password` varchar(41) collate utf8_bin NOT NULL default '',
`Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Reload_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Shutdown_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Process_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`File_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Show_db_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Super_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Repl_slave_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`Repl_client_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
`ssl_type` enum('','ANY','X509','SPECIFIED') character set utf8 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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'
List of tables