Node js cannot allow to access MySQL on digital ocean

November 8, 2017 1.9k views
MySQL Node.js DigitalOcean

Got the error like this

ERHOSTNOT_PRIVILEGED: Host …xxx… is not allowed to connect to this my sql server

in the bind address already set to

how to allow my node js to access to my sql server

1 Answer

Try entering the mysql environment on the droplet via mysql -u root -p (mysql root password is usually in /root/.mysqlpassword or /root/.digitaloceanpassword).

Then grant privileges to all hosts accessing the database with:

ON database.*
TO 'user'@'%'
IDENTIFIED BY 'newpassword';

Then refresh the privileges with:


Source: Similar Question

Replace user and newpassword with what your node app uses.

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!