I'm trying to connect my script to a mysql database but i get an error.

November 27, 2019 93 views
MySQL Node.js

I get this error
Error: ERNOTSUPPORTEDAUTHMODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I did connected to the database with HeidiSQL and used “ALTER USER ‘user’@'host’ IDENTIFIED WITH 'mysqlnativepassword’ BY 'pw’;”

and it ran the query but my script still gives the error.

1 Answer

Hi @foonkus,

I see you already executed

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

However did you flushed the database privileges?

Enter again into MySQL and run

flush privileges;

That should be enough to get you start!

Regards,
KDSys

Have another answer? Share your knowledge.