Djagno迁移数据时(mysql)报错(大众错误)

Django数据同步过程中遇到的问题：

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

　　解决办法：C:\Python37\Lib\site-packages\django\db\backends\mysql（python安装目录）打开base.py，注释掉以下内容：

 　　　　　　　if version < (1, 3, 13):

　　　　　　　 raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__)

　　

2、File "C:\Python37\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'

　　解决办法：打开此文件把146行的decode修改为encode

3.注: 若是连云服务器的还要设置一下mysql

    

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

    注释掉  bind-address = 127.0.0.1

   最重点:

   授权用户，并允许远程登录

   进入mysql

     mysql> GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

    mysql> exit

重启mysql

  service mysql restart