Mysql does not support authentication protocol requested by server, ER_NOT_SUPPORTED_AUTH_MODE

Node JS & Mongo

Hi Everyone, please I got this issue in my MYSQL when I installed it on Homebrew and try to run the backend server

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

The image attached below, Anyone can help?
Thanks in Advance

Comments

Joseph Morgan

23 Aug 2021

Best Answer

Hi Mohamed, Nice to hear back from you,

This issue happens because you almost forgot to set a user for the MYSQL server so you have to use this command below

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456789';

and then try again to run your server
Good Luck

Replies

Mohamed Atef

23 Aug 2021

Thanks this really worked for me

Terms & Conditions
Privacy Policy
Cookie Policy