List:General Discussion« Previous MessageNext Message »
From:Gerald Williams Date:January 1 1970 12:00am
Subject:Can't connect to mysql server from another windows box
View as plain text  
MySQL 5.0.12, P2P Microsoft network

I cannot get the manual's instructions (24.1.9.6) to work for connecting from a mysql
client on a windows machine to a mysql server running on another windows machine (xp and
w2kpro repsectively)

The client machine can ping the server machine by name or IP address.
One each machine, a local client successfully connects to the local mysql server as
localhost.
In mysql server on the w2k box, a client row in mysql.user has been created with:
   user=the exact value used in the ODBC Admin dialog
   password=the exact value used in the ODBC Admin dialog
   Host=name of the machine being used as a client 
'skip-networking' is not set on either machine.

But when ODBCAdmin (3.51) is used to create a DSN on the winxp machine for connecting to
the mysql server on the w2k machine, clicking 'Test Data Source' yields this error:

   Host 'XPBOX' is not allowed to connect to this MySQL server'.

(Oddly, the mysql server capitalizes the name of the winxp box. Why does it do that?)

Issuing the command
   telnet w2kbox 3306
on the xpbox also produced this same error message.

This ought to be simple. What's the secret?
Thread
Can't connect to mysql server from another windows boxGerald Williams20 Sep
  • Re: Can't connect to mysql server from another windows boxSGreen20 Sep
Re: Can't connect to mysql server from another windows boxMichael Stassen20 Sep
Re: Can't connect to mysql server from another windows boxGerald Williams20 Sep
Re: Can't connect to mysql server from another windows boxGerald Williams20 Sep