tencent cloud

mysql -h <IP address> --ssl-ca=<CA certificate path> --ssl-mode=REQUIRED -P <Port number> -u <Username> -p

mysql -h <IP address> --ssl-ca=<CA certificate path> --ssl-mode=VERIFY_CA -P <Port number> -u <Username> -p

$conn = mysqli_init();
mysqli_ssl_set($conn, NULL, NULL, "<Downloaded certificate path>", NULL, NULL);
mysqli_real_connect($conn, '<Database access address>', '<Database access username>', '<Database access password>', '<Specified database to be accessed>', <Access port>, MYSQLI_CLIENT_SSL);
if (mysqli_connect_errno($conn)) {
die('Failed to connect to MySQL: '.mysqli_connect_error());
}

$options = array(
  PDO::MYSQL_ATTR_SSL_CA => '<Downloaded certificate path>'
);
$db = new PDO('mysql:host=<Database access address>;port=<Access port>;dbname=<Specified database to be accessed>', '<Database access username>', '<Database access password>', $options);

# generate truststore and keystore in code

String importCert = " -import "+
  " -alias mysqlServerCACert "+
  " -file " + ssl_ca +
  " -keystore truststore "+
  " -trustcacerts " +
  " -storepass password -noprompt ";
String genKey = " -genkey -keyalg rsa " +
  " -alias mysqlClientCertificate -keystore keystore " +
  " -storepass password123 -keypass password " +
  " -dname CN=MS ";
sun.security.tools.keytool.Main.main(importCert.trim().split("\\\\s+"));
sun.security.tools.keytool.Main.main(genKey.trim().split("\\\\s+"));

# use the generated keystore and truststore

System.setProperty("javax.net.ssl.keyStore", "<Downloaded certificate path>");
System.setProperty("javax.net.ssl.keyStorePassword","tencentdb");
System.setProperty("javax.net.ssl.trustStore", "<Downloaded certificate path>");
System.setProperty("javax.net.ssl.trustStorePassword","tencentdb");

url = String.format("jdbc:mysql://%s/%s?serverTimezone=UTC&useSSL=true", '<Database access address>', '<Specified database to be accessed>');
properties.setProperty("user", '<Database access username>');
properties.setProperty("password", '<Database access password>');
conn = DriverManager.getConnection(url, properties);

var builder = new MySqlConnectionStringBuilder
{
  Server = "<Database access address>",
  UserID = "<Database access username>",
  Password = "<Database access password>",
  Database = "<Specified database to be accessed>",
  SslMode = MySqlSslMode.VerifyCA,
  SslCa = "<Downloaded certificate>",
};
using (var connection = new MySqlConnection(builder.ConnectionString))
{
  connection.Open();
}

try:
  conn = mysql.connector.connect(user='<Database access username>',
                                 password='<Database access password>',
                                 database='<Specified database to be accessed>',
                                 host='<Database access address>',
                                 ssl_ca='<Downloaded certificate path>')
except mysql.connector.Error as err:
  print(err)

conn = pymysql.connect(user='<Database access username>',
                     password='<Database access password>',
                     database='<Specified database to be accessed>',
                     host='<Database access address>',
                     ssl={'ca': '<Downloaded certificate path>'})

DATABASES = {
  'default': {
      'ENGINE': 'django.db.backends.mysql',
      'NAME': '<Specified database to be accessed>',
      'USER': '<Database access username>',
      'PASSWORD': '<Database access password>',
      'HOST': '<Database access address>',
      'PORT': '<Access port>',
      'OPTIONS': {
          'ssl': {'ca': '<Downloaded certificate path>'}
      }
  }
}

var fs = require('fs');
var mysql = require('mysql');
const serverCa = [fs.readFileSync("<Downloaded certificate path>", "utf8")];
var conn=mysql.createConnection({
  host:"<Database access address>",
  user:"<Database access username>",
  password:"<Database access password>",
  database:"<Specified database to be accessed>",
  port:<Access port>,
  ssl: {
      rejectUnauthorized: true,
      ca: serverCa
  }
});
conn.connect(function(err) {
if (err) throw err;
});

rootCertPool := x509.NewCertPool()
pem, _ := ioutil.ReadFile("<Downloaded certificate path>")
if ok := rootCertPool.AppendCertsFromPEM(pem); !ok {
  log.Fatal("Failed to append PEM.")
}
mysql.RegisterTLSConfig("custom", &tls.Config{RootCAs: rootCertPool})
var connectionString string
connectionString = fmt.Sprintf("%s:%s@tcp(%s:<Access port>)/%s?allowNativePasswords=true&tls=custom","<Database access username>", "<Database access password>", "<Database access address>", '<Specified database to be accessed >')
db, _ := sql.Open("mysql", connectionString)

client = Mysql2::Client.new(
      :host     => '<Database access address>',
      :username => '<Database access username>',
      :password => '<Database access password>',
      :database => '<Specified database to be accessed>',
      :sslca => '<Downloaded certificate path>'
  )