Debian Codegraph @

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

raw
1 call mtr.add_suppression("Plugin 'mysqlx' will be forced to shutdown");
2 call mtr.add_suppression("Internal account mysqlxsys@localhost can't be removed because server is running without user privileges ..skip-grant-tables. switch");
3 call mtr.add_suppression("Maximum number of authentication attempts reached");
4 call mtr.add_suppression("Access denied for user .*");
5 CREATE USER nonblank@localhost
6 IDENTIFIED WITH 'mysql_native_password' BY 'valid_password';
7 Test starts here
8 RUN select user(),current_user(),@@bind_address
9 user() current_user() @@bind_address
10 nonblank@localhost nonblank@localhost *
11 0 rows affected
12 Mysqlx.Ok {
13 msg: "bye!"
14 }
15 ok
16
17 #
18 # Try login with valid user when server started with
19 # skip-grant-tables and mysqlx loaded
20 #
21 # restart: --skip-grant-tables
22
23 #
24 # Connection should success with valid password
25 RUN select user(),current_user(),@@bind_address
26 user() current_user() @@bind_address
27 nonblank@ skip-grants user@skip-grants host *
28 0 rows affected
29 Mysqlx.Ok {
30 msg: "bye!"
31 }
32 ok
33
34 #
35 # Connection should success with invalid password
36 RUN select user(),current_user(),@@bind_address
37 user() current_user() @@bind_address
38 nonblank@ skip-grants user@skip-grants host *
39 0 rows affected
40 Mysqlx.Ok {
41 msg: "bye!"
42 }
43 ok
44
45 #
46 # Uninstall mysqlx plugin when the server is started with
47 # skip-grant-tables option
48 RUN uninstall plugin mysqlx
49 While executing uninstall plugin mysqlx:
50 Got expected error: Command not supported by pluggable protocols (code 3130)
51 Mysqlx.Ok {
52 msg: "bye!"
53 }
54 ok
55
56 #
57 # Enable back the "grant-tables", mysqlx client
58 # that uses invalid passord must be disconnected
59 FLUSH PRIVILEGES;
60 Application terminated with expected error: Access denied for user 'nonblank'@'localhost' (using password: YES) (code 1045)
61 ok
62 # restart:
63 DROP USER nonblank@localhost;
64 CREATE USER nonblank@localhost
65 IDENTIFIED WITH 'sha256_password' BY 'valid_password';
66 Test starts here
67 RUN select user(),current_user(),@@bind_address
68 user() current_user() @@bind_address
69 nonblank@localhost nonblank@localhost *
70 0 rows affected
71 Mysqlx.Ok {
72 msg: "bye!"
73 }
74 ok
75
76 #
77 # Try login with valid user when server started with
78 # skip-grant-tables and mysqlx loaded
79 #
80 # restart: --skip-grant-tables
81
82 #
83 # Connection should success with valid password
84 RUN select user(),current_user(),@@bind_address
85 user() current_user() @@bind_address
86 nonblank@ skip-grants user@skip-grants host *
87 0 rows affected
88 Mysqlx.Ok {
89 msg: "bye!"
90 }
91 ok
92
93 #
94 # Connection should success with invalid password
95 RUN select user(),current_user(),@@bind_address
96 user() current_user() @@bind_address
97 nonblank@ skip-grants user@skip-grants host *
98 0 rows affected
99 Mysqlx.Ok {
100 msg: "bye!"
101 }
102 ok
103
104 #
105 # Uninstall mysqlx plugin when the server is started with
106 # skip-grant-tables option
107 RUN uninstall plugin mysqlx
108 While executing uninstall plugin mysqlx:
109 Got expected error: Command not supported by pluggable protocols (code 3130)
110 Mysqlx.Ok {
111 msg: "bye!"
112 }
113 ok
114
115 #
116 # Enable back the "grant-tables", mysqlx client
117 # that uses invalid passord must be disconnected
118 FLUSH PRIVILEGES;
119 Application terminated with expected error: Access denied for user 'nonblank'@'localhost' (using password: YES) (code 1045)
120 ok
121 # restart:
122 DROP USER nonblank@localhost;