关于Docker报错

_Origin / 2023-05-18 / 原文

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';