编程访问远程mysql

import mysql.connector

config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'remote_host',
    'database': 'your_database',
    'raise_on_warnings': True,
    'connect_timeout': 30  # 设置连接超时时间为30秒
}

try:
    cnx = mysql.connector.connect(**config)
except mysql.connector.Error as err:
    print(f"Error: {err}")

-- 允许用户从任何IP地址远程访问
CREATE USER 'your_user'@'%' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON your_database.* TO 'your_user'@'%';
FLUSH PRIVILEGES;

import mysql.connector

config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'remote_host',
    'database': 'your_database',
    'ssl_ca': '/path/to/ca-cert.pem',
    'ssl_cert': '/path/to/client-cert.pem',
    'ssl_key': '/path/to/client-key.pem'
}

try:
    cnx = mysql.connector.connect(**config)
except mysql.connector.Error as err:
    print(f"Error: {err}")