Msql8.0密码模式修改
修改MySQL8.0cache的密码模式
use mysql mysql> select host, user, plugin from user; +-----------+------------------+-----------------------+ | host | user | plugin | +-----------+------------------+-----------------------+ | % | root | caching_sha2_password | | localhost | mysql.infoschema | caching_sha2_password | | localhost | mysql.session | caching_sha2_password | | localhost | mysql.sys | caching_sha2_password | | localhost | root | caching_sha2_password | +-----------+------------------+-----------------------+ 5 rows in set (0.00 sec)
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
#刷新权限
FLUSH PRIVILEGES;
一起交流进步.扫描下方QQ二维码即可
![](https://www.cnblogs.com/images/cnblogs_com/bj-xiaodao/1476283/o_qq%20%E7%BE%A4%E5%9B%BE%E7%89%87.png)