I'm trying to connect my script to a mysql database but i get an error.
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.