Python3 连接MySQL数据库

一:使用pymysql连接

首先要在mysql建一个demo数据库(没有数据库会报错)

# 导入pymysql
import pymysql

# 主机名,用户名,密码,数据库名
conn = pymysql.connect("localhost", "root", "123456", "demo")
cursor = conn.cursor()
# 执行sql语句,查询数据库表
cursor.execute("SELECT * FROM tb_area")
# 打印表数据
for x in cursor:
    print(x)
# 关闭连接
cursor.close()

执行成功输出查询内容

F:\PythonProject\Python02\venv\Scripts\python.exe F:/PythonProject/Python02/Hello3.py
(1, 'zhang', 1, datetime.datetime(2019, 4, 11, 15, 53, 49), datetime.datetime(2019, 4, 11, 15, 53, 55))
(2, 'lisi', 2, datetime.datetime(2019, 8, 1, 11, 16, 51), datetime.datetime(2019, 9, 20, 11, 16, 57))

Process finished with exit code 0

二:使用MySQL - mysql-connector 驱动

首先要下载MySQL - mysql-connector 驱动,在PyCharm的Terminal输入python -m pip install mysql-connector就可以下载

python -m pip install mysql-connector

驱动下载完成后就可以连接mysql

import mysql.connector
# 创建连接
conn = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="123456",
    database="demo"
)
cursor = conn.cursor()
cursor.execute("SELECT * FROM tb_area")
for x in cursor:
    print(x)

注:如果你的mysql是8.0版本可能会遇到连接错误,mysql8.0版本的密码插件验证方式发生了变化,需要配置一下my.ini文件
可以参考:https://www.runoob.com/note/45833