By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,727 Members | 766 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,727 IT Pros & Developers. It's quick & easy.

Lost connection to MySQL server at 'reading initial communication packet'

P: 9
Expand|Select|Wrap|Line Numbers
  1. Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /webs/sites/monetized.com/includes/mysql_connect.inc.php on line 2
  2. Lost connection to MySQL server at 'reading initial communication packet', system error: 113
I'm receiving the above error whenever trying to connect to my database server from any remote server. It WAS working before without any problems. I can't think of anything I have done since to the database that would affect this.

Some extensive Google searching seems to find nothing but enabling "bind-address" to "127.0.0.1" in the my.cnf file. I've tried this, restarted MySQL, with no help.

Everything local works just fine.

Any help would be greatly appreciated.

Thanks,
Dan
Oct 6 '08 #1
Share this Question
Share on Google+
5 Replies


Atli
Expert 5K+
P: 5,058
Binding the address to localhost would obviously not help with the remote connections. It would effectively limit connections to local connections.

Can you connect from the localhost using the servers external IP address? (that is, for example, "192.168.x.x" rather than "127.0.0.1")
Oct 7 '08 #2

P: 9
Binding the address to localhost would obviously not help with the remote connections. It would effectively limit connections to local connections.

Can you connect from the localhost using the servers external IP address? (that is, for example, "192.168.x.x" rather than "127.0.0.1")
I'm afraid I don't know what that external IP is. I'm using a server instance on GoGrid and I've never seen any IP in the typical network format. All I know is the remote IP (for connecting from computers outside the network).
Oct 7 '08 #3

ak1dnar
Expert 100+
P: 1,584
I think you should bind the IP, that you use for remote accessing.
Oct 7 '08 #4

P: 9
I think you should bind the IP, that you use for remote accessing.
Well, There are going to be multiple IPs connecting.
Oct 7 '08 #5

P: 9
Odd, after playing around with removing the bind address and restarting, it seems to be working fine again. It wasn't before, but oh well, it's working! Thanks for everyone's time.
Oct 7 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.