通过ssl将springboot应用程序与mysql服务器连接

openssl req -newkey rsa:2048 -nodes -keyout mysql.key -x509 -days 365 -out mysql.crt

[mysqld]
ssl-ca=/path/to/mysql.crt
ssl-cert=/path/to/mysql.crt
ssl-key=/path/to/mysql.key

spring.datasource.url=jdbc:mysql://your-mysql-server:3306/your-database?useSSL=true&requireSSL=true
spring.datasource.username=your-username
spring.datasource.password=your-password

spring.datasource.url=jdbc:mysql://your-mysql-server:3306/your-database?useSSL=true&requireSSL=true&verifyServerCertificate=true
spring.datasource.username=your-username
spring.datasource.password=your-password
spring.datasource.hikari.connection-init-sql=SET @cert := LOAD_FILE('/path/to/client-cert.pem')

CREATE USER 'your-username'@'%' REQUIRE SSL WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class Application {
    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }
}