idea自带database连接mysql失败问题_百度小程序

相关推荐recommended

idea自带database连接mysql失败问题

作者：mmseoamin日期：2023-12-20

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).

使用如下：

idea自带database连接mysql失败问题,在这里插入图片描述,第1张

填写正确的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 idea自带database连接mysql失败问题,在这里插入图片描述,第2张

2.在advanced中下拉选中useSSl为no

idea自带database连接mysql失败问题,第3张

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

idea自带database连接mysql失败问题,在这里插入图片描述,第4张

完美解决

广州网站设计哪家好做网站哪家好哪家好建行网上银行下载网站建立服务百度首页关键词优化免费简历模板网站有哪些

上一篇：如何使用linux启动Nacos

下一篇：Java实现pdf转图片的工具类（三种方法实现PDF转图片的案例）【亲测可用】