Debian Codegraph @

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

raw
1 call mtr.add_suppression("Plugin 'mysqlx' will be forced to shutdown");
2 call mtr.add_suppression("Unsuccessful login attempt: Invalid user or password");
3 call mtr.add_suppression("Internal account mysqlxsys@localhost can't be removed because server is running without user privileges ..skip-grant-tables. switch");
4 call mtr.add_suppression("Maximum number of authentication attempts reached");
5 call mtr.add_suppression("Access denied for user .*");
6 CREATE USER nonblank@localhost
7 IDENTIFIED WITH 'mysql_native_password' BY 'valid_password';
8 Test starts here
9 RUN select user(),current_user(),@@bind_address
10 user() current_user() @@bind_address
11 nonblank@localhost nonblank@localhost *
12 0 rows affected
13 Mysqlx.Ok {
14 msg: "bye!"
15 }
16 ok
17
18 #
19 # Try login with valid user when server started with
20 # skip-grant-tables and mysqlx loaded
21 #
22 # restart: --skip-grant-tables
23
24 #
25 # Connection should success with valid password
26 RUN select user(),current_user(),@@bind_address
27 user() current_user() @@bind_address
28 nonblank@ skip-grants user@skip-grants host *
29 0 rows affected
30 Mysqlx.Ok {
31 msg: "bye!"
32 }
33 ok
34
35 #
36 # Connection should success with invalid password
37 RUN select user(),current_user(),@@bind_address
38 user() current_user() @@bind_address
39 nonblank@ skip-grants user@skip-grants host *
40 0 rows affected
41 Mysqlx.Ok {
42 msg: "bye!"
43 }
44 ok
45
46 #
47 # Uninstall mysqlx plugin when the server is started with
48 # skip-grant-tables option
49 RUN uninstall plugin mysqlx
50 While executing uninstall plugin mysqlx:
51 Got expected error: Command not supported by pluggable protocols (code 3130)
52 Mysqlx.Ok {
53 msg: "bye!"
54 }
55 ok
56
57 #
58 # Enable back the "grant-tables", mysqlx client
59 # that uses invalid passord must be disconnected
60 FLUSH PRIVILEGES;
61 Application terminated with expected error: Access denied for user 'nonblank'@'localhost' (using password: YES) (code 1045)
62 ok
63 # restart:
64 DROP USER nonblank@localhost;