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 login in SQL server from visual studio code. I have explained everything there 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;