python 如何连接MySQL

可以使用Python中的MySQL Connector模块来连接MySQL数据库。首先需要安装MySQL Connector模块，使用pip安装即可：

pip install mysql-connector

然后可以按照以下步骤连接MySQL数据库：

导入MySQL Connector模块

import mysql.connector

创建连接

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

创建游标

mycursor = mydb.cursor()

执行SQL语句

mycursor.execute("SELECT * FROM customers")

获取查询结果

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

完整的代码示例：

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()

mycursor.execute("SELECT * FROM customers")

myresult = mycursor.fetchall()

for x in myresult:
  print(x)
``