Access Denied for User (NodeJS & MySQL)

Question

I'm trying to connect to a database that I have up on my domain. I've created a user called public_guests which can access this database.

I'm using NodeJS to create a connection but I get the following error.

ER_ACCESS_DENIED_ERROR: Access denied for user

The error is followed by my IP address etc.

Here is my code:

mysql = require("mysql");

var connection = mysql.createConnection({
    host: "humadshah.com",
    username: "public_guests",
    password:"hello",
    databse:"my_quotes"
});

connection.connect(function(error){
    if(error){
        console.log("Couldn't connect :(    Error: " + error);
    } else {
        console.log("Connected successfully~!");
    }    
});

I've never used a database before, so I'm expecting this to be a really stupid mistake somewhere.

I'll buy a beer for anyone that solves this in under an hour — Drew
– Drew, Commented Sep 25, 2016 at 2:47
Your code is irrelevant. Your password is wrong, your user is not allowed from that IP, or something else. Also, your MySQL host is open to the entire world to connect to. This isn't great practice. While you do need proper credentials to get in, it's still likely that a new MySQL vulnerability will be found one day. Don't open this up so broadly unless you have to. Finally, if this is your first database, might I suggest PostgreSQL? Latest version of Postgres supports document style storage as well as columnar, and has many other nice features. — Brad
– Brad, Commented Sep 25, 2016 at 3:03
@Drew Looks like they're using GoDaddy. GoDaddy sets the default password to something random, so it might take more than an hour. ;-) — Brad
– Brad, Commented Sep 25, 2016 at 3:10

abdulbari · Accepted Answer · 2016-09-25 03:00:58Z

2

As I think, it's not the problem of Node.js.

it's permissions issue which user has at particular IP address, and in the error message is stated:

Access denied for user @some IP

So try to give your root permission for IP where your Node.js instance is running port xxx.xx.xx.xx.

answered Sep 25, 2016 at 3:00

abdulbari

6,2625 gold badges41 silver badges65 bronze badges

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

6 Comments

Human Cyborg Relations Over a year ago

Is there a way I can give permission to all IPs? I want this database to be accessed by anyone from anywhere

abdulbari Over a year ago

Please have a look here stackoverflow.com/questions/8348506/…

Brad Over a year ago

@HumanCyborgRelations Yes, that's possible... is that really what you want? Use user@%.

Human Cyborg Relations Over a year ago

Thanks for the response! Yes, that works. I'm going to only allow users to select the data in the tables, and not alter them in any way. Is there a risk I should be worried about?

Brad Over a year ago

@HumanCyborgRelations I guess it depends on what's in those tables, and how sure you really are that you can secure the MySQL server. At a minimum, it's pretty easy to tie up your server so that nobody else can access data. Locks and such are really annoying that way.

|

Sanjeev Kumar · Accepted Answer · 2018-05-23 18:16:01Z

1

Its permission issue only, grant required permission to user it will work.

answered May 23, 2018 at 18:16

Sanjeev Kumar

3032 silver badges7 bronze badges

Comments

naeem1098 · Accepted Answer · 2018-09-16 11:36:17Z

0

In my case there were two objects of JSON. First was test and second was development but dbPassword were not same. I changed them to one unique password and then it works. That type of problem usually occurs with beginners.

answered Sep 16, 2018 at 11:36

naeem1098

1232 silver badges9 bronze badges

Comments

K.tin · Accepted Answer · 2020-07-23 15:06:12Z

0

Just create a new user from workbench and use it for your nodejs project

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

answered Jul 23, 2020 at 15:06

K.tin

4853 silver badges7 bronze badges

Collectives™ on Stack Overflow

Access Denied for User (NodeJS & MySQL)

4 Answers 4

6 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related