Node js cannot allow to access MySQL on digital ocean

Posted November 8, 2017 3.1k views

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

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
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.