Need assistance with accessing mysql database using node.js

javascript, mysql, node.js

Solution

I had a similar problem where I was getting the same error.

The answer for me ended up being that I was using a different port. By default, mysql expects a port of 3306, but I was using MAMP, where the MySQL server port was specified as 8889. As soon as I added a port definition to my database connection, it was fine:

var connection = mysql.createConnection({
    port: 8889,
    user: 'root',
    password : 'password',
    database : 'my_database'
});

NOTE: This is for Mac using MAMP, haven't tried it on ubuntu or Windows.

Problem

I am trying to run a simple node sample for access a mysql db and am getting the following error-Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'ubuntu.local' (using password: YES) ``` var mysql = require('mysql'); var connection = mysql.createConnection({ host : '192.168.0.12', user : 'root', password : 'password', database : 'app' }); connection.connect(); connection.query('SELECT * from users', function(err, rows, fields) { if (err) throw err; console.log('The solution is: ', rows[0]); }); connection.end(); ``` The above is the code for accessing the mysql using node.js.Any suggestions as to what I may be doing wrong, thanks in advance.

Original source