pytharm使用代码连接数据库报错提示Client does not support authentication protocol requested by server

@pytharm使用代码连接数据库报错提示
Client does not support authentication protocol requested by server; consider upgrading MySQL client

数据库密码加密方式的问题，需修改适应pycharm

1）ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER
2）ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’
3）FLUSH PRIVILEGES

很多方法提示，使用命令行进行修改密码加密方式，但是在我电脑未生效，不知为何…