I've just finished setting up my Server on Digital Ocean (Ubuntu 12.10 x64) using nginx, but i want a separate MySQL Server to decrease the load to the web server.
The problem is, im unable to connect to my server.
I've tried to setup iptables to open port 3306, I've commented the line bind-address The server works fine locally, tested with wordpress, nginx and phpmyadmin.
I cant connect from anywhere, keep getting ERROR 1130 (HY000): Host '192.XXX.XXX.XXX' is not allowed to connect to this MySQL server.
And yes i reloaded all services all the times...