I have set up a hosting account on godaddy and they have a ridiculously
old version of mysql so I am trying to set it up to use the my server
instead. But it refuses to connect. I can't figure out what could be
the problem. I have tried connecting to my machine from a few other
servers and they all connect fine. The only thing php gives me back is ...

*Warning*: mysql_connect(): Lost connection to MySQL server during query
in *Test.php* on line *18*
Could not connect: Lost connection to MySQL server during query

The user I am connecting with has host set to '%' with only one entry
for that user. Can someone give me some ideas?

Php info gives me this ...
PHP Version 4.3.11
MySQL Client API version 3.23.49

My version of mysql is 4.1.15

and I have set it to use the old style password.

Anyone have any ideas on what to look for?

--
Chris W
KE5GIX

"Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm"

Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com

Chris, it's somewhat common for hosting companies to restrict outbound
connections like what you describe. They may have a firewall
preventing what you are trying to do.

From your hosting account, can you telnet to your machine on port 3306 ?

I get something like this:
$ telnet 192.168.2.4 3306
Trying 192.168.2.4...
Connected to 192.168.2.4.
Escape character is '^]'.
A
5.0.21-standard-log8E]&@R[Tq,^bSW;_ONv)gO

and then after a couple of seconds,
Connection closed by foreign host.

If you can get this, then your connection is probably not restricted
at the firewall. If you can't, then it probably is.

HTH,
Dan


On 10/14/06, Chris W <2wsxdr5@cox.net> wrote:
> I have set up a hosting account on godaddy and they have a ridiculously
> old version of mysql so I am trying to set it up to use the my server
> instead. But it refuses to connect. I can't figure out what could be
> the problem. I have tried connecting to my machine from a few other
> servers and they all connect fine. The only thing php gives me back is ...
>
> *Warning*: mysql_connect(): Lost connection to MySQL server during query
> in *Test.php* on line *18*
> Could not connect: Lost connection to MySQL server during query
>
> The user I am connecting with has host set to '%' with only one entry
> for that user. Can someone give me some ideas?
>
> Php info gives me this ...
> PHP Version 4.3.11
> MySQL Client API version 3.23.49
>
> My version of mysql is 4.1.15
>
> and I have set it to use the old style password.
>
> Anyone have any ideas on what to look for?
>
> --
> Chris W
> KE5GIX
>
> "Protect your digital freedom and privacy, eliminate DRM,
> learn more at http://www.defectivebydesign.org/what_is_drm"
>
> Gift Giving Made Easy
> Get the gifts you want &
> give the gifts they want
> One stop wish list for any gift,
> from anywhere, for any occasion!
> http://thewishzone.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com
>
>