本人连的是Sql2008,默认添加时,地址、端口、实例、账号、密码后,测试连接出现错误。
Use SSL:不要勾选
VM option:填写,"-Djdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL"
软件安装后默认了:12.2.0,测试连接提示错误:
TLSv1 was negotiated. Please update server and client to use TLSv1.2 at minimum.
解决方案:选ver.8.2.2则可。
Driver选择Mysql,具体可以自行测试调整该驱动。
注意:
VM option:填写,"-Djdk.tls.disabledAlgorithms=SSLv3, TLSv1.1, RC4, DES, MD5withRSA, DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL"
如果提示错误:
[08S01] Communications link failure
The last packet successfully received from the server was 222 milliseconds ago. The last packet sent successfully to the server was 207 milliseconds ago. No appropriate protocol (protocol is disabled or cipher suites are inappropriate).
则尝试在URL内增加?useSSL=false