MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (22.214.171.124) to work for connecting from a mysql
client on a windows machine to a mysql server running on another windows machine (xp and
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
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?