Debian Codegraph @

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

raw
1 #
2 # Bug#26429570: PASSSWORD FROM CACHE IS CLEANED FOR FAILED STATEMENT
3 #
4 CREATE USER arthurdent@localhost IDENTIFIED WITH caching_sha2_password BY 'abcd';
5 CREATE USER marvintheparanoidandroid@localhost IDENTIFIED WITH caching_sha2_password BY 'efghi';
6 CREATE USER zaphodbeeblebrox@localhost IDENTIFIED WITH caching_sha2_password BY 'xyz';
7 FLUSH PRIVILEGES;
8 # Try to establish a connection without TLS or RSA keys - Should fail
9 mysql: [Warning] Using a password on the command line interface can be insecure.
10 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
11 # Try to establish a connection with TLS - Should succeed
12 mysql: [Warning] Using a password on the command line interface can be insecure.
13 USER() CURRENT_USER()
14 arthurdent@localhost arthurdent@localhost
15 mysql: [Warning] Using a password on the command line interface can be insecure.
16 USER() CURRENT_USER()
17 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
18 mysql: [Warning] Using a password on the command line interface can be insecure.
19 USER() CURRENT_USER()
20 zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
21 # Try to establish a connection without TLS or RSA keys - Should succeed
22 mysql: [Warning] Using a password on the command line interface can be insecure.
23 USER() CURRENT_USER()
24 arthurdent@localhost arthurdent@localhost
25 mysql: [Warning] Using a password on the command line interface can be insecure.
26 USER() CURRENT_USER()
27 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
28 mysql: [Warning] Using a password on the command line interface can be insecure.
29 USER() CURRENT_USER()
30 zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
31 # Using root, execute user management DDLs which would result into an error
32 ALTER USER u1 IDENTIFIED WITH 'invalid_plugin' BY 'pwd';
33 ERROR HY000: Plugin 'invalid_plugin' is not loaded
34 # Try to establish a connection without TLS or RSA keys - Should succeed
35 mysql: [Warning] Using a password on the command line interface can be insecure.
36 USER() CURRENT_USER()
37 arthurdent@localhost arthurdent@localhost
38 mysql: [Warning] Using a password on the command line interface can be insecure.
39 USER() CURRENT_USER()
40 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
41 mysql: [Warning] Using a password on the command line interface can be insecure.
42 USER() CURRENT_USER()
43 zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
44 RENAME USER non_existing1 to non_existing2;
45 ERROR HY000: Operation RENAME USER failed for 'non_existing1'@'%'
46 ALTER USER non_existing WITH MAX_QUERIES_PER_HOUR 10;
47 ERROR HY000: Operation ALTER USER failed for 'non_existing'@'%'
48 DROP USER non_existing;
49 ERROR HY000: Operation DROP USER failed for 'non_existing'@'%'
50 # Try to establish a connection without TLS or RSA keys - Should succeed
51 mysql: [Warning] Using a password on the command line interface can be insecure.
52 USER() CURRENT_USER()
53 arthurdent@localhost arthurdent@localhost
54 mysql: [Warning] Using a password on the command line interface can be insecure.
55 USER() CURRENT_USER()
56 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
57 mysql: [Warning] Using a password on the command line interface can be insecure.
58 USER() CURRENT_USER()
59 zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
60 # Change user attributes other than credentials
61 ALTER USER arthurdent@localhost WITH MAX_QUERIES_PER_HOUR 10;
62 GRANT SELECT ON *.* TO arthurdent@localhost;
63 # Password cache should not have been invalidated
64 mysql: [Warning] Using a password on the command line interface can be insecure.
65 USER() CURRENT_USER()
66 arthurdent@localhost arthurdent@localhost
67 # A failed alter on multiple user should not alter cache state
68 ALTER USER non_existing1 IDENTIFIED BY 'haha', marvintheparanoidandroid@localhost IDENTIFIED BY 'hoho';
69 ERROR HY000: Operation ALTER USER failed for 'non_existing1'@'%'
70 GRANT INSERT ON *.* TO non_existing1, marvintheparanoidandroid@localhost;
71 ERROR 42000: You are not allowed to create a user with GRANT
72 mysql: [Warning] Using a password on the command line interface can be insecure.
73 USER() CURRENT_USER()
74 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
75 DROP USER arthurdent@localhost;
76 DROP USER marvintheparanoidandroid@localhost;
77 DROP USER zaphodbeeblebrox@localhost;
78 #
79 # Bug#26429956: CACHE IS CHECKED FOR USERS BELONGING TO OTHER PLUGINS
80 #
81 CREATE USER arthurdent@localhost IDENTIFIED WITH caching_sha2_password BY 'abcd';
82 CREATE USER marvintheparanoidandroid@localhost IDENTIFIED WITH caching_sha2_password BY 'efghi';
83 CREATE USER zaphodbeeblebrox@localhost IDENTIFIED WITH caching_sha2_password BY 'xyz';
84 FLUSH PRIVILEGES;
85 CREATE USER u1@localhost IDENTIFIED WITH 'mysql_native_password' BY 'pwd';
86 # Try to establish a connection with TLS - Should succeed
87 mysql: [Warning] Using a password on the command line interface can be insecure.
88 USER() CURRENT_USER()
89 arthurdent@localhost arthurdent@localhost
90 mysql: [Warning] Using a password on the command line interface can be insecure.
91 USER() CURRENT_USER()
92 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
93 mysql: [Warning] Using a password on the command line interface can be insecure.
94 USER() CURRENT_USER()
95 zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
96 # Try to establish a connection without TLS or RSA keys - Should succeed
97 mysql: [Warning] Using a password on the command line interface can be insecure.
98 USER() CURRENT_USER()
99 arthurdent@localhost arthurdent@localhost
100 mysql: [Warning] Using a password on the command line interface can be insecure.
101 USER() CURRENT_USER()
102 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
103 mysql: [Warning] Using a password on the command line interface can be insecure.
104 USER() CURRENT_USER()
105 zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
106 ALTER USER u1@localhost WITH MAX_QUERIES_PER_HOUR 10;
107 ALTER USER arthurdent@localhost WITH MAX_QUERIES_PER_HOUR 10;
108 # Try to establish a connection without TLS or RSA keys - Should succeed
109 mysql: [Warning] Using a password on the command line interface can be insecure.
110 USER() CURRENT_USER()
111 arthurdent@localhost arthurdent@localhost
112 mysql: [Warning] Using a password on the command line interface can be insecure.
113 USER() CURRENT_USER()
114 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
115 mysql: [Warning] Using a password on the command line interface can be insecure.
116 USER() CURRENT_USER()
117 zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
118 # Search for absence of: Possible it is deleted by other thread.
119 DROP USER arthurdent@localhost;
120 DROP USER marvintheparanoidandroid@localhost;
121 DROP USER zaphodbeeblebrox@localhost;