Allow Remote Connections to MySQL/MariaDB

Use format below:

1GRANT ALL ON yourDB.* TO yourDBA@'23.216.39.44' IDENTIFIED BY 'yourPASS';

and make sure that 'bind-address' in /etc/my.cnf is either 0.0.0.0 or commented out for this to take effect. Turn-off as well any firewall, SELinux, etc.

Further details in https://www.digitalocean.com/community/questions/how-to-allow-remote-mysql-database-connection