Mysql8: The client connection caching-sha2-password problem

Problem: caching – sha2 – the password

Processing:

ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; Update the user’s password

FLUSH PRIVILEGES; # refresh permission

Alter user ‘root’@’localhost’ IDENTIFIED by ‘123qwe’;