NodeJS MySQL DB connection fail

Question

thank you in advance for the help.

I am using nodejs v16.13.1 and mysql 5.7.37-cll-lve. my nodejs app is currently on my local machine and my mysql db is on a remote server. I want to connect to the remote mysql but, I keep getting this error:

Access denied for user ''@'mylocalcomputerip' (using password: YES)

I am using shared hosting btw.

What is weird is that the user is not showing and I know it is correctly being used. as well the the connection trying to connect to my local ip despite me putting in my server ip.

I tried using one of the nameservers and then it gives a timeout.

this is how I am trying to connect to the remote db.

createConnection(){
        const conn = mysql.createConnection({
            host: process.env.DB_HOST,
            username: process.env.DB_USERNAME,
            password: process.env.DB_PASSWORD,
            database: process.env.DB_NAME,
            port: process.env.DB_PORT
        })

        conn.connect(err => {
            if(err) throw err
            console.log("Connected")
        })
        return conn
    }

The host is the shared ip.

The username is the user I created to interact with the db.

The password is the password for the username.

The database is the database that I'm trying to connect to.

The port is the default port 3306 for mysql dbs.

Any kind of knowledge or insight to what I'm doing wrong or don't know about would be greatly appreciated

Answer 1

Found the issue!! The object that is passed to the function createConnection uses a "user" key and not "username".