connection problem with user@127.0.0.1

[dobblou]

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

[kuba.nowakowski]

hi

u should read the manual for mysql

u have to add permission to user table to get access from host 127.0.0.1

for example
update user set host = '%' where user = 'jboss';

this allow you to connect to db from any host

kuba

[sonofseven]

Well, that's ok when you want your user to be able to connect from any host, but what if you don't?

In fact today I run into the same problem?

I still need to figure out what's wrong, so I will let you know once I did!

Live long and prosper,

SonOfSeven

[kuba.nowakowski]

hi

it's just that simple as reading the f... manual of mysql

kuba