0
When I try to login to my site, I get the error: ER_NOT_SUPPORTED_AUTH_MODE
From what I’ve seen I think it has to do with the database connection, which is not correct.
var pool = mysql.createPool({
host: "127.0.0.1",
user: "aafachada",
password: "password",
database: "revistas",
charset: "utf8",
multipleStatements: true
});
I’ve had the user and password as root, but it didn’t work, and I’ve put the password I set as the Mysql Server pass, but it also didn’t work.
I don’t know what I’m supposed to put in these fields to make them work.
I tried to use the method of creating a user through Mysql Workbench, but I do not know if I did it well or not, but I could not enter this user and pass.
I remember that when I installed the various Mysql programs, a section of Users appeared to me, but I skipped it because I thought I didn’t need.
Now I can’t find her I don’t know if it’s what I need to make the connection.
If you can help me I would really appreciate it, so far I have not been able to solve with the answers to questions similar to mine.
you need to confirm how the authentication configuration in
mysql
. Try using this as an additional parameter when creating the connection:insecureAuth : true
and see if you’ve solved– Ricardo Pontual
I already did!! I had User and Pass badly, but after changing and using this parameter already gave! Thank you!!
– user179018