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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
