[jboss-user] [JBoss Portal] - Re: WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 01

[rkusetty]

Hi Peter,

I tried with the another user 'sqlusr at localhost'. I gave all the privileges as below:

mysql> GRANT ALL ON *.* TO 'sqlusr at localhost' IDENTIFIED BY 'pwd';
Query OK, 0 rows affected (0.06 sec)

But after this also, I am getting the below error at the jboss AS console:

19:32:37,250 INFO  [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceB
inding,name=PortalDS' to JNDI name 'java:PortalDS'
19:32:37,609 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection:
null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sq
l.SQLException: Access denied for user 'sqlusr'@'localhost' (using password: YES))

Please let me know if you have any solution for this.

Thanks,
Ramana

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4088864#4088864

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4088864