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_networking' = 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_PhpAndMysql_Application'
works and can access db
'MySQLAdministrator.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.com> wrote in message news:<d3*********@enews1.newsguy.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_networking';
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.