On 3/23/07, Mahehs Patil <[EMAIL PROTECTED]> 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
This error is being thrown because your password is not correct. If
this is a default MySQL installation and IIRC, you have to first
connect as root and not as [EMAIL PROTECTED] I'd suggest reading the
docs for more info on adding users, etc.:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
Note that the URL above is for MySQL 5.0, if you need another version,
choose that here:
http://dev.mysql.com/doc/
Bruce
--
perl -e 'print unpack("u30","D0G)[EMAIL
PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'
Apache Geronimo - http://geronimo.apache.org/
Apache ActiveMQ - http://activemq.org/
Apache ServiceMix - http://servicemix.org/
Castor - http://castor.org/
