#第一种连接mysql数据库的方式
import pandas as pd
from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://{}:{}@{}:{}/{}".format('root', '密码', '数据库地址', '3306', '数据库'))
sql_query = 'select * from wp_users'
# 使用pandas的read_sql_query函数执行SQL语句，并存入DataFrame
df_read = pd.read_sql_query(sql_query, engine)
print(df_read)
#第二种连接mysql数据库的方式
import pandas as pd
import numpy as np
import pymysql
conn = pymysql.connect(
host='数据库地址',
user='root',
password='密码',
database='数据库',
charset='utf8'
)
cursor = conn.cursor()
cursor.execute("SELECT VERSION()")
data = cursor.fetchone()
print("Database version : %s " % data)
