mysql>
select
host,user, authentication_string
from
user;
+-----------+---------------+-------------------------------------------+
| host | user | authentication_string |
+-----------+---------------+-------------------------------------------+
| % | root | *A2F7C9D334175DE9AF4DB4F5473E0BD0F5FA9E75 |
| localhost | mysql
.session
| *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | mysql
.sys
| *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | lml | *
84
AAC12F54AB666ECFC2A83C676908C8BBC381B1 |
+-----------+---------------+-------------------------------------------+
4
rows
in set
(
0.00
sec)
mysql>
set
password for
'lml'
@
'localhost'
=password(
'87654321'
);
Query OK,
0
rows affected,
1
warning (
0.00
sec)
mysql>
select
host,user, authentication_string
from
user;
+-----------+---------------+-------------------------------------------+
| host | user | authentication_string |
+-----------+---------------+-------------------------------------------+
| % | root | *A2F7C9D334175DE9AF4DB4F5473E0BD0F5FA9E75 |
| localhost | mysql
.session
| *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | mysql
.sys
| *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | whb | *
5
D24C4D94238E65A6407DFAB95AA4EA97CA2B199 |
+-----------+---------------+-------------------------------------------+
4
rows
in set
(
0.00
sec)