- 关闭mysql服务,启动mysql无密码模式:mysqld --skip-grant-tables
- use mysql;
- select user,host,password from user;
- 更改root密码,输入update user set password=password('admin123') where user='root' and host='localhost';
mysql 8.0登录不了的问题:
caching_sha2_password和sha256_password认证插件比mysql_native_password插件提供的密码加密更加安全,并且caching_sha2_password加密比sha256_password的加密性能更好。由于caching_sha2_password这样优秀的安全和性能特性,让他作为MySQL8.0的首选认证插件,这也是默认的认证插件插件而不是mysql_native_password
修改为旧的访问方式:
ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY '111111';
FLUSH PRIVILEGES;