search

formulahendry / vscode-mysql

MySQL management tool for Visual Studio Code
https://marketplace.visualstudio.com/items?itemName=formulahendry.vscode-mysql
MIT License
218 stars 59 forks source link

Client does not support authentication protocol requested by server; consider upgrading MySQL client #199

Open Shahaed opened 1 year ago

Shahaed commented 1 year ago

image

EthanKunce commented 1 year ago

I also have this problem!

imahbub commented 1 year ago

Having the same issue

nikbpetrov commented 1 year ago

Potentially solvable by #193

AleksKravtsov commented 11 months ago

Execute the following query in MYSQL Workbench ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; Where root as your user localhost as your URL and password as your password

Then run this query to refresh privileges: FLUSH PRIVILEGES;