* 安装pymysql模块
pip install pymysql
* settings.py添加下面设置
## pymysql repalce mysqldb
importpymysql
pymysql.install_as_MySQLdb()
* mysqlclient 版本太低
报错:
raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__)
django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
解决:
cd {python_root_dir}/Libsite-packagesdjangodbackendsmysql
base.py
#找到base.py文件,注释掉 base.py 中如下部分(35/36行)
#if version < (1, 3, 3):#raise ImproperlyConfigured("mysqlclient 1.3.3 or newer is required; you have %s" % Database.__version__)
* 编码问题
报错:
AttributeError: ‘str’ object has no attribute ‘decode’
解决:
cd {python_root_dir}/Libsite-packagesdjangodbackendsmysql
operations.py
#找到operations.py文件(146行),将decode改为encode#linux vim 查找快捷键:?decode
if query is notNone:
query= query.decode(errors='replace')returnquery#改为
if query is notNone:
query= query.encode(errors='replace')return query