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
En esta página del sitio puede ver el video en línea Connecting MySql Server in Visual Studio Code de Duración hora minuto segunda en buena calidad , que subió el usuario Cool IT Help 04 julio 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,250 veces y le gustó 10 a los espectadores. Disfruta viendo!
