· 5 years ago · Feb 09, 2020, 11:42 PM
1CREATE TABLE IF NOT EXISTS mysql.host (Host char(60) binary DEFAULT '' NOT NULL,
2Db char(64) binary DEFAULT '' NOT NULL,
3Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
4Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
5Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
6Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
7Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
8Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
9Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
10References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
11Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
12Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
13Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
14Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
15Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
16Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
17Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
18Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
19Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
20Trigger_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
21PRIMARY KEY /*Host*/ (Host,Db) )
22engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin
23comment='Host privileges; Merged with database privileges';