MySQL8:连接caching-sha2-password问题

    xiaoxiao2022-07-04  156

    出现问题:

    caching-sha2-password

    解决方案: #修改加密规则 : ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; #更新一下用户的密码 : ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; #刷新权限 : FLUSH PRIVILEGES; #重新改写密码: alter user ‘root’@‘localhost’ identified by ‘123qwe’;

    谢谢,请批评指正!

    最新回复(0)