python与mysql-connector连接问题：authentication plugin ‘calling_sha2_password‘ is not supported.

python与mysql-connector连接问题：authentication plugin ‘calling_sha2_password’ is not supported.

初学者，进入mysql，或者在MySQL Workbench上运行这一句

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234';

1234是你的MySQL数据库密码，运行完毕后，在Pycharm中加入这一句

auth_plugin='mysql_native_password'

即刻运行Py程序。