· 6 years ago · Jul 22, 2019, 04:56 PM
1DROP TABLE IF EXISTS `user`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `user` (
5 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
6 `User` char(80) COLLATE utf8_bin NOT NULL DEFAULT '',
7 `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
8 `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
9 `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
10 `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
11 `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
12 `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
13 `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
14 `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
15 `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
16 `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
17 `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
18 `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
19 `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
20 `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
21 `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
22 `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
23 `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
24 `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
25 `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
26 `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
27 `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
28 `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
29 `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
30 `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
31 `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
32 `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
33 `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
34 `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
35 `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
36 `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
37 `Delete_history_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
38 `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
39 `ssl_cipher` blob NOT NULL,
40 `x509_issuer` blob NOT NULL,
41 `x509_subject` blob NOT NULL,
42 `max_questions` int(11) unsigned NOT NULL DEFAULT 0,
43 `max_updates` int(11) unsigned NOT NULL DEFAULT 0,
44 `max_connections` int(11) unsigned NOT NULL DEFAULT 0,
45 `max_user_connections` int(11) NOT NULL DEFAULT 0,
46 `plugin` char(64) CHARACTER SET latin1 NOT NULL DEFAULT '',
47 `authentication_string` text COLLATE utf8_bin NOT NULL,
48 `password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
49 `is_role` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
50 `default_role` char(80) COLLATE utf8_bin NOT NULL DEFAULT '',
51 `max_statement_time` decimal(12,6) NOT NULL DEFAULT 0.000000,
52 PRIMARY KEY (`Host`,`User`)
53) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';
54/*!40101 SET character_set_client = @saved_cs_client */;
55
56--
57-- Dumping data for table `user`
58--
59
60LOCK TABLES `user` WRITE;
61/*!40000 ALTER TABLE `user` DISABLE KEYS */;
62INSERT INTO `user` VALUES ('localhost','root','*283D2EB2C0CA0787F92B2639DEFF1D1A258D4797','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N','N','',0.000000),('127.0.0.1','root','*283D2EB2C0CA0787F92B2639DEFF1D1A258D4797','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N','N','',0.000000),('::1','root','*283D2EB2C0CA0787F92B2639DEFF1D1A258D4797','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N','N','',0.000000);
63/*!40000 ALTER TABLE `user` ENABLE KEYS */;
64UNLOCK TABLES;