Debian Codegraph @

mysql-test/suite/auth_sec/r/server_withssl_client_withssl.result

raw
1
2
3 ======================================================================================
4 Checking the user access with SSL through user created with mysql_native_password plugin
5 ======================================================================================
6
7 Creating a user with the mysql_native_plugin
8 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
9 set password for 'Tanjotuser1'@'localhost' = 'abc';
10 GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
11 **** connecting client using the ssl credentials
12 current_user()
13 Tanjotuser1@localhost
14 **** connecting client using the ssl credentials
15 current_user()
16 Tanjotuser1@localhost
17 **** connecting client using the ssl credentials
18 current_user()
19 Tanjotuser1@localhost
20 **** connecting client using the ssl credentials
21 current_user()
22 Tanjotuser1@localhost
23 **** connecting client using the ssl credentials
24 current_user()
25 Tanjotuser1@localhost
26 **** connecting client using the ssl credentials
27 current_user()
28 Tanjotuser1@localhost
29 DROP USER 'Tanjotuser1'@'localhost';
30
31
32 ======================================================================================
33 Checking the user access with SSL through user created with sha256_password plugin
34 ======================================================================================
35
36 Creating a user with the sha256_password plugin
37 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
38 set password for 'Tanjotuser1'@'localhost' = 'abc';
39 GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
40 **** connecting client using the ssl credentials
41 current_user()
42 Tanjotuser1@localhost
43 **** connecting client using the ssl credentials
44 current_user()
45 Tanjotuser1@localhost
46 **** connecting client using the ssl credentials
47 current_user()
48 Tanjotuser1@localhost
49 **** connecting client using the ssl credentials
50 current_user()
51 Tanjotuser1@localhost
52 **** connecting client using the ssl credentials
53 current_user()
54 Tanjotuser1@localhost
55 **** connecting client using the ssl credentials
56 current_user()
57 Tanjotuser1@localhost
58 DROP USER 'Tanjotuser1'@'localhost';
59
60
61 =================================================================================================
62 Starting the server with the default authentication sha256_password
63 =================================================================================================
64
65 # Restart server with default-authentication-plugin=sha256_password;
66
67
68 ======================================================================================
69 Checking the user access with SSL through user created with mysql_native_password plugin
70 ======================================================================================
71
72 Creating a user with the mysql_old_plugin
73 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
74 set password for 'Tanjotuser1'@'localhost' = 'abc';
75 GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
76 **** connecting client using the ssl credentials
77 current_user()
78 Tanjotuser1@localhost
79 **** connecting client using the ssl credentials
80 current_user()
81 Tanjotuser1@localhost
82 **** connecting client using the ssl credentials
83 current_user()
84 Tanjotuser1@localhost
85 **** connecting client using the ssl credentials
86 current_user()
87 Tanjotuser1@localhost
88 **** connecting client using the ssl credentials
89 current_user()
90 Tanjotuser1@localhost
91 **** connecting client using the ssl credentials
92 current_user()
93 Tanjotuser1@localhost
94 DROP USER 'Tanjotuser1'@'localhost';
95
96
97 ======================================================================================
98 Checking the user access with SSL through user created with sha256_password plugin
99 ======================================================================================
100
101 Creating a user with the sha256_plugin
102 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
103 set password for 'Tanjotuser1'@'localhost' = 'abc';
104 GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
105 **** connecting client using the ssl credentials
106 current_user()
107 Tanjotuser1@localhost
108 2 for GLOBAL Expected
109 2 for SESSION Expected
110 **** connecting client using the ssl credentials
111 current_user()
112 Tanjotuser1@localhost
113 2 for GLOBAL Expected
114 2 for SESSION Expected
115 **** connecting client using the ssl credentials
116 current_user()
117 Tanjotuser1@localhost
118 2 for GLOBAL Expected
119 2 for SESSION Expected
120 **** connecting client using the ssl credentials
121 current_user()
122 Tanjotuser1@localhost
123 2 for GLOBAL Expected
124 2 for SESSION Expected
125 DROP USER 'Tanjotuser1'@'localhost';
126 # restart: