Its an easy process to allow remote connections to your MySQL server.

To allow remote access to your MySQL server you will have to do the following things:

1. Open up the MySQL port in your firewall (defaults to 3306)
2. Edit your /etc/my.cnf file (if you're using MariaDB, also edit: /etc/mysql/mariadb.conf.d/50-server.cnf
3. Make sure that skip-networking is commented or removed
4. Make sure that bind-address is your server's IP address or 0.0.0.0

   

   After that, restart your database service and try to connect from remote.