怎么用服务器连数据库

pip install mysql-connector-python

import mysql.connector

# 数据库配置
config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'your_server_ip_or_domain',
    'database': 'your_database_name',
    'raise_on_warnings': True
}

try:
    # 建立连接
    cnx = mysql.connector.connect(**config)
    print("成功连接到数据库")

    # 创建游标
    cursor = cnx.cursor()

    # 执行查询
    query = "SELECT * FROM your_table_name"
    cursor.execute(query)

    # 获取结果
    for row in cursor:
        print(row)

except mysql.connector.Error as err:
    print(f"连接失败: {err}")

finally:
    # 关闭游标和连接
    if 'cursor' in locals():
        cursor.close()
    if 'cnx' in locals():
        cnx.close()

config['connection_timeout'] = 30  # 单位为秒

GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_username'@'your_server_ip_or_domain';

sudo systemctl start mysql