Connecting MySql Server in Visual Studio Code
In this video tutorial, you will learn to connect MySQL server in Visual Studio code. Also, we will fix the issue of authentication mode by creating a new user with a password and then we will log in SQL server from Visual Studio code. I have explained everything in this tutorial step by step, so please watch the tutorial till the end for flawless connection of MySQL server from Visual Studio code.
Important SQL commands used in this tutorial are given below:
Now we will create a new user:
CREATE USER 'sqluser'@'%' IDENTIFIED
WITH mysql_native_password BY 'password123' ;
A new user is created by the name ‘sqluser’ with password ‘password123’.
Provide this user with all the privileges :
GRANT ALL PRIVILEGES ON . TO 'sqluser'@'%' ;
We need to validate these privileges :
FLUSH PRIVILEGES;
#mysqlserverconncectVSCode #coolithelp
On this page of the site you can watch the video online Connecting MySql Server in Visual Studio Code with a duration of hours minute second in good quality, which was uploaded by the user Cool IT Help 04 July 2023, share the link with friends and acquaintances, this video has already been watched 1,279 times on youtube and it was liked by 10 viewers. Enjoy your viewing!
