473,386 Members | 1,786 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
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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,...

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.