Article Source

• Connect to MySQL Database from Visual Studio Code and Run SQL Queries using SQLTools Extension

Connect to MySQL Database from Visual Studio Code

Abstract

Setup MySQL Connection in Visual Studio Code and Run SQL Queries using SQLTools. How to install and use SQLTools with Visual Studio Code. How to run SQL queries from Visual Studio Code. How to fix couldn’t find any drivers installed yet. How to fix ER_NOT_SUPPORTED_AUTH_MODE Client does not support authentication protocol requested by server; consider upgrading mysql client.

Create new MySQL user with old authentication method:
CREATE USER 'sqluser'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'sqluser'@'%';
FLUSH PRIVILEGES;