473,699 Members | 2,737 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

error connecting to db server

I have a mysql 3.5 server installed on a suse linux 8.1, with address 10.0.0.100.
Now I want to access that db from a W2K pc, address 10.0.0.200.
I am able to ping 10.0.0.100, but I cannot connect to the db, and get error 2013.
I have tried with MySQL Administrator 1.0 and also with ODBC.
The db on linux has
grant all on *.* to ''@'10.0.0.%'
and also tried
.... to ro**@10.0.0.200
and others seen on posted messages.
I can access that db via php applications (eg phpMyAdmin).
Thank you.
Jul 23 '05 #1
3 6168
kamilla wrote:
I have a mysql 3.5 server installed on a suse linux 8.1, with address 10.0.0.100.
Now I want to access that db from a W2K pc, address 10.0.0.200.
I am able to ping 10.0.0.100, but I cannot connect to the db, and get error 2013.
This seems to be a prevalent error with many causes.
Everything from library conflicts on the server, to exhausted disk
space, to the MySQL server simply being configured to deny remote
connections.

Does this occur immediately upon connecting to the MySQL server, or is
it only have you attempt some query or command on that connection?
Can other hosts connect to the MySQL server without this error?
Can clients on the Linux host connect to a MySQL database? (e.g. 'mysql
test')
Can clients on the Linux host connect to a MySQL database using the
network layer (e.g. 'mysql -h 10.0.0.100 test')
If you can connect from the Linux client, look at the values:
mysql> show variables like 'skip_networkin g';
mysql> show variables like 'bind_address';
If skip_networking is "Yes" or bind_address is anything other than
"10.0.0.200 " then this would prevent the connection.

Regards,
Bill K.
I have tried with MySQL Administrator 1.0 and also with ODBC.
The db on linux has
grant all on *.* to ''@'10.0.0.%'
and also tried
... to ro**@10.0.0.200
and others seen on posted messages.
I can access that db via php applications (eg phpMyAdmin).
Thank you.

Jul 23 '05 #2
Thank you.

On the Linux node:
I have more space available

'mysql test' and 'mysql -h 10.0.0.100 test' give no error message,
seem to work.

mysql> show variables like 'skip_networkin g' = OFF
mysql> show variables like 'bind_address'; = Empty set

From 10.0.0.200:
'http://10.0.0.100/phpMyAdmin' or
'http://10.0.0.100/another_PhpAndM ysql_Applicatio n'
works and can access db

'MySQLAdministr ator.exe' connect to server host = 10.0.0.100, user =
root, pwd = ''
gives 'could not connect to the specified instance', while ping works
fine.
Connection to another db on 10.0.0.300 works
Other trials made with odbc connector tools, failed.
Same from 10.0.0.300.

What else to check?
Thank you.
Nice w-e!
PM

Bill Karwin <bi**@karwin.co m> wrote in message news:<d3******* **@enews1.newsg uy.com>...
kamilla wrote:
I have a mysql 3.5 server installed on a suse linux 8.1, with address 10.0.0.100.
Now I want to access that db from a W2K pc, address 10.0.0.200.
I am able to ping 10.0.0.100, but I cannot connect to the db, and get error 2013.


This seems to be a prevalent error with many causes.
Everything from library conflicts on the server, to exhausted disk
space, to the MySQL server simply being configured to deny remote
connections.

Does this occur immediately upon connecting to the MySQL server, or is
it only have you attempt some query or command on that connection?
Can other hosts connect to the MySQL server without this error?
Can clients on the Linux host connect to a MySQL database? (e.g. 'mysql
test')
Can clients on the Linux host connect to a MySQL database using the
network layer (e.g. 'mysql -h 10.0.0.100 test'
If you can connect from the Linux client, look at the values:
mysql> show variables like 'skip_networkin g';
mysql> show variables like 'bind_address';
If skip_networking is "Yes" or bind_address is anything other than
"10.0.0.200 " then this would prevent the connection.

Regards,
Bill K.
I have tried with MySQL Administrator 1.0 and also with ODBC.
The db on linux has
grant all on *.* to ''@'10.0.0.%'
and also tried
... to ro**@10.0.0.200
and others seen on posted messages.
I can access that db via php applications (eg phpMyAdmin).
Thank you.

Jul 23 '05 #3
Does your host 10.0.0.100 have a firewall that doesn't allow connections
on port 3306? Try (from another machine) 'telnet 10.0.0.100 3306' and see
if you get a connection. The connection won't last long before MySQL
decides something is wrong and closes it, but you should see something
like:
$telnet 10.0.0.100 3306

Escape character is '^]'.
8
4.1.11-Max=2!NH\tS," OHZm6`eXj.DConn ection closed by foreign host.

In this case, 4.1.11-Max is the database server version. You should see
something about 3.5.xx.... that you should recognize as your MySQL version.

If you get 'connection refused', your firewall is blocking you.
Hope this helps.
--
Mike Argy
Custom Office solutions
and Windows/UNIX programs
Excel 2000 on Fedora Core 3

Jul 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
9737
by: David W. Fenton | last post by:
I'm no stranger to this error message, but I have a client who is experiencing it, but, fortunately, without any actual data corruption, and it's driving them made. Their inability to grasp that the cause is fundamentally a networking problem is also making me pull my hair out. Some history: The network is composed of five computers dating back to 1995, each purchased one at a time, and each having a different OS, etc. Until
12
2782
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed both the iis and sql server in a single machine. Not too long ago, the machine had some hardware problems, and management has decided to purchase new servers, for both asp.net and sql server.
7
2192
by: deltalimagolf | last post by:
I now get the following error message after copying an asp.net application to the deployment web server. I don't have SQLExpress or any version of SQL 2005 installed. I found the "LocalSQLServer" connection string in the machine.config, changed that to look at a SQL 2000 database, but the error still comes up. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be...
3
3001
by: Ann Marinas | last post by:
Hi there, I am currently developing an ASP.NET program that connects to a SQL Server 2000 database. I also have SQL Server 2005 Express installed on the same local machine. Prior to installing SQL Server 2005, my apps were working and is connecting flawlessly to a database on the SQL Server 2000. Now, whenever I connect to the same database with the 2005 version installed, I keep on getting this error:
1
4724
by: John Shadel | last post by:
I have the following setup: 1. ASP.NET 2.0 web app hosted on a web server (inetpub directory hosting physical files of the web site on a different drive name, E: than the SQL Server Instance, which is on C:) 2. SQL Server on the same server, with security settings enabling ASPNET group and groups containing users allowed to interact with the website added to SQL Server Instance security settings. 3. Impersonation = true, i.e. ASPNET...
5
1936
by: James | last post by:
Hello, I have written a simple logon page that redirects to another page when successful. All works fine on my computer but when I upload it I get the error message below. I have written it in ASP.net v2, and have put it on IIS v6 on windows server 2003. I think it may be something to do with connection string to the database,
1
7044
by: NEWS | last post by:
My application is giving error .pls help . error : Server Error in '/webpdms' Application. -------------------------------------------------------------------------------- An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40...
10
15949
by: mairhtin o'feannag | last post by:
Hello, I'm having problems connecting to my new v9 db box. The pertinent information is below: DB2_db2inst1 60000/tcp DB2_db2inst1_1 60001/tcp DB2_db2inst1_2 60002/tcp DB2_db2inst1_END 60003/tcp
0
2005
by: aboutjav.com | last post by:
Hi, I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property ((string)(this.GetPropertyValue("Address1")));
5
3554
by: Cirene | last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting this error. Any idea why? Server Error in '/myuser4/MyWebApp' Application. --------------------------------------------------------------------------------
0
8704
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, 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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9187
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, 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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8894
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7776
agi2029
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5879
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4390
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3071
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2360
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.