Fix “ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server;” on VS Code

Go into mySQL command line and change authentication for user by using the following settings.

ALTER USER '<your_user>'@'localhost' IDENTIFIED WITH mysql_native_password BY '<your_password>'