mysql> use mysql;
mysql> ALTER USER 'root'@'%' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER; //修改root用户的加密规则
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root'; //修改root用户的密码为root
mysql> flush privileges; //刷新权限
MySQL无法使用Navicat连接,报(caching_sha2_password)
最新推荐文章于 2024-07-02 21:33:37 发布