>it sounds like you need to look at, and potentially cleanup (or make >your mysql access entries match) what's in the inverse-map record for >the IPnumbers of your machines.
>when you connect mysql takes the IPnumber on the inbound connection, >looks it up in DNS and then checks the result against the access >table(s). so, if you've put "xpbox.domain.xxx" in the access table but >the lookup on the inbound IPnumber only returns "xpbox" (which is >technically an invalid entry anyway) things will fail. >so, do lookups on the IPnumbers of the client machines and see what's >returned. that's what you want in the mysql access tables. Flushing privileges permitted a connection from the mysql client. To get the ODBC Admin 'Test Data Source' button to work, I had to create a user table entry with a password hashed by Old_Password(). Is ipconfig /all what you mean by lookup on the IPnumbers? That gives the name of the client box without domain.xxx. In any event, the 'technically incorrect' name did work, and adding the domain.xxx part of the name to the user record did not work. Gerald Williams > 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? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] ---------- End Original Message ---------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
