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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
CREATE USER arthurdent@localhost IDENTIFIED WITH caching_sha2_password BY 'abcd';
CREATE USER marvintheparanoidandroid@localhost IDENTIFIED WITH caching_sha2_password BY 'efghi';
CREATE USER zaphodbeeblebrox@localhost IDENTIFIED WITH caching_sha2_password BY 'xyz';
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
SELECT USER(), CURRENT_USER();
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
SELECT USER(), CURRENT_USER();
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
SET PASSWORD = 'dcba';
connect(localhost,arthurdent,abcd,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
connect(localhost,arthurdent,abcd,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
connect(localhost,arthurdent,dcba,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
connect(localhost,arthurdent,dcba,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
SET PASSWORD FOR arthurdent@localhost = 'dbca';
connect(localhost,arthurdent,acbd,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
connect(localhost,arthurdent,acbd,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
connect(localhost,arthurdent,dbca,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
connect(localhost,arthurdent,dbca,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
FLUSH PRIVILEGES;
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
SELECT USER(), CURRENT_USER();
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
ALTER USER arthurdent@localhost PASSWORD EXPIRE;
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
RENAME USER arthurdent@localhost TO slartibartfast@localhost;
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
slartibartfast@localhost slartibartfast@localhost
RENAME USER slartibartfast@localhost TO arthurdent@localhost;
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
arthurdent@localhost arthurdent@localhost
SELECT USER(), CURRENT_USER();
USER() CURRENT_USER()
marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
SELECT USER(), CURRENT_USER();
USER() CURRENT_USER()
marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
SELECT USER(), CURRENT_USER();
USER() CURRENT_USER()
marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
SELECT USER(), CURRENT_USER();
USER() CURRENT_USER()
marvintheparanoidandroid@localhost marvintheparanoidandroid@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
USER() CURRENT_USER()
zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
SELECT USER(), CURRENT_USER();
USER() CURRENT_USER()
zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
SELECT USER(), CURRENT_USER();
USER() CURRENT_USER()
zaphodbeeblebrox@localhost zaphodbeeblebrox@localhost
SHOW CREATE USER arthurdent@localhost;
CREATE USER for arthurdent@localhost
CREATE USER `arthurdent`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
SHOW CREATE USER marvintheparanoidandroid@localhost;
CREATE USER for marvintheparanoidandroid@localhost
CREATE USER `marvintheparanoidandroid`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
SHOW CREATE USER zaphodbeeblebrox@localhost;
CREATE USER for zaphodbeeblebrox@localhost
CREATE USER `zaphodbeeblebrox`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
DROP USER arthurdent@localhost;
DROP USER marvintheparanoidandroid@localhost;
DROP USER zaphodbeeblebrox@localhost;
|
