i've been trying to gain remote access to MySQL on a server. I am running into problems, i cannot seem to get the port forwarded, here are some of the steps i've made:
i've told MySQL to listen to all IPs by setting 'bind-address = 0.0.0.0' in my.cnf.
trying to forward the port, i've done various commands:
to allow access to port 3306 from all IPs:
ufw allow 3306
to allow access to port 3306 on specific remote IP addresses:
ufw allow from <remote IP> to any port 3306
netstat tells me that MySQL is listening on 3306 to all IPs, ufw tells me that 3306 is accessible by all IPs.
i have created a remote test user for MySQL that is accessible by any IP:
CREATE USER 'testuser'@'%' IDENTIFIED BY 'mypassword'
all privileges were granted.
i still cannot connect to MySQL remotely, using http://ping.eu/port-chk/ i can check if the port is open on the server, it is not!
is there something other than the ufw commands that i need to use to forward this port?