Cannot connect to MySQL from NodeJS

Question

I am getting this error, but none of the solutions worked for me

Error: ER_ACCESS_DENIED_ERROR: Access denied for user ''@'localhost' (using password: YES)

I tried the solutions posted online but they did not work. I can connect to my server in Python, but not in NodeJS despite having the MySQL module installed.

var con = mysql.createConnection({host: "localhost", port: 3306, username: "root", password: "password", database: "activity"})

For some reason, the error message does not show user 'root'@'localhost', but rather an empty user. I do not know why this isn't working, since I am able to connect to my database in python. I've tried flushing privileges and other solutions posted online, but none work. MySQL server does run on port 3306

change username to user in config

anees
– anees

2020-08-15 20:08:00 +00:00
Commented Aug 15, 2020 at 20:08 — anees
– anees, Commented Aug 15, 2020 at 20:08

Sumeet Kumar Yadav · Accepted Answer · 2020-08-15 20:04:33Z

1

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "password",
  database: "activity"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  var sql = "CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))";
  con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("Table created");
  });
});

answered Aug 15, 2020 at 20:04

Sumeet Kumar Yadav

13.2k6 gold badges53 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot connect to MySQL from NodeJS

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related