vscode连接本地mysql报错
mysql版本: 8.0.15
连接插件: MySQL Syntax
问题描述
用vscode连接mysql时出现报错
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
问题解决
进入mysql后必须要改密码。
改密码需要用以下格式，否则不兼容
//password 是你的数据库账户密码，root和host也是
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
https://www.cnblogs.com/Jiangchuanwei/p/10238958.html
拓展:
运行mysql语句, 右键选择Run MySQL Query
然后右键数据库, 点Refresh, 刷新一下