Debian Codegraph @

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

raw
1
2
3 ======================================================================================
4 Checking the user access with SSL through user created with mysql_native_password plugin
5 ======================================================================================
6
7 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
8 set password for 'Tanjotuser1'@'localhost' = 'abc';
9 **** connecting client using the ssl credentials
10 current_user()
11 Tanjotuser1@localhost
12 **** connecting client using the ssl credentials
13 current_user()
14 Tanjotuser1@localhost
15 **** connecting client using the ssl credentials
16 current_user()
17 Tanjotuser1@localhost
18 **** connecting client using the ssl credentials
19 current_user()
20 Tanjotuser1@localhost
21 **** connecting client using the ssl credentials
22 current_user()
23 Tanjotuser1@localhost
24 **** connecting client using the ssl credentials
25 current_user()
26 Tanjotuser1@localhost
27 DROP USER 'Tanjotuser1'@'localhost';
28
29
30 ======================================================================================
31 Checking the user access with SSL through user created with sha256_password plugin
32 ======================================================================================
33
34 Creating a user with the sha256_password
35 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
36 set password for 'Tanjotuser1'@'localhost' = 'abc';
37 **** connecting client using the ssl credentials
38 current_user()
39 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 DROP USER 'Tanjotuser1'@'localhost';
56
57
58 =================================================================================================
59 Starting the server with the default authentication sha256_password
60 =================================================================================================
61
62 # Restart server with default-authentication-plugin=sha256_password;
63
64
65 ======================================================================================
66 Checking the user access with SSL through user created with mysql_native_password plugin
67 ======================================================================================
68
69 Creating a user with the mysql_native_password
70 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
71 set password for 'Tanjotuser1'@'localhost' = 'abc';
72 **** connecting client using the ssl credentials
73 current_user()
74 Tanjotuser1@localhost
75 2 for GLOBAL Expected
76 0 for SESSION Expected
77 **** connecting client using the ssl credentials
78 current_user()
79 Tanjotuser1@localhost
80 2 for GLOBAL Expected
81 0 for SESSION Expected
82 **** connecting client using the ssl credentials
83 current_user()
84 Tanjotuser1@localhost
85 2 for GLOBAL Expected
86 0 for SESSION Expected
87 **** connecting client using the ssl credentials
88 current_user()
89 Tanjotuser1@localhost
90 2 for GLOBAL Expected
91 0 for SESSION Expected
92 **** connecting client using the ssl credentials
93 current_user()
94 Tanjotuser1@localhost
95 2 for GLOBAL Expected
96 0 for SESSION Expected
97 **** connecting client using the ssl credentials
98 current_user()
99 Tanjotuser1@localhost
100 2 for GLOBAL Expected
101 0 for SESSION Expected
102 DROP USER 'Tanjotuser1'@'localhost';
103
104
105 ======================================================================================
106 Checking the user access with SSL through user created with sha256_password plugin
107 ======================================================================================
108
109 Creating a user with the sha256_plugin
110 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
111 set password for 'Tanjotuser1'@'localhost' = 'abc';
112 GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
113 **** connecting client using the ssl credentials
114 current_user()
115 Tanjotuser1@localhost
116 2 for GLOBAL Expected
117 2 for SESSION Expected
118 **** connecting client using the ssl credentials
119 current_user()
120 Tanjotuser1@localhost
121 2 for GLOBAL Expected
122 2 for SESSION Expected
123 **** connecting client using the ssl credentials
124 current_user()
125 Tanjotuser1@localhost
126 2 for GLOBAL Expected
127 2 for SESSION Expected
128 **** connecting client using the ssl credentials
129 current_user()
130 Tanjotuser1@localhost
131 2 for GLOBAL Expected
132 2 for SESSION Expected
133 **** connecting client using the ssl credentials
134 current_user()
135 Tanjotuser1@localhost
136 2 for GLOBAL Expected
137 2 for SESSION Expected
138 **** connecting client using the ssl credentials
139 current_user()
140 Tanjotuser1@localhost
141 2 for GLOBAL Expected
142 2 for SESSION Expected
143 DROP USER 'Tanjotuser1'@'localhost';
144 # restart: