Bug #68379 very long passwords are not stored correctly

• Submitted: 14 Feb 2013 12:09
• Modified: 15 Feb 2013 21:40
• Reporter: Leon Fellows
• Status: Verified
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: 5.2.4
• OS: Windows (vista)
• CPU Architecture: Any
• Tags: passwd, password

[14 Feb 2013 12:09] Leon Fellows

Description:
I have set up a mysql-user. The user has a very long password (>255 characters). 
When I connect directly or via python MySQLdb, the connection is established correctly.
But when I connect (with a stored) mysql odbc connector connection I get following error message:
Connection Failed: [HY000] [MySQL][ODBC 5.2(a) Driver]Access denied for user 'newUser'@'dslb-188-096-096-096.xxx.net' (using password: YES)

How to repeat:
- Create mysql user with password longer than 255 chars.
- Create new system DSN with mysql odbc connector
- enter host, user and password
- press ok (in order to store the connection)
- open the connection again
- press "Test connection" button

[15 Feb 2013 21:40] MySQL Verification Team

Thank you for the bug report. The connection test works before to save the system DSN connection, when saved and reopened it fails how reported.