Mysql and usernames

From: Ozakca, Muzaffer (
Date: Fri Apr 18 2008 - 17:15:48 EDT

  • Next message: Colin Bankier: "Re: How to propoerly close context db connection"


    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 user@localhost 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 user@machineA. 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.


    This archive was generated by hypermail 2.0.0 : Fri Apr 18 2008 - 17:16:25 EDT