java.sql.SQLException: Access denied for user 'alias name'@'IP address' (using password: YES)
Posted by: babu suri
Date: August 03, 2010 09:54PM

I am receiving the below error message while connecting to My SQl Server.


java version : 1.6.0_06

mysql jar: mysql-connector-java-5.0.7-bin.jar


java.sql.SQLException: Access denied for user 'alias name'@'IP address' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748)

at com.mysql.jdbc.Connection.<init>(Connection.java:1553)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)

at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:279)

at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)

at java.lang.Thread.run(Unknown Source)


Can you please suggest me what would be the issue is and how to resolve it?



Edited 1 time(s). Last edit at 08/03/2010 09:56PM by babu suri.

Options: ReplyQuote


Subject
Written By
Posted
java.sql.SQLException: Access denied for user 'alias name'@'IP address' (using password: YES)
August 03, 2010 09:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.