error 1045 sqlstate 28000

oritsegbubemi

5/5/24, 8:56 AM

 code: 'ER_ACCESS_DENIED_ERROR',
    errno: 1045,
    sqlState: '28000',
    sqlMessage: "Access denied for user ''@'localhost' (using password: NO)",
    sql: undefined

i have done everything possible:

create new User
grant permissions and all

251

0 + 8

mysql

matigo

5/5/24, 9:08 AM

There is no username being passed

oritsegbubemi

5/5/24, 9:16 AM

var connection = mysql.createPool({ host: "localhost", user: "root", password: "password", database: "elites_1", port : "3306" })

oritsegbubemi

5/5/24, 9:17 AM

every info is correct cos i can log in mysql root user... i use ubuntu 22.04

matigo

5/5/24, 11:45 AM

The `root` user cannot be connected to by non-sudo operations. You will need to create an admin account, grant it proper permissions, and connect the software to that.

oritsegbubemi

5/6/24, 1:05 PM

| GRANT ALL PRIVILEGES ON `elites_1`.* TO `admin`@`%` var connection = mysql.createPool({ host: "localhost", user: "admin", password: "password123", database: "elites_1", port : "3306" })

oritsegbubemi

5/6/24, 1:06 PM

code: 'ER_ACCESS_DENIED_ERROR', errno: 1045, sqlState: '28000', sqlMessage: "Access denied for user ''@'localhost' (using password: YES)", sql: undefined Still getting same Error

matigo

5/6/24, 4:51 PM

`%` is for external connections, `localhost` is used for local connections, and your error message is still showing an empty string where the username should be

oritsegbubemi

5/9/24, 5:55 PM

now working changing this % to localhost

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: error 1045 sqlstate 28000

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.