How to connect MySQL with Visual Studio Code

connect mysql to vscode

How to connect to MySQL from Visual Studio Code

Visual Studio Code for MySQL and MariaDB development

how to connect mysql database in visual studio code

connect visual studio code to phpmyadmin

best mysql extension for vscode

mysql connector-python visual studio code

[PeterMorris]

Replaced % in CREATE USER statement with localhost and it worked like a charm. Thanks

[arjitprakher]

So many thanks to you sir, you solved my problem.

[Rannu]

Gives me this error msg when adding new connection in SQLtools: -

ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client.

Why is this coming and what's the method to resolve this issue? How to check the client version?