Quote:
Originally Posted by Akkadius
Some common issues are: - Your Firewall is not forwarding the port correctly to your internal device (3306)
- Windows Firewall is blocking your Mysql service (3306)
- Your Mysql user is not properly configured to allow connections remotely (Root can be set to not allow remote connections)
- Your Mysql user 'host' is not allowing EoC to connect, either '%' or '69.168.254.244' is not set as the allowed host
EoC won't have an issue connecting to your database given that it is actually visible to the outside world. You have to have everything open for it to be able to even see your Database before it will work correctly. Many users use this successfully however some might find a little difficulty with the initial connection.
Once they are in, the rest is easy.
|
Thanks for replying Akkadius. I am new to doing this kind of stuff, so learning as I go.
When I create a new user for connecting, should he be written out as so?:
example: 'eocuser'@'69.168.254.244'
In regards to this statement:
Your Firewall is not forwarding the port correctly to your internal device (3306)
I am not sure what this means. I am pretty sure I have my ports open on my firewall for 3306. I even turned everything off to give it try with no luck. Edit: Just to clarify are you saying we need to set up a SSH tunnel for port 3306?