Re: Mysql and usernames

From: Andrus Adamchik (
Date: Sun Apr 20 2008 - 06:21:27 EDT

  • Next message: Andrus Adamchik: "Re: Stored proc returning result set (and output params) with MS SQL server"

    It is not *cayenne* that denies access. It is MySQL server. So that's
    where you need to look. Check for instance that reverse DNS from
    machine B works for machine A, or enter machine A IP address in the
    access table.


    On Apr 19, 2008, at 12:15 AM, 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 - 06:22:04 EDT