Django reports an error using pymsql module django.db.utils.operationalerror

List of articles

• • background
  • reason
  • solve

background

hold Django Module used mysql Connection module from mysqlclient Module changed to pymsql after , This error occurred .

reason

MySQL8.0 The password encryption method used in the above version has changed , Need to change settings

solve

stay MySQL The visualization tool of runs the following SQL sentence , I use it workbench

alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ' Your password ';
FLUSH PRIVILEGES;