vscode 插件连接 mysql-Client does not support authentication protocol requested by server

vscode 插件连接 mysql-Client does not support authentication protocol requested by server

vscode 插件连接 mysql

​​安装插件​​

​​MySQL management tool​​​​MySQL Syntax​​

​​使用​​​​问题​​

​​原因​​​​解决办法​​

安装插件

MySQL management tool

MySQL management tool

MySQL Syntax

This extension adds specific language syntax for MySQL. It’s a port of the Sublime plugin adael/sublimetext-mysql-syntax.

使用

To add MySQL connection: in Explorer of VS Code, click “MYSQL” in the bottom left corner, then click the + button, then type host, user, password, port and certificate file path (optional) in the input box.

。。。

问题

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

原因

数据库连接使用的node-mysql模块不符合新版的规则

重点看caching_sha2_password这个，由于我安装的mysql是8.0的版本，

mysql8.0和5.x其中一个改动就是加密认证方式发生改变，

caching_sha2_password是8.0

mysql_native_password是5.x

解决办法

alter user ‘root’@‘%’ identified with mysql_native_password by ‘Abc123456’;

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。