You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@servicemix.apache.org by Mahehs Patil <ma...@techmahindra.com> on 2007/03/23 12:04:47 UTC

Connect to DB

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
-- 
View this message in context: http://www.nabble.com/Connect-to-DB-tf3453098s12049.html#a9632567
Sent from the ServiceMix - User mailing list archive at Nabble.com.

Re: Connect to DB

Posted by Bruce Snyder <br...@gmail.com>.
On 3/23/07, Mahehs Patil <ma...@techmahindra.com> 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 root@localhost. 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)U8V4\@4VYY9&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/

Re: Connect to DB

Posted by Anand K Kalyanasundaram <an...@cavs.msstate.edu>.
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
>