1、登录
mysql -u root -p
2、查看用户
select host,user,plugin,authentication_string from mysql.user
3、更改加密方式
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
4、修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
5、刷新
mysql> FLUSH PRIVILEGES;