Python 连接MySQL数据库

在 Python 中连接 MySQL 数据库需要使用 MySQL Connector 模块，具体步骤如下：

1. 安装 MySQL Connector 模块

pip install mysql-connector-python

2. 导入 MySQL Connector 模块

import mysql.connector

3. 建立连接

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

4. 创建游标对象

mycursor = mydb.cursor()

5. 执行 SQL 查询

mycursor.execute("SELECT * FROM yourtable")
myresult = mycursor.fetchall()
for x in myresult:
  print(x)

6. 关闭连接

mydb.close()

完整示例代码：

import mysql.connector

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

mycursor = mydb.cursor()

mycursor.execute("SELECT * FROM yourtable")

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

mydb.close()