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:
- Open up the MySQL port in your firewall (defaults to 3306)
- Edit your /etc/my.cnf file (if you're using MariaDB, also edit: /etc/mysql/mariadb.conf.d/50-server.cnf
- Make sure that skip-networking is commented or removed
- 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.