473,386 Members | 1,706 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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

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
5 32401
Atli
5,058 Expert 4TB
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
xoise
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
1,584 Expert 1GB
I think you should bind the IP, that you use for remote accessing.
Oct 7 '08 #4
xoise
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
xoise
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

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

Similar topics

0
by: Pav Lucistnik | last post by:
Hi folks, we're seeing strange behaviour of mysql connections over network here lately. Server and client are on different machines. Server (corpdb) is Mysql 3.23.52 on FreeBSD 4.6.2-RELEASE,...
0
by: Michael | last post by:
I'm using Red Hat Linux 9.0 My SQL 4..0.15 Tomcat 4.1.27 JConnector 3.0.9 I've configured a DataSource in the /home context. I can access the database just fine when I initially satart the...
3
by: Matias Silva | last post by:
Hi Everyone, I wrote a for loop to build several select statements that are combined with a UNION. When I execute one of the queries separately, it works, but when I execute the query with a UNION...
1
by: mdurliSPAMFILTER | last post by:
Hello, I developed a win32 .exe CGI that connects to a clustered SQLServer to report some data. The software is written with Borland C++Builder. This is the oledb string:...
7
by: Adam Clauss | last post by:
I am trying to work-around a firewall which limits me to only being able to accept inbound connections on port 80. Unfortunately, I need to two different applications to be able to accept...
1
by: vighnesh | last post by:
Hi All I am dealing a project in ASP.NET in which I have to establish a connection to SQL Server 2000 database,where the database was located on a remote system. For this I have used...
2
by: SAL | last post by:
Hello, I am working with Framework 1.1 and Microsoft Enterprise Library 2005. I've used the Enterprise Library Configuration utility to create my app.config & dataConfiguration.config files. ...
4
by: Roy Epperson | last post by:
I'm not finding what the maximum number of characters that a statement can be. Anyone know where I can find that spec?
3
by: tulika dutta | last post by:
after 8 hrs my MySQL connection with JDBC gets time out. It gives the error java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly closed due to underlying...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.