VScode中链接数据库

安装mysql模块

创建数据库和表并输入内容

注意端口号还有密码

加入条件查找

报错

Client does not support authentication protocol requested by server; consider upgrading MySQL client'

解决办法

1、use mysql;

2、alter user 'root'@'localhost' identified with mysql_native_password by '********';

3、flush privileges;