python使用ssl连接mysql

发布时间 2023-10-31 18:02:44作者: slnngk

环境:

Os:Centos 7

mysql:5.7.29

ssl:自制证书

python:3.6.5

 

import pymysql
import ssl

ssl.match_hostname = lambda cert, hostname: True

config = {
    'host': '192.168.1.108',
    'user': 'ssltest',
    'password': 'mysql',
    'database': 'db_test',
    'port':13306,
    'client_flag': pymysql.constants.CLIENT.MULTI_STATEMENTS,
    'ssl': {
        'ca': 'E:\SecureCRT_download\ca.pem',
        'cert': 'E:\SecureCRT_download\client-cert.pem',
        'key': 'E:\SecureCRT_download\client-key.pem'
     }
}

conn = pymysql.connect(**config)
cursor = conn.cursor()

cursor.execute('SELECT * FROM tb_test')

result = cursor.fetchall()
for row in result:
    print(row)

cursor.close()
conn.close()