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

Question

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.

Answer 1

KFSys November 28, 2019

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

Reply Report

Related