MyISAM |
9 |
Fixed |
0 |
0 |
0 |
1653562408959 |
1024 |
0 |
|
2006/19/07/2006 |
2006/19/07/2006 |
|
utf8_bin |
|
|
Host |
char(60) |
|
PRI |
|
|
Db |
char(64) |
|
PRI |
|
|
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') |
|
|
|
|
Grant_priv |
enum('N', 'Y') |
|
|
|
|
References_priv |
enum('N', 'Y') |
|
|
|
|
Index_priv |
enum('N', 'Y') |
|
|
|
|
Alter_priv |
enum('N', 'Y') |
|
|
|
|
Create_tmp_table_priv |
enum('N', 'Y') |
|
|
|
|
Lock_tables_priv |
enum('N', 'Y') |
|
|
Total: 14 column(s)
Total: 1 indexes(s)
CREATE TABLE `host` (
`Host` char(60) collate utf8_bin NOT NULL default '',
`Db` char(64) 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',
`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',
`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',
PRIMARY KEY (`Host`,`Db`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges; Merged with database privileges'
List of tables