Mysql & Node - Error: ER_NOT_SUPPORTED_AUTH_MODE

Asked

Viewed 53 times

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

  • I already did!! I had User and Pass badly, but after changing and using this parameter already gave! Thank you!!

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.