問題：
連接Docker啟動的mysql出現(xiàn)：ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded
mysql -h 127.0.0.1 -u root -p
Enter password: ****
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded
解決方案：
1.進(jìn)入mysql容器
docker exec -it mysql2 /bin/bash
2.本地連接mysql
mysql -u root -p xxx
3.修改密碼
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
