docker 安装 mysql8 后, 想在主机 使用 mysql 命令去连接 输入: mysql -uroot -p123456 报错: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysql/mysql.sock' (2) 解决 mysql -uroot -p123456 -h 127.0.0.1
新报错: ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded
解决: host> docker exec -it mysql bash container> mysql -uroot -p123456 mysql command> use mysql mysql command> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456' PASSWORD EXPIRE NEVER; mysql command> select host, user, plugin from user;