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 0.0.0.0

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.

×
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:

mysql>GRANT ALL PRIVILEGES
ON database.*
TO 'user'@'%'
IDENTIFIED BY 'newpassword';

Then refresh the privileges with:

mysql>FLUSH PRIVILEGES;

Source: Similar Question

Replace user and newpassword with what your node app uses.

Submit an Answer