user image

Mohamed Atef
Published in : 2021-08-23

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

web-brackets.com

Comments

Joseph Morgan Date : 2021-08-23

Best answers

11

Best answers

11

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

Mohamed Atef Date : 2021-08-23

Thanks this really worked for me 

Leave a comment

Join us

Join our community and get the chance to solve your code issues & share your opinion with us

Sign up Now

Related posts

[Solved] SyntaxError: Unexpected token o in JSON at position 1 NodeJS
Publish date: 2021-06-13 | Comments: 1

Tag: Node JS & Mongo

Way to bypass a value if it is not existing in Async data fetch iterations
Publish date: 2022-03-06 | Comments: 2

Tag: Node JS & Mongo