This could mean you haven't GRANTed the MySQL user connect privileges, eg:
GRANT ALL PRIVILEGES ON abc.* TO 'abc'@'localhost' IDENTIFIED BY 'xyz'; Also try substituting localhost with * if you want to connect from other machines. "vikramchhetryy" wrote : Hi All, | I am trying to create a new application in seam my problem is that i am not able to connect to the database. | | my connection xml looks like this:- | | <?xml version="1.0" encoding="UTF-8"?> | | | | <!DOCTYPE datasources | | PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN" | | "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd";> | | | | <datasources> | | <local-tx-datasource> | | <jndi-name>AbcDatasource</jndi-name> | | <connection-url>jdbc:mysql://127.0.0.1/abc</connection-url> | | <driver-class>com.mysql.jdbc.Driver</driver-class> | | <user-name>abc</user-name> | | <password>xyz</password> | | <!-- | | <exception-sorter-class-name> | | org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter | | </exception-sorter-class-name> | | <metadata> | | <type-mapping>mySQL</type-mapping> | | </metadata> | | --> | | </local-tx-datasource> | | </datasources> | | | | The error I get is :- | java.sql.SQLException: Server configuration denies access to data source | | I have tried many combinations for mysql connect url like | jdbc:mysql://127.0.0.1:3306/abc | | I am using :- | Suse 10.0 | mysql4.1 | seam2.0 | jboss 4.2.2 | ant1.6 | eclipse europa | mysql-connector-java-3.0.9-stable-bin.jar | | i am not sure if i am using right connection jar. | | Any help would be appreciated. | | Regards, | Vikram View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4114810#4114810 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4114810 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
