I have a VPS and I'm trying to have remote access to my mysql databases.
I granted root privileges to any IP address
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES;
I commented in the
my.cnf file, the line
#bind-address = 127.0.0.1
I restarted mysql
sudo service mysql restart
But the next step (all the tutorials around mention as such) involves
iptables to forward requests from port 3306; and I realise that my VPS doesn't even have
sudo service iptables status outputs
iptables: unrecognized service
I could install iptables, but may I achieve the same with nginx? That is, this fort forwarding to allow remote access to my mysql databases?