docker进入数据库容器
bash
问题描述:
SQLyog错误号码 plugin caching_sha2_password could not be
原因分析:
MySQL新版默认使用caching_sha2_password作为身份验证插件,而旧版是使用mysql_native_password
当连接MySQL时报错“plugin caching_sha2_password could not be loaded”时,可换回旧版插件。
解决方案:
远程命令行登录mysql
mysql -h localhost -uroot -proot -P3306
操作mysql数据库命令:use mysql;
查看用户名使用的身份验证插件:mysql> select Host,User,plugin from mysql.user;
------------------------------------------------------------------------------------------------------------------------------
修改root用户的身份验证插件
------------------------------------------------------------------------------------------------------------------------------
本地连接:alter user root@localhost identified with mysql_native_password by '123456';
FLUSH PRIVILEGES;
------------------------------------------------------------------------------------------------------------------------------
远程连接:alter user root@'%' identified with mysql_native_password by '123456';
FLUSH PRIVILEGES;
------------------------------------------------------------------------------------------------------------------------------