0


idea自带database连接mysql失败问题

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
在这里插入图片描述

完美解决


本文转载自: https://blog.csdn.net/weixin_44560245/article/details/130426650
版权归原作者 weixin_44560245 所有, 如有侵权,请联系我们删除。

“idea自带database连接mysql失败问题”的评论:

还没有评论