RE: access denied to user

[John Bonnett]

I assume you have only one MySQL server and several clients? Since some
clients seem to be working OK we can probably assume that the server is
configured correctly. The problem is, what is different about the
clients that don't work?

The error message implies that MySQL has found the right grant to apply
so it has the user name correct. The only other things that could be
wrong I think are the IP address of the client not matching (I think you
have checked that) and the password. 

John Bonnett

-----Original Message-----
From: Fred Parkinson [mailto:FredP@stripped] 
Sent: Thursday, 1 October 2009 3:25 AM
To: myodbc@stripped
Subject: access denied to user

I am using mysql odbc driver ver. 3.51

On several machines I have installed the odbc driver and successfully
connected them to a mysql database where the database admin used the
grant statement:

grant all on pdadata.* to pdauser@"172.xx.xx.%" identified by 'xxxxx';
(of course the 2 xx's are integers in our ip range and xxxxx is the
password)

However, on several machines properly in the ip range, I get the error
'Access denied for user 'pdauser'@'172.xx.xx.%'

First thing is, the database admin thinks it is odd that the ip address
returned by the error is the ip address w/wildcard used in the grant
statement, not the ip address of the connecting user.

Then he said 'Lot's of luck, hope you find the answer' as he left the
cubical of the user I was trying to connect.

Any ideas?

Thanks in advance for any help.

Fred