这是我用django2.2连接MySQL5.5,迁移时报错
django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required;
解决方案
找到python安装目录下的base.py文件,"C:\Python37\lib\site-packages\django\db\backends\mysql\base.py
注释掉以下两行
if version < (1, 3, 3):
raise ImproperlyConfigured("mysqlclient 1.3.3 or newer is required; you have %s" % Database.__version__)
然后执行迁移语句
接着问题又来了
query = query.decode(errors=‘replace’)
AttributeError: ‘str’ object has no attribute ‘decode’
解决方案
打开File "C:\Python37\lib\site-packages\django\db\backends\mysql\operations.py",把146行的decode修改为encode
原:query = query.decode(errors='replace')
改:query = encode.decode(errors='replace')
Bug
(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL)' at line 1")
解决方案
把django降到2.0
MySQL升级
总结
Djando2.1以上不在支持MySQL5.5,各位开发的时候要注意版本之间的兼容问题.