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

[revathisankaran]

I am getting the following error.

mysql> CREATE USER 'sqluser'@'%' IDENTIFIED
-> WITH mysql_native_password BY 'password123' ;
ERROR 1396 (HY000): Operation CREATE USER failed for 'sqluser'@'%'

Can you help me