Lost connection to MySQL server at 'reading initial communication packet'
Question posted by: xoise (Newbie) on October 6th, 2008 03:35 AM
Expand|Select|Wrap|Line Numbers
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 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
5 Answers Posted
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")
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")
Quote:
Originally Posted by Atli
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")
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).
Quote:
Originally Posted by ak1dnar
I think you should bind the IP, that you use for remote accessing.
Well, There are going to be multiple IPs connecting.
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.
Not the answer you were looking for? Post your question . . .
196,220 members ready to help you find a solution.
Join Bytes.com
196,220 members ready to help you find a solution.
Join Bytes.com
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 196,220 network members.Popular Articles
Top MySQL Contributors
You are viewing a mobilized version of this site...
View original page here
