Debian Codegraph @

mysql-test/suite/x/r/connection_auth_plugin.result

raw
1 call mtr.add_suppression("Maximum number of authentication attempts reached, login failed");
2 call mtr.add_suppression("Access denied for user .*");
3 CREATE USER xuser_native@localhost
4 IDENTIFIED WITH 'mysql_native_password' BY 'native';
5 CREATE USER xuser_sha256@localhost
6 IDENTIFIED WITH 'sha256_password' BY 'sha256';
7 GRANT ALL ON *.* TO xuser_native@localhost;
8 GRANT ALL ON *.* TO xuser_sha256@localhost;
9 Plain connection as x_root (just check) -> success
10 user plugin
11 x_root mysql_native_password
12 0 rows affected
13 Variable_name Value
14 Mysqlx_ssl_active OFF
15 0 rows affected
16 Mysqlx.Ok {
17 msg: "bye!"
18 }
19 ok
20 Ssl connection as x_root (just check) -> success
21 user plugin
22 x_root mysql_native_password
23 0 rows affected
24 Variable_name Value
25 Mysqlx_ssl_active ON
26 0 rows affected
27 Mysqlx.Ok {
28 msg: "bye!"
29 }
30 ok
31 Ssl connection by native plugin -> success
32 user plugin
33 xuser_native mysql_native_password
34 0 rows affected
35 Variable_name Value
36 Mysqlx_ssl_active ON
37 0 rows affected
38 Mysqlx.Ok {
39 msg: "bye!"
40 }
41 ok
42 Plain connection by native plugin -> success
43 user plugin
44 xuser_native mysql_native_password
45 0 rows affected
46 Variable_name Value
47 Mysqlx_ssl_active OFF
48 0 rows affected
49 Mysqlx.Ok {
50 msg: "bye!"
51 }
52 ok
53 Ssl connection by sha256 plugin -> success
54 user plugin
55 xuser_sha256 sha256_password
56 0 rows affected
57 Variable_name Value
58 Mysqlx_ssl_active ON
59 0 rows affected
60 Mysqlx.Ok {
61 msg: "bye!"
62 }
63 ok
64 Plain connection by sha256 plugin -> fail (ssl is obligatory)
65 Application terminated with expected error: Authentication failed, check username and password or try a secure connection (code 2510)
66 ok
67 Ssl connection by native plugin -> fail (wrong password)
68 Application terminated with expected error: Access denied for user 'xuser_native'@'localhost' (using password: YES) (code 1045)
69 ok
70 Ssl connection by sha256 plugin -> fail (wrong password)
71 Application terminated with expected error: Access denied for user 'xuser_sha256'@'localhost' (using password: YES) (code 1045)
72 ok
73 DROP USER xuser_native@localhost, xuser_sha256@localhost;