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