Node js cannot allow to access MySQL on digital ocean

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

Got the error like this

ERHOSTNOT_PRIVILEGED: Host 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.