It's been a while since I've used MySQL, but I think "%" is just a
wildcard meaning "any host." Cayenne doesn't send the host
along . . . MySQL figures that part out when it receives the
connection. You need to set up your own DNS appropriately. Check the
MySQL logs to see what hostname MySQL thinks is being used.
On Apr 18, 2008, at 5:15 PM, Ozakca, Muzaffer wrote:
> Hi, > > I have an issue when I’m trying to connect to a Mysql database on a > different machine than the one that runs my code. I get this > exception: > > java.sql.SQLException: Access denied for user 'user..%' > > As you might know, Mysql users consist of a name and a location (or > % for all locations). For example, you can define use..ocalhost to > be a user. The user cannot login if s/he is not on “localhost”. > > I’m running my code on machineA and the database is on machineB. The > database user is defined as use..achineA. I can connect to the > database using the normal mysql tools on machineA. > > The login credentials are specified as > > <login userName="user" password="xxx"/> > > In the cayenne config file. My question is how can I tell cayenne to > use a specific machine name (i.e. machine’s DNS name) instead of “%” > > I hope I am clear. > > Thanks, > Muzaffer >
This archive was generated by hypermail 2.0.0 : Sun Apr 20 2008 - 20:48:31 EDT