By lotteve
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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.