SpringBoot with MariaDB:驱动程序没有从服务器接收任何数据包

Question

我有一个MariaDB，当我和续集Pro连接时，我使用这个凭证，我可以连接

​

​

与SpringBoot一起使用

spring.datasource.url=jdbc:mysql://172.105.50.55:3306/pradera_db
spring.datasource.username=pradera_usr
spring.datasource.password=Mddejh847h$#@

但我有个错误：

Caused by: java.net.ConnectException: Connection refused (Connection refused)
    at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:400)
    at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:243)
    at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:225)
    at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:402)
    at java.base/java.net.Socket.connect(Socket.java:591)
    at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
    at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
    ... 81 common frames omitted
2020-05-31 12:30  [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
2020-05-31 12:30  [restartedMain] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

这是pom.xml中的依赖项：

<dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

Answer 1

尝试将其作为连接字符串：

spring.datasource.url=jdbc:mysql://172.105.50.55:3306/pradera_db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

pom.xml：

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

Answer 2

在运行数据库的机器上，在端口3306上添加ip作为允许的连接

Linux：

iptables -I INPUT -p tcp -s your.ip.address.here --dport 3306 -j ACCEPT

Windows:打开“开始”菜单，在搜索栏中写入: Windows防火墙，打开左侧的高级设置，选择入站规则，按右边的“新规则”按钮，选择“端口”并按下一步，选择tcp并指定端口3306，按下一步，允许连接，然后选择“域”、“私有”、“公共”并选择规则本身的名称。

检查服务是否正在运行，并启用/启动它。

Linux：

sudo systemctl status mariadb
sudo systemctl enable mariadb
sudo systemctl start mariadb

Windows:打开“开始”菜单，搜索Services.msc，在“服务”选项卡中找到您的mariadb服务，并通过右键单击它来修改它的状态。

希望能帮上忙。