[resolved] Cannot connect to my remote mysql database |
Guru master
|
This is most likely not a phped problem but rather some external factor like a firewall or something else.
To quickly test that, try to telnet to port 3306 on the server running the database, you should get at least a short connection. If that too reports it can't connect, it really is something else then php. |
||||||||||||
|
Site Admin
|
yes right, 10060 sounds like there is a firewall blocking phped. But checking with telnet may not help if firewall does not block telnet. I'd recommend just to check firewall settings.
Also if you run mysql on a remote host, you can't connect to it until you create appropriate account, make sure it listens on the external ip (not only on the localhost) and server firewall allows external (remote) hosts to connect to it too. For the public servers it all may create security problems and is not a recommended way. In this case, I'd recommend to use ssh tunnels. |
||||||||||||
_________________ The PHP IDE team |
|
Thank you for your help. I tried the telnet connection and it failed. I suspected from the beginning that it was a server side issue, but thought maybe PhED had a work around. I have no control over the server side - at least that I know of. I use the Bravehost hosting service and the php and mysql service provided in their hosting package. I know nothing about the server side setup or how to work with it. I guess I can check with Bravehost to see if they have any solutions.
Thanks again. |
||||||||||||
|
Guru master
|
If it is a public host they either don't offer external MySQL connectivity at all (most likely) or it will be on a custom port. So the best idea is indeed mail them and ask
|
||||||||||||
|
[resolved] Cannot connect to my remote mysql database |
|
||
Content © NuSphere Corp., PHP IDE team
Powered by phpBB © phpBB Group, Design by phpBBStyles.com | Styles Database.
Powered by
Powered by phpBB © phpBB Group, Design by phpBBStyles.com | Styles Database.
Powered by