Debian Codegraph @

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

raw
1
2
3 ===========================================================================================================================================
4 Checking the password authentication using the mysql_native_password plugin at the client and mysql_native_password plugin at the server side
5 ===========================================================================================================================================
6
7 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
8 CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password';
9 select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password';
10 (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password'
11 1
12 1 Expected
13 select (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='mysql_native_password';
14 (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='mysql_native_password'
15 1
16 1 Expected
17 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
18 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
19 SET PASSWORD FOR 'Tanjotuser1'@'localhost'='abc';
20 SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='abc';
21 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
22 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
23 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
24 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
25 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
26 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
27 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
28 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
29 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
30 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
31 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
32 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
33 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
34 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
35 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
36 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
37 DROP USER 'Tanjotuser1'@'localhost';
38 DROP USER 'Tanjotuser2'@'127.0.0.1';
39
40
41 ====================================================================================================
42 checking the integrity of long password (more than 40 chars) using mysql_native_password plugin
43 ====================================================================================================
44
45 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
46 CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password';
47 SET PASSWORD FOR 'Tanjotuser1'@'localhost'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________';
48 SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________';
49 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
50 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
51 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
52 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
53 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
54 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
55 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
56 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
57 DROP USER 'Tanjotuser1'@'localhost';
58 DROP USER 'Tanjotuser2'@'127.0.0.1';
59
60
61 ============================================================================================================================================
62 Checking the password authentication using the mysql_native_password plugin at the client and sha256_password plugin at the server side
63 ============================================================================================================================================
64
65 # Restart server with default-authentication-plugin=sha256_password;
66 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
67 CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password';
68 select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password';
69 (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password'
70 1
71 1 Expected
72 select (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='mysql_native_password';
73 (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='mysql_native_password'
74 1
75 1 Expected
76 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
77 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
78 SET PASSWORD FOR 'Tanjotuser1'@'localhost'='abc';
79 SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='abc';
80 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
81 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
82 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
83 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
84 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
85 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
86 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
87 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
88 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
89 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
90 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
91 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
92 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
93 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
94 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
95 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
96 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
97 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
98 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
99 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
100 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
101 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
102 DROP USER 'Tanjotuser1'@'localhost';
103 DROP USER 'Tanjotuser2'@'127.0.0.1';
104
105
106 ====================================================================================================
107 checking the integrity of long password (more than 40 chars) using mysql_native_password plugin
108 ====================================================================================================
109
110 CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
111 CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password';
112 SET PASSWORD FOR 'Tanjotuser1'@'localhost'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________';
113 SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________';
114 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
115 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
116 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
117 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
118 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
119 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
120 ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
121 ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
122 DROP USER 'Tanjotuser1'@'localhost';
123 DROP USER 'Tanjotuser2'@'127.0.0.1';
124 # restart: