· 8 years ago · Mar 09, 2018, 06:42 PM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8
9
10CREATE TABLE IF NOT EXISTS `user` (
11 `Host` char(60) collate utf8_bin NOT NULL default '',
12 `User` char(16) collate utf8_bin NOT NULL default '',
13 `Password` char(41) character set latin1 collate latin1_bin NOT NULL default '',
14 `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
15 `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
16 `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
17 `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
18 `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
19 `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
20 `Reload_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
21 `Shutdown_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
22 `Process_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
23 `File_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
24 `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
25 `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
26 `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
27 `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
28 `Show_db_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
29 `Super_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
30 `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
31 `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
32 `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
33 `Repl_slave_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
34 `Repl_client_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
35 `Create_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
36 `Show_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
37 `Create_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
38 `Alter_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
39 `Create_user_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
40 `ssl_type` enum('','ANY','X509','SPECIFIED') character set utf8 NOT NULL default '',
41 `ssl_cipher` blob NOT NULL,
42 `x509_issuer` blob NOT NULL,
43 `x509_subject` blob NOT NULL,
44 `max_questions` int(11) unsigned NOT NULL default '0',
45 `max_updates` int(11) unsigned NOT NULL default '0',
46 `max_connections` int(11) unsigned NOT NULL default '0',
47 `max_user_connections` int(11) unsigned NOT NULL default '0',
48 PRIMARY KEY (`Host`,`User`)
49) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';
50
51INSERT INTO `user` (`Host`, `User`, `Password`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`) VALUES
52('%', 'trofian', '*4FEA2B9BCFA504C13DD3DF3F967D772A39B8AD48', '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),
53('109.198.231.173', 'Lefan', '*C2362DCE76814D222F83563F18D256D2F6FC6550', '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),
54('localhost', 'phpmy', '*AB4C091717EEDA80E9DF6420BECA845C6F41CF5E', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0),
55('109.198.231.173', 'lefan', '*C2362DCE76814D222F83563F18D256D2F6FC6550', '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),
56('localhost', 'Lefan', '*DE061F8EED6CA16E6867E5F0FC805430AC5ABD64', '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);