List:MySQL ODBC« Previous MessageNext Message »
From:Fred Parkinson Date:September 30 2009 5:55pm
Subject:access denied to user
View as plain text  
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

Thread
access denied to userFred Parkinson30 Sep
  • RE: access denied to userJohn Bonnett1 Oct