data 目录,需手动初始化,易踩坑;5.6 自带 data 目录,开箱即用。# 下载地址
https://dev.mysql.com/downloads/mysql/5.6.html
# 选择 Windows (x86, 64-bit), ZIP Archive
# 解压到 D:\mysql-5.6.XX-winx64
复制 my-default.ini 为 my.ini,修改关键项:
[mysqld]
basedir = D:/mysql-5.6.XX-winx64
datadir = D:/mysql-5.6.XX-winx64/data
port = 3306
character_set_server = utf8mb4
default_storage_engine = InnoDB
sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
# 以管理员身份打开 CMD
cd D:\mysql-5.6.XX-winx64\bin
mysqld --install MySQL56 --defaults-file=D:\mysql-5.6.XX-winx64\my.ini
net start MySQL56
# 验证
mysql -uroot -p # 初始无密码,直接回车
mysql_secure_installation
# 设置 root 密码、移除匿名用户、禁止远程 root、删除 test 库
# Anaconda 自带 numpy/pandas/matplotlib 等数据科学栈
conda list
# 安装 MySQL 驱动(二选一)
# 方案一:纯 Python 实现,无需编译,推荐
pip install pymysql
# 方案二:C 扩展驱动,性能略高,Windows 需预编译 wheel
pip install mysqlclient
import pymysql
conn = pymysql.connect(
host='127.0.0.1',
port=3306,
user='root',
password='your_pass',
database='test_db',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor
)
try:
with conn.cursor() as cur:
cur.execute("SELECT VERSION()")
print(cur.fetchone())
cur.execute("CREATE TABLE IF NOT EXISTS demo (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50))")
cur.execute("INSERT INTO demo(name) VALUES (%s)", ("Hello MySQL",))
conn.commit()
cur.execute("SELECT * FROM demo")
for row in cur.fetchall():
print(row)
finally:
conn.close()
| 报错 | 原因 | 解决 |
|---|---|---|
ModuleNotFoundError: No module named 'MySQLdb' | 旧代码用 import MySQLdb | 改用 import pymysql; pymysql.install_as_MySQLdb() |
Authentication plugin 'caching_sha2_password' not supported | MySQL 8 默认插件不兼容旧驱动 | 用户改用 mysql_native_password 或升级驱动 |
Can't connect to MySQL server on 'localhost' | Windows named pipe 问题 | 改用 127.0.0.1 连接 |