ER_NOT_SUPPORTED_AUTH_MODE

[samuelradford]

Using MySQL 8.0.12 on a Mac, this error occurs when connecting to a local instance.

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

[KevinSmild]

Try running this on your MySQL client: ALTER USER '<your_user>'@'localhost' IDENTIFIED WITH mysql_native_password BY '<your_password>';

[gitpushdev]

Try running this on your MySQL client: ALTER USER '<your_user>'@'localhost' IDENTIFIED WITH mysql_native_password BY '<your_password>';

That worked with me, thank you

[jvictorhuguenin]

thank you,you helped so much

[vishalkrv]

Thanks for the help. Here is a link to know more how this works.

[dsksandr]

thanks, it works!

[kangkang59812]

great

[shenshouer]

ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'password';
flush privileges;
```

Worked for me!

[Ymangz]

localhost can be %

[richiezhzh]

Nice.

[incesubaris]

Thanks a lot, it works!

[Syncure]

Thanks a lot!!!!

[diego-dotcom]

It works! Thank you!

[ps011]

Worked like a charm!

[kavya47]

ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'password';
flush privileges;

Worked for me!

Worked for me too!!

[Vanidasan]

Thanks, It worked for me too

[sammed-dev]

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ''; this worked for me. Thank you

[guru2linux]

worked for me!!

[awesomecakex]

Try running this on your MySQL client: ALTER USER '<your_user>'@'localhost' IDENTIFIED WITH mysql_native_password BY '<your_password>';

i did this but now i cant connect on mysql workbench to the root connection and it didnt fix the problem for me

[bearzeze]

Nice one. After typing those commands you need to exit and enter VS again

[Edwingudfriend]

Thanks you it worked!

[DavidConley]

That just gets me

ALTER : The term 'ALTER' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of 
the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1
+ ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'password'
+ ~~~~~
    + CategoryInfo          : ObjectNotFound: (ALTER:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

Using Visual Studio's terminal and PowerShell.

[hansrwindhoff]

this worked for me, mysql running in local docker container: ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'supersecret';

[liber09]

Nice, this works.

[artm]

Try running this on your MySQL client: ALTER USER '<your_user>'@'localhost' IDENTIFIED WITH mysql_native_password BY '<your_password>';

why?

[githubjess]

ALTER USER 'user' IDENTIFIED WITH mysql_native_password BY 'password';

worked for me

[Anish-Parkhi]

@KevinSmild Thank you very much, was struggling to connect from long