Node js cannot allow to access MySQL on digital ocean

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.