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...