Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
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

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread SGreen
Gerald Williams [EMAIL PROTECTED] wrote on 09/20/2005 10:49:22 AM: 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

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Michael Stassen
[EMAIL PROTECTED] wrote: Gerald Williams [EMAIL PROTECTED] wrote on 09/20/2005 10:49:22 AM: 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

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
Note that if you set the password by directly editing (UPDATE) the mysql.user table like this, you will have to run FLUSH PRIVILEGES; Thank you. That solved the problem connecting from the mysql client. It changed the problem connecting via the 'Test' button from the ODBC Administrator, to

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
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