@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
很多方法提示,使用命令行进行修改密码加密方式,但是在我电脑未生效,不知为何…