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

Hi Peter, I tried with the another user 'sqlusr@localhost'. I gave all the privileges as below: mysql> GRANT ALL ON *.* TO 'sqlusr@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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...