How do I allow remote access to MySQL

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
  3. Make sure that skip-networking is commented or removed
  4. Make sure that bind-address is your servers IP address

20 March 2019