Question

Node js cannot allow to access MySQL on digital ocean

Got the error like this

ER_HOST_NOT_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

Subscribe
Share

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

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.

Hi @lotteve,

The below documentation can guide you with allowing remote access to the MySQL database :

https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql

Regards, Rajkishore

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

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.