在Ubuntu上，本地通过Docker运行的MySQL拒绝了IntelliJ（IDEA）的连接尝试，报错'指定的数据库用户/密码组合被拒绝'。检查发现用户dev已在localhost上有权限，但连接仍然失败。解决方案包括通过docker inspect获取容器IP，并修改MySQL用户允许所有位置访问（将'dev'@'localhost'改为'dev'@'%'>），从而成功连接。
Currently unable to connect from Intellij to mySql running locally on docker container on ubuntu.
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| tasklogs |
+--------------------+
+----------+-----------+------+
| DATABASE | HOST | USER |
+----------+-----------+------+
| tasklogs | localhost | dev |
| tasklogs | localhost | root |
+----------+-----------+------+
+-----------------------------------------------------------+
| Grants for dev@localhost |
+-----------------------------------------------------------+
| GRANT USAGE ON *.* TO `dev`@`localhost`
最低0.47元/天 解锁文章
扫一扫
1187
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
