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


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

RE: access denied to user

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.=20

John Bonnett

-----Original Message-----
From: Fred Parkinson [mailto:FredP@abag.ca.gov]=20
Sent: Thursday, 1 October 2009 3:25 AM
To: myodbc@lists.mysql.com
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



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg