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
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.
Click below to sign up and get $100 of credit to try our products over 60 days!
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:
Then refresh the privileges with:
Source: Similar Question
Replace
user
andnewpassword
with what your node app uses.