Bug #4409 Please help !!!!

• Submitted: 5 Jul 2004 14:52
• Modified: 20 Jul 2004 0:12
• Reporter: Regine Kalinda
• Status: Not a Bug
• Category: Connector / J
• Severity: S2 (Serious)
• Version: 4.0.18-nt
• OS: Windows (window xp)
• Assigned to: Matthew Lord
• CPU Architecture: Any

[5 Jul 2004 14:52] Regine Kalinda

Description:
I am developing in java  using struts + tomcat + mysql 4.0.18-nt + JDBC
The code that connect to the database look like this:
try {
	Class.forName("com.mysql.jdbc.Driver").newInstance();
				
......some exception handling 		  }

 
Connection con = null;
try {
    con =
    DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=regine&password=regine");
} catch (SQLException e) {
	e.printStackTrace();
}  

I am having the following error:

java.sql.SQLException: Invalid authorization specification,  message from server
: "Access denied for user: 'regine@localhost' (Using password: YES)"
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1900)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:950)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1771)
        at com.mysql.jdbc.Connection.<init>(Connection.java:440)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:400)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at com.psira.ui.registration.SignonAction.openconnection(SignonAction.j
ava:149)
  

Please help I don't know what to do.

How to repeat:
Send to every body who can help, please.

Suggested fix:
Please send me the fix on [e-mail]

[6 Jul 2004 8:35] Regine Kalinda

I manage to fix it,  changing the code like this, 
  DriverManager.getConnection("jdbc:mysql://192.168.0.38:3306/test?user=&password=");
I don't undestand why because there is a username and password.

[20 Jul 2004 0:12] Matthew Lord

Hi,

This is not the correct channel for this type of issue.  You would be best helped using the 
irc channels and the mailing lists.

mysql.com/IRC
lists.mysql.com

Best Regards

[3 Aug 2004 12:21] pierre gossart

es-tu Regine Kalinda qui a fait tes études en Belgique?