python 连接MySQL

1.安装MySQL

进入cmd,输入pip install PyMySQL，回车即可安装，我用的是python3

2.导入pymysql模块

在pycharm中输入import pymysql，如果安装之后仍然不能导入，就在setting中手动安装PyMySQL，setting安装步骤请参考https://www.cnblogs.com/keqing1108/p/11936633.html

3.连接数据库

conn = pymysql.connect(host=‘127.0.0.1‘, port=1226, user=‘root‘, passwd=‘1234‘, db=‘db_name‘, charset=‘utf8‘)
cur = conn.cursor()
cur.execute("SELECT * from table;")
result = cur.fetchall()
cur.close()
conn.close()
print(result)
备注：port必须为int型，否则会报错：TypeError: %d format: a number is required, not str
　　　charset的值为utf8,不是utf-8，否则会报错：AttributeError: ‘NoneType‘ object has no attribute ‘encoding‘

4.完整脚本

import pymysql

def conndb():
    conn = pymysql.connect(host=‘127.0.0.1‘, port=1226, user=‘root‘, passwd=‘1234‘, db=‘db_name‘, charset=‘utf8‘)
    cur = conn.cursor()
    cur.execute("SELECT * from table;")
    result = cur.fetchall()
    cur.close()
    conn.close()
    print(result)
conndb()

python 连接MySQL

原文：https://www.cnblogs.com/keqing1108/p/12073264.html