‘caching_sha2_password’ cannot be loaded

django访问mysql数据库报错：

django.db.utils.OperationalError: (2059, <span class="hljs-string">"Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/Cellar/mysql-connector-c/6.1.11/lib/plugin/caching_sha2_password.so, 2): image not found"</span>)

mysql8.0用户密码加密方式为caching_sha2_password，django暂不支持，需要修改下mysql的加密方式： 登录mysql：

mysql -u root -p

查看当前加密方式：

<span class="hljs-keyword">use</span> <span class="hljs-title">mysql</span>;
select user,plugin from user where user=<span class="hljs-string">'root'</span>;

修改加密方式：

alter user <span class="hljs-string">'root'</span>@<span class="hljs-string">'localhost'</span> identified <span class="hljs-keyword">with</span> mysql_native_password by <span class="hljs-string">'password'</span>;

生效：

flush privileges;