vscode 下使用mysql

小鱼儿 2023-06-15 13:24 2阅读 0赞

### vscode 下使用mysql ###

*   *   *  平台
         *  软件
         *  安装与环境配置
         *  vscode 插件
         *  注意事项
         *  vscode连接mysql
         *  参考博客

### 平台 ###

*  windows

### 软件 ###

*  [vscode][]
 *  [mysql8.0][]

### 安装与环境配置 ###

*  [mysql安装][mysql]
 *  [环境变量配置][Link 1]

### vscode 插件 ###

*  MySQL
 *  MySQL Syntax

### 注意事项 ###

*  修改密码的加密方式

alter user 'root'@'localhost' identified with mysql_native_password by '654321';

其中’654321’ 为你的密码或者要修改为的密码

*  刷新

flush privileges;

在这里插入图片描述

### vscode连接mysql ###

*  安装完Mysql插件后

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][20191122160522319.jpg]

*  右击数据库可添加查询

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70 1]

*  运行案例

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70 2]

### 参考博客 ###

[navicate连接MySQL出现报错client does not support authentication protocol requested by server consider …][navicate_MySQL_client does not support authentication protocol requested by server consider]  
[使用 Visual Studio Code 链接 MySql 数据库并进行查询][Visual Studio Code _ MySql]

[vscode]: https://code.visualstudio.com/
[mysql8.0]: https://dev.mysql.com/downloads/mysql/
[mysql]: https://blog.csdn.net/qq_41146650/article/details/100546395
[Link 1]: https://blog.csdn.net/qq_41146650/article/details/100546358
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191122160509786.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw,size_16,color_FFFFFF,t_70
[20191122160522319.jpg]: https://img-blog.csdnimg.cn/20191122160522319.jpg
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2019112216115342.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191122161528551.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw,size_16,color_FFFFFF,t_70
[navicate_MySQL_client does not support authentication protocol requested by server consider]: https://blog.csdn.net/m_amazing/article/details/84313789
[Visual Studio Code _ MySql]: https://blog.csdn.net/sigmarising/article/details/80665252