Quote:
Originally Posted by jsr
this looks great, but I can't seem to get a db connection working. Here's what I've done;
1) Added port forward rule to router for TCP port 3306 to my mysql server IP
2) On the mysql server (windows 7), added firewall rule
- service MYSQL
- port 3306
- scope 69.168.254.244
3) Added a mysql user with host '%' and flushed privileges
Eq operations reports a connection error. Am I missing a step?
|
Are you able to connect to your DB from your PC using a tool like Navicat with the same settings you are trying to use for EOC? If you try using your external IP for the connection, I think that should verify if you are setup to allow remote connections.
I don't use MySQL on windows too often, but I believe there is a setting when you install it which lets you enable remote connections. I don't know how to adjust that after installing it offhand, but you may be able to just run the MySQL install again and change that setting this time through. Make sure to backup your DB before trying anything like that just in case!