3 Replies Latest reply on Sep 6, 2002 4:17 AM by Kuba Nowakowski

    connection problem with user@127.0.0.1

    Dobb Lou Newbie

      I am trying to connect JBoss to MySQL. I am able to connect to MySQL with user "jboss" using "mysql -u jboss -p". However, after I configured my mysqldb-service.xml with the user name of jboss, I got the following error:

      org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Invalid authorization specification: Access denied for user: 'jboss@127.0.0.1' (Using password: YES)); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Invalid authorization specification: Access denied for user: 'jboss@127.0.0.1' (Using password: YES)))

      My understanding is that if I use "mysql -u jboss -p" in the terminal, mysql treats "jboss" as jboss@localhost. Is there anyway to configure JBoss to connect to MySQL as jboss@localhost?

      DL