I've been working the last 5 hours trying to get the Mysql server on my VDS to accept incoming connections.
I've looked up hundreds of guides on how to do so -- and managed to screw the mysql server up to the point of having to do a complete wipe of it several times
![Razz :P](./images/smilies/icon_razz.gif)
I'm using Ubuntu and trying to connect via a web interface in PHP (works with other mysql servers, however it does not work with this one...).
I've tried granting permissions from external Ips for the root account and a secondary account I made.
I've tried commenting out the
bind-address = 127.0.0.1
in my.cnf - and then restarting the server
I've tried opening up the 3306 port on the VDS.
Pretty much the only thing I havent tried is changing the mysql default port incase there is another firewall or something on the VDS blocking external 3306 traffic as I have 5 Minecraft servers with multiple plugins using the mysql server on the VDS (Would be a pain to cfg all of them to a new port).
If anyone has any other idea, that'd be awesome. If I do indeed need to change the port the mysql server is on, please let me know. If so, what port would you recommend?
Thanks a ton!