Django环境生成数据库python manage makemigrations报错4

本地数据库连接报错

  File "D:\python\lib\site-packages\MySQLdb\connections.py", line 277, in query
    _mysql.connection.query(self, query)
django.db.utils.OperationalError: (1449, "The user specified as a definer ('mysql.infoschema'@'localhost') does not exist")

原因：数据库还原时mysql.user中缺少用户mysql.infoschema

解决：思路》添加对应的用户，并赋予权限，通过如下sql

mysql -uroot -p"123456"
use mysql;
INSERT INTO mysql.user(`Host`,`User`,`plugin`,`authentication_string`,ssl_cipher,x509_issuer,x509_subject) VALUES ('localhost','mysql.infoschema','mysql_native_password','*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE','','','');
FLUSH PRIVILEGES;
update mysql.user set Select_priv = 'Y' where User = 'mysql.infoschema';
FLUSH PRIVILEGES;