python怎么安装mysql数据库

pip install mysql-connector-python

import mysql.connector

import mysql.connector

# 连接信息
host = "localhost"
user = "root"
password = "password"
database = "mydatabase"

# 创建连接
cnx = mysql.connector.connect(
    host=host,
    user=user,
    password=password,
    database=database
)

import mysql.connector

# 连接信息
host = "localhost"
user = "root"
password = "password"
database = "mydatabase"

# 创建连接
cnx = mysql.connector.connect(
    host=host,
    user=user,
    password=password,
    database=database
)

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

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

# 获取结果
result = cursor.fetchall()

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

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