Error connecting to the database: Error: Access denied for user 'new_user'@'localhost' (using password: YES)
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.