Error connecting to the database: Error: Access denied for user 'new_user'@'localhost' (using password: YES) - Source

Revision: 138916
User: Andrey Carvajal
Date: 2024-05-06 15:44

Hello,

I'm encountering an issue and could use your assistance.

I'm receiving the following error when attempting to connect to the database:

Here are the steps I've followed:

Created a new database named hello_world_db in MariaDB.

Used the hello_world_db database.

Created a new user named new_user with the password your_password.

Granted all privileges on the hello_world_db database to the new_user user.

Additionally, I've installed the mysql2 package using npm.

1.  MariaDB [none]> CREATE DATABASE hello_world_db;

2. MariaDB [(none)]> USE hello_world_db;

3. MariaDB [hello_world_db]> CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'your_password';

4. MariaDB [hello_world_db]> GRANT ALL PRIVILEGES ON hello_world_db.* TO 'new_user'@'localhost';

5. npm install --save mysql2
6  npm install --save mysql2
7  npm install --save mariadb

Then I created a a database connection in my application using a Sequelize instance like this:

import { createConnection } from 'mysql2';

const connection = createConnection({
    host: 'localhost',             
    user: 'new_user',               
    password: 'your_password',      
    database: 'hello_world_db'     
});

connection.connect(function(err) {
   if (err) {
      console.error('Error connecting to the database: ', err.stack);
      return;
   }
   console.log('Connected to the database as id ', connection.threadId);
});

connection.end();

PS C:\Users\wasab\hello-world> node server.js
Error connecting to the database:  Error: Access denied for user 'new_user'@'localhost' (using password: YES)

However, when I run node server.js, I still encounter the access denied error.

Your help in resolving this issue would be greatly appreciated.

Thank you.

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Error connecting to the database: Error: Access denied for user 'new_user'@'localhost' (using password: YES) - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB