- 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 32424 Atli 5,058
Recognized Expert Expert
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" )
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).
ak1dnar 1,584
Recognized Expert Top Contributor
I think you should bind the IP, that you use for remote accessing.
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.
Sign in to post your reply or Sign up for a free account.
Similar topics |
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, client is php application
(portal), Mysql-client 3.23.55, PHP 4.2.3, Apache 1.3.27 on FreeBSD
4.8-RELEASE. The boxes are connected over Cisco Catalyst...
|
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 servers up. I have Tomcat on
server app01 and MySQL on server db01. When I leave the servers and come
back to them after 24 hours or so I start...
|
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 it returns:
ERROR 2013 (HY000): Lost connection to MySQL server during query
I am able to run additional queries after I get the error, so
the...
|
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:
Name=Provider=SQLOLEDB;Password=xxx;Persist Security Info=True;User
ID=xxxx;Data Source=xxxxx;Initial Catalog=xxxxx;Network
Library=dbmssocn
It suddendly stopped...
|
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 connections. I
know of no "standard" way to make this work (and, its quite possible
that I am on the totally wrong track here and there just isn't a way...
| |
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 SQLConnection object and specified the connetion
string.But when it comes to establish a connection its giving me the Error
that
I. Connection string :...
|
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.
My question is, why is the Enterprise Library stripping out my User Id and
Password from my SQL Server connection string, that I have in the...
|
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?
|
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 exception/error:
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |