django2.2连接mysql报错

django2.2连接mysql配置

import pymysql

pymysql.install_as_MySQLdb()

DATABASES = {
    # 'default': {
    #     'ENGINE': 'django.db.backends.sqlite3',
    #     'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    # }
    #
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'USER': 'root',
        'PASSWORD': 'mysql',
        'NAME': 'django',
    }
}

报错信息：

django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.

解决

• 找到django mysql驱动的安装目录，如D:\software\JetBrains\venv\Lib\site-packages\django\db\backends\mysql
• 先找到base.py文件，注释掉下面的代码

#if version < (1, 3, 13):
#    raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__)

• 重启django依旧报错，再找到operations.py文件，将报错信息中的decode改为encode,即可解决报错问题。

# 报错片段
	query = query.decode(errors='replace')
AttributeError: 'str' object has no attribute 'decode'

# 修改后
if query is not None:
    query = query.encode(errors='replace')
    return query