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