Error: ER_NOT_SUPPORTED_ AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[z0z0r4]

Mysql 8.0 login with root Any fix this? https://github.com/formulahendry/vscode-mysql/issues/99

[burguitoscat]

Type in MySQL console: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; when 'root' is your user, 'localhost' is your server name and 'password' is your password

[tobisupreme]

This resolves the issue on my machine. Thank you @burguitoscat!

[FrankyYanFuzhang]

Type in MySQL console: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; when 'root' is your user, 'localhost' is your server name and 'password' is your password

Work on my machine, thanks a lot!

[emheyarssi]

Type in MySQL console: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; when 'root' is your user, 'localhost' is your server name and 'password' is your password

This is very discouraged on production servers.

[aliyuthman]

While MYSQL Server supported Standard (mysql_native_password), caching_sha2_password, and SHA256. It is more secure to use a more recommended authentication type (caching_sha2_password or SHA256) than using the Standard (using SHA-1 hashing algorithm) which is not recommended.