Hi Mahehs,
May be you already tried this, but just in case, did you try connecting
to this database directly from commandline "mysql -u root -p -h localhost" ?
Anand
Mahehs Patil wrote:
I want to know
how to connect the database in java.sql.SQLException: Access denied for user
'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at
com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.jav
a:425)
at
com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.jav
a:140)
at
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource.getPooledConnection
(MysqlConnectionPoolDataSource.java:79)
at
com.motorola.isf.reader.DBHandler.establishConnection(DBHandler.java:56)
at
com.motorola.isf.esgdatastore.esgDataStoreImpl.initilize(esgDataStoreImpl.java:
44)
at
com.motorola.isf.esgdatastore.esgDataStoreImpl.getChannelList(esgDataStoreImpl.
java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
va:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.codehaus.xfire.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:JSR181code
whic is deployed in servicemix but it gives error
