DataGrip2023配置连接Mssqlserver、Mysql、Oracle若干问题解决方案

1、Mssqlserver连接

本人连的是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则可。

2、Mysql连接

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

3、Oracle连接