error connecting to db server

[kamilla]

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.

[Bill Karwin]

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.

[kamilla]

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.

[Mike A]

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