Debian Codegraph @

mysql-test/suite/interactive_utilities/r/mysql_secure_installation_ssl.result

raw
1 SELECT plugin into @plugin from mysql.user where user= 'root' and host='localhost';
2 SELECT password_last_changed into @plc from mysql.user where user= 'root' and host='localhost';
3 SELECT authentication_string into @auth_str from mysql.user where user= 'root' and host='localhost';
4 SELECT user_attributes into @user_attrib from mysql.user where user='root' and host='localhost';
5 SELECT plugin into @sys_plugin from mysql.user where user= 'mysql.sys' and host='localhost';
6 SELECT password_last_changed into @sys_plc from mysql.user where user= 'mysql.sys' and host='localhost';
7 SELECT authentication_string into @sys_auth_str from mysql.user where user= 'mysql.sys' and host='localhost';
8 update mysql.user set plugin= 'sha256_password', authentication_string= '' where user='root' and host='localhost';
9 FLUSH PRIVILEGES;
10 SET PASSWORD='123';
11 call mtr.add_suppression("Dictionary file not specified");
12 mysql_secure_installation: [Warning] Using a password on the command line interface can be insecure.
13
14 Securing the MySQL server deployment.
15
16
17 VALIDATE PASSWORD COMPONENT can be used to test passwords
18 and improve security. It checks the strength of password
19 and allows the users to set only those passwords which are
20 secure enough. Would you like to setup VALIDATE PASSWORD component?
21
22 Press y|Y for Yes, any other key for No: Using existing password for root.
23 Change the password for root ? ((Press y|Y for Yes, any other key for No) :
24 ... skipping.
25 By default, a MySQL installation has an anonymous user,
26 allowing anyone to log into MySQL without having to have
27 a user account created for them. This is intended only for
28 testing, and to make the installation go a bit smoother.
29 You should remove them before moving into a production
30 environment.
31
32 Remove anonymous users? (Press y|Y for Yes, any other key for No) :
33 ... skipping.
34
35
36 Normally, root should only be allowed to connect from
37 'localhost'. This ensures that someone cannot guess at
38 the root password from the network.
39
40 Disallow root login remotely? (Press y|Y for Yes, any other key for No) :
41 ... skipping.
42 By default, MySQL comes with a database named 'test' that
43 anyone can access. This is also intended only for testing,
44 and should be removed before moving into a production
45 environment.
46
47
48 Remove test database and access to it? (Press y|Y for Yes, any other key for No) :
49 ... skipping.
50 Reloading the privilege tables will ensure that all changes
51 made so far will take effect immediately.
52
53 Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Execution number 1 was successful
54 mysql_secure_installation: [Warning] Using a password on the command line interface can be insecure.
55
56 Securing the MySQL server deployment.
57
58
59 VALIDATE PASSWORD COMPONENT can be used to test passwords
60 and improve security. It checks the strength of password
61 and allows the users to set only those passwords which are
62 secure enough. Would you like to setup VALIDATE PASSWORD component?
63
64 Press y|Y for Yes, any other key for No:
65 There are three levels of password validation policy:
66
67 LOW Length >= 8
68 MEDIUM Length >= 8, numeric, mixed case, and special characters
69 STRONG Length >= 8, numeric, mixed case, special characters and dictionary file
70
71 Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: Using existing password for root.
72
73 Estimated strength of the password: 0
74 Change the password for root ? ((Press y|Y for Yes, any other key for No) :
75 New password:
76
77 Re-enter new password:
78
79 Estimated strength of the password: 100
80 Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : By default, a MySQL installation has an anonymous user,
81 allowing anyone to log into MySQL without having to have
82 a user account created for them. This is intended only for
83 testing, and to make the installation go a bit smoother.
84 You should remove them before moving into a production
85 environment.
86
87 Remove anonymous users? (Press y|Y for Yes, any other key for No) : Success.
88
89
90 Normally, root should only be allowed to connect from
91 'localhost'. This ensures that someone cannot guess at
92 the root password from the network.
93
94 Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Success.
95
96 By default, MySQL comes with a database named 'test' that
97 anyone can access. This is also intended only for testing,
98 and should be removed before moving into a production
99 environment.
100
101
102 Remove test database and access to it? (Press y|Y for Yes, any other key for No) : - Dropping test database...
103 Success.
104
105 - Removing privileges on test database...
106 Success.
107
108 Reloading the privilege tables will ensure that all changes
109 made so far will take effect immediately.
110
111 Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Success.
112
113 All done!
114 CREATE DATABASE test;
115 REPLACE INTO mysql.user VALUES ('localhost','root','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,'mysql_native_password','','N',NULL,NULL,'N','Y','Y', NULL, NULL,NULL,NULL);
116 REPLACE INTO mysql.user VALUES ('localhost','mysql.sys','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','N','N','N','','','','',0,0,0,0,'mysql_native_password','*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE','N',NULL,NULL,'Y','N','N', NULL, NULL,NULL,NULL);
117 INSERT INTO mysql.db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y');
118 UNINSTALL COMPONENT "file://component_validate_password";
119 UPDATE mysql.user SET password_last_changed=@plc, authentication_string=@auth_str, plugin= @plugin, user_attributes=@user_attrib where user='root';
120 UPDATE mysql.user SET password_last_changed=@sys_plc, authentication_string=@sys_auth_str, plugin= @sys_plugin where user='mysql.sys';
121 FLUSH PRIVILEGES;