Debian Codegraph @

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

raw
1 CREATE USER arthurdent@localhost IDENTIFIED WITH caching_sha2_password BY 'abcd';
2 CREATE USER marvintheparanoidandroid@localhost IDENTIFIED WITH caching_sha2_password BY 'efghi';
3 CREATE USER zaphodbeeblebrox@localhost IDENTIFIED WITH caching_sha2_password BY 'xyz';
4 mysql: [Warning] Using a password on the command line interface can be insecure.
5 USER() CURRENT_USER()
6 arthurdent@localhost arthurdent@localhost
7 SELECT USER(), CURRENT_USER();
8 USER() CURRENT_USER()
9 arthurdent@localhost arthurdent@localhost
10 SELECT USER(), CURRENT_USER();
11 USER() CURRENT_USER()
12 arthurdent@localhost arthurdent@localhost
13 SET PASSWORD = 'dcba';
14 connect(localhost,arthurdent,abcd,test,MASTER_PORT,MASTER_SOCKET);
15 ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
16 connect(localhost,arthurdent,abcd,test,MASTER_PORT,MASTER_SOCKET);
17 ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
18 mysql: [Warning] Using a password on the command line interface can be insecure.
19 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
20 mysql: [Warning] Using a password on the command line interface can be insecure.
21 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
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 arthurdent@localhost arthurdent@localhost
28 mysql: [Warning] Using a password on the command line interface can be insecure.
29 connect(localhost,arthurdent,dcba,test,MASTER_PORT,MASTER_SOCKET);
30 ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
31 connect(localhost,arthurdent,dcba,test,MASTER_PORT,MASTER_SOCKET);
32 ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
33 mysql: [Warning] Using a password on the command line interface can be insecure.
34 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
35 mysql: [Warning] Using a password on the command line interface can be insecure.
36 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
37 mysql: [Warning] Using a password on the command line interface can be insecure.
38 USER() CURRENT_USER()
39 arthurdent@localhost arthurdent@localhost
40 mysql: [Warning] Using a password on the command line interface can be insecure.
41 USER() CURRENT_USER()
42 arthurdent@localhost arthurdent@localhost
43 SET PASSWORD FOR arthurdent@localhost = 'dbca';
44 connect(localhost,arthurdent,acbd,test,MASTER_PORT,MASTER_SOCKET);
45 ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
46 connect(localhost,arthurdent,acbd,test,MASTER_PORT,MASTER_SOCKET);
47 ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
48 mysql: [Warning] Using a password on the command line interface can be insecure.
49 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
50 mysql: [Warning] Using a password on the command line interface can be insecure.
51 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
52 mysql: [Warning] Using a password on the command line interface can be insecure.
53 USER() CURRENT_USER()
54 arthurdent@localhost arthurdent@localhost
55 mysql: [Warning] Using a password on the command line interface can be insecure.
56 USER() CURRENT_USER()
57 arthurdent@localhost arthurdent@localhost
58 ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
59 connect(localhost,arthurdent,dbca,test,MASTER_PORT,MASTER_SOCKET);
60 ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
61 connect(localhost,arthurdent,dbca,test,MASTER_PORT,MASTER_SOCKET);
62 ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
63 mysql: [Warning] Using a password on the command line interface can be insecure.
64 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
65 mysql: [Warning] Using a password on the command line interface can be insecure.
66 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
67 mysql: [Warning] Using a password on the command line interface can be insecure.
68 USER() CURRENT_USER()
69 arthurdent@localhost arthurdent@localhost
70 mysql: [Warning] Using a password on the command line interface can be insecure.
71 USER() CURRENT_USER()
72 arthurdent@localhost arthurdent@localhost
73 FLUSH PRIVILEGES;
74 mysql: [Warning] Using a password on the command line interface can be insecure.
75 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
76 mysql: [Warning] Using a password on the command line interface can be insecure.
77 USER() CURRENT_USER()
78 arthurdent@localhost arthurdent@localhost
79 SELECT USER(), CURRENT_USER();
80 USER() CURRENT_USER()
81 arthurdent@localhost arthurdent@localhost
82 mysql: [Warning] Using a password on the command line interface can be insecure.
83 USER() CURRENT_USER()
84 arthurdent@localhost arthurdent@localhost
85 mysql: [Warning] Using a password on the command line interface can be insecure.
86 USER() CURRENT_USER()
87 arthurdent@localhost arthurdent@localhost
88 ALTER USER arthurdent@localhost PASSWORD EXPIRE;
89 mysql: [Warning] Using a password on the command line interface can be insecure.
90 mysql: [Warning] Using a password on the command line interface can be insecure.
91 USER() CURRENT_USER()
92 arthurdent@localhost arthurdent@localhost
93 RENAME USER arthurdent@localhost TO slartibartfast@localhost;
94 mysql: [Warning] Using a password on the command line interface can be insecure.
95 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
96 mysql: [Warning] Using a password on the command line interface can be insecure.
97 USER() CURRENT_USER()
98 slartibartfast@localhost slartibartfast@localhost
99 RENAME USER slartibartfast@localhost TO arthurdent@localhost;
100 mysql: [Warning] Using a password on the command line interface can be insecure.
101 USER() CURRENT_USER()
102 arthurdent@localhost arthurdent@localhost
103 SELECT USER(), CURRENT_USER();
104 USER() CURRENT_USER()
105 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
106 SELECT USER(), CURRENT_USER();
107 USER() CURRENT_USER()
108 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
109 SELECT USER(), CURRENT_USER();
110 USER() CURRENT_USER()
111 marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
112 SELECT USER(), CURRENT_USER();
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 SELECT USER(), CURRENT_USER();
119 USER() CURRENT_USER()
120 zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
121 SELECT USER(), CURRENT_USER();
122 USER() CURRENT_USER()
123 zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
124 SHOW CREATE USER arthurdent@localhost;
125 CREATE USER for arthurdent@localhost
126 CREATE USER `arthurdent`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
127 SHOW CREATE USER marvintheparanoidandroid@localhost;
128 CREATE USER for marvintheparanoidandroid@localhost
129 CREATE USER `marvintheparanoidandroid`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
130 SHOW CREATE USER zaphodbeeblebrox@localhost;
131 CREATE USER for zaphodbeeblebrox@localhost
132 CREATE USER `zaphodbeeblebrox`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
133 DROP USER arthurdent@localhost;
134 DROP USER marvintheparanoidandroid@localhost;
135 DROP USER zaphodbeeblebrox@localhost;