django 配置mysql_Django配置mysql

在安装 conda 后，pip3 报不是内部命令等错误的解决方式

执行 ：

python -m ensurepip

init.py 添加

import pymysql

pymysql.install_as_MySQLdb()

执行 python manage.py makemigrations 报错如下：

...

return _bootstrap._gcd_import(name[level:], package, level)

File "G:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\mysql\base.py", l

ine 36, in

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; y

ou have 0.9.3.

mysqlclient 版本不适合，可以更新版本或者如下操作，G:\ProgramData\Anaconda3\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__)

注释后，接着又报如下错误

...

File "G:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\mysql\base.py", line 231, in init_connection_state

if self.features.is_sql_auto_is_null_enabled:

File "G:\ProgramData\Anaconda3\lib\site-packages\django\utils\functional.py", line 80, in __get__

res = instance.__dict__[self.name] = self.func(instance)

File "G:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\mysql\features.py", line 82, in is_sql_auto_is_null_enabled

cursor.execute('SELECT @@SQL_AUTO_IS_NULL')

File "G:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\utils.py", line 103, in execute

sql = self.db.ops.last_executed_query(self.cursor, sql, params)

File "G:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\mysql\operations.py", line 146, in last_executed_query

query = query.decode(errors='replace')

AttributeError: 'str' object has no attribute 'decode'

将报错文件 G:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\mysql\operations.py中的

query = query.decode(errors='replace')改为

query = query.encode(errors='replace')

最后再执行

python manage.py makemigrations

python manage.py sqlmigrate