Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mysql database "Invalid authorization specification:"

843859Oct 20 2005
Hi,
we are using mysql database in our server. i ve created one database name and restored the data into that and i ve granted the all previliges for that user with one username and password. Now i ve written a java program to access that data base. and i am running that java program in server using one script. while i am running my java program in server. i am getting following exception message.

Database: jdbc:mysql://ip. . . /xxxtesst
user: xxxtest
password: xxxtest
<DbCall> doSomething Error 1: null
java.sql.SQLException: Invalid authorization specification: Access denied for user 'xxxtest'@'app1.dmz.mysite.com' (using password: YES)
java.sql.SQLException: Invalid authorization specification: Access denied for user 'xxxtest'@'app1.dmz.mysite.com' (using password: YES)
at org.gjt.mm.mysql.MysqlIO.init(Ljava.lang.String;Ljava.lang.String;)V(Unknown Source)
at org.gjt.mm.mysql.Connection.connectionInit(Ljava.lang.String;ILjava.util.Properties;Ljava.lang.String;Ljava.lang.String;Lorg.gjt.mm.mysql.Driver;)V(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Ljava.lang.String;ILjava.util.Properties;Ljava.lang.String;Ljava.lang.String;Lorg.gjt.mm.mysql.Driver;)V(Unknown Source)
at org.gjt.mm.mysql.Driver.connect(Ljava.lang.String;Ljava.util.Properties;)Ljava.sql.Connection;(Unknown Source)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;Ljava.lang.ClassLoader;)Ljava.sql.Connection;(Unknown Source)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)Ljava.sql.Connection;(Unknown Source)
at escrow.LandamDbremove.findnewrecords()V(LandamDbremove.java:205)
at escrow.LandamDbremove.main([Ljava.lang.String;)V(LandamDbremove.java:761)
Exception in Main : java.sql.SQLException: Invalid authorization specification: Access denied for user 'xxxtest'@'app1.dmz.mysite.com' (using password: YES)
Note: i ve given currect username, password, database name in my program.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2005
Added on Oct 20 2005
0 comments
191 views