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

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. Connect to MySQL Database from Visual Studio Code and Run SQL Queries using SQLTools Extension

#mysql #visualstudiocode #sqltools #tutorial #beginners

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; Follow my Facebook Page : https://www.facebook.com/105940115222549 Follow me on Instagram : https://www.instagram.com/p/CViUlw2sOMi Follow me on tumblr : http://programming-guru.tumblr.com Follow me on reddit : https://www.reddit.com/u/Programming_guru1?utm_medium=android_app&utm_source=share ... https://www.youtube.com/watch?v=D81cC9nuZzw