- 关于MySQL "1251-client does not su
- 关于MySQL "1251-client does not su
- Navicat连接Mysql时出现1251错误解决方案
- How to support formatting non-st
- The gay of genius-chapter 21
- MySQL报错:mysql:ERROR 1819 (HY000)
- ssh variant 'simple' does not su
- ssh variant 'simple' does not su
- 2018 Mac 彻底卸载数据库(mysql)
- Error: Node Sass does not yet su
原因是在mysql8之前的版本中加密规则为mysql_native_password
而在mysql8以后的加密规则为caching_sha2_password。
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码'; #更新一下用户的密码
FLUSH PRIVILEGES; #刷新权限
网友评论