mysql idea 连接被否决[28000][1045] Access denied for user 'root'@'172.17.0.1' (using mysqlideadocker

idea连接docker里的mysql镜像时报错：

[28000][1045] Access denied for user 'root'@'172.17.0.1' (using password: YES)

 

解决：

命令：docker exec -it mysql /bin/bash

进入mysql：mysql -uroot -proot

开启远程访问： ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';