idea自带database连接mysql失败问题

weixin_44560245

已于 2023-04-28 15:39:06 修改

阅读量3.7w

点赞数 34

文章标签： mysql intellij-idea 数据库

于 2023-04-28 15:37:10 首次发布

本文链接：https://blog.csdn.net/weixin_44560245/article/details/130426650

版权

在IDEA中尝试连接MySQL数据库时遇到Communicationslinkfailure错误，问题与SSL协议有关。解决方案包括在URL中添加useSSL=false参数，或在驱动的高级设置中禁用SSL。应用这些修改后成功解决了连接问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

idea2023.1版连接mysql失败

DBMS: MySQL (ver. 5.7.13)
Case sensitivity: plain=exact, delimited=exact
Driver: MySQL Connector Java (ver. mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ), JDBC4.0)
[08S01]
	Communications link failure

	The last packet successfully received from the server was 95 milliseconds ago.  The last packet sent successfully to the server was 89 milliseconds ago.
No appropriate protocol (protocol is disabled or cipher suites are inappropriate).

使用如下：
在这里插入图片描述
填写正确的IP，端口，账号，密码
test connection 报如下错误

DBMS: MySQL (ver. 5.7.13)
Case sensitivity: plain=exact, delimited=exact
Driver: MySQL Connector Java (ver. mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ), JDBC4.0)
[08S01]
Communications link failure

The last packet successfully received from the server was 95 milliseconds ago.  The last packet sent successfully to the server was 89 milliseconds ago.

No appropriate protocol (protocol is disabled or cipher suites are inappropriate).

解决方案：
1.url路径中加入 useSSL=no或者useSSL=false 在这里插入图片描述
2.在advanced中下拉选中useSSl为no

3.驱动中的advanced中的useSSL设置为非true