mysql database "Invalid authorization specification:"
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.