python连mysql，切记，用pymysql，别用MySQLdb！！！！

import pymysql

# MariaDB连接配置
host = 'localhost'
port = 3306
user = 'root'
password = 'password'
database = 'mydatabase'

# 创建MariaDB连接
db = pymysql.connect(
    host=host,
    port=port,
    user=user,
    password=password,
    db=database,
    charset='utf8'
)

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

# 执行SQL查询
cursor.execute('SELECT * FROM mytable')

# 获取查询结果
results = cursor.fetchall()

# 打印结果
for row in results:
    print(row)

# 关闭游标和连接
cursor.close()
db.close()