mySQL(InnoDB) datasource problem.

[sysuser1]

Greetings.

My problem is whenever i place password in mysql-ds.xml

the data source is not working.

the mysql-ds.xml is like


--------------------------------

<local-tx-datasource>
<jndi-name>CostControlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/db</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>abcd</user-name>
abcd
</local-tx-datasource>



i created one user abcd@localhost thru mysql control centre.but when in xml(as well as db) i give the password of the user the datasource is not working but when i remove the password it is working fine.
please help me.

the error message that comes on jboss server when i give passsword is cannot find user abcd @ 127.0.0.1

Thanks
Anupam

[dumber168]

try granting user "abcd" further rights in MySQL Server by
executing the following (either through MySQL client or
Control Center):

> grant select,insert,update,delete on test.* to abcd@"" identified by "abcd";
> grant select,insert,update,delete on test.* to abcd@localhost identified by "abcd";
> grant select,insert,update,delete on test.* to abcd@"%" identified by "abcd";

all the above statements may be applied to fully grant the user
"abcd" to the database "db" regardless of the hostname where
the application is run.

hope this helps.

[osoberanis]

Try changing the driver class to this
<driver-class>org.gjt.mm.mysql.Driver</driver-class>