使用SSL/TLS连接MySQL数据库的示例代码

本示例代码演示如何使用SSL/TLS协议连接MySQL数据库。SSL/TLS协议是一种加密通信协议，可以有效防止网络中的数据被窃听和篡改。本示例将使用Python编写。

import mysql.connector

config = {
    "user": "root",
    "password": "password",
    "host": "localhost",
    "port": 3306,
    "database": "test",
    "ssl_ca": "path/to/ca.crt",
    "ssl_cert": "path/to/client.crt",
    "ssl_key": "path/to/client.key"
}

cnx = mysql.connector.connect(**config)

cursor = cnx.cursor()

query = ("SELECT * FROM employees")

cursor.execute(query)

for (emp_no, first_name, last_name, hire_date) in cursor:
    print("{} {} was hired on {}".format(first_name, last_name, hire_date))

cursor.close()

cnx.close()

免责申明：文章和图片全部来源于公开网络，如有侵权，请通知删除 server@dude6.com