–这是caching_sha2_password加密方式
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH caching_sha2_password BY ‘123456’;
FLUSH PRIVILEGES;
–这是mysql_native_password加密方式
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
FLUSH PRIVILEGES;
想看一下mysql库中的user表就知道密码的存储情况: