Bug #69386 My SQL Connector for .NET 6.6.5 Issue with Old Password Error
Submitted: 3 Jun 2013 4:03 Modified: 3 Jul 2013 18:46
Reporter: Destiny Solutions Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:6.6.5 OS:Microsoft Windows (Windows 7 64bit)
Assigned to: Assigned Account CPU Architecture:Any

[3 Jun 2013 4:03] Destiny Solutions
Description:
Hello,

I try to connect MySql 5.0.45 Server using Visual Studio 2008 c#.net.

I Download latest version of MySql Connector and install in my system.

add reference and try to connect that using This Connector. and it give me error like "Old Password no support. use 4.1 Style Password."

I reset my password and set 4.1 + Compatible password in my Sql server but steel it give me error.

so Please check and let me know.

Thanks,

How to repeat:
Always
[3 Jun 2013 18:25] Fernando Gonzalez.Sanchez
Hi,

Old style password were deprecated. 4.1 style passwords are still supported Please follow these troubleshooting steps (to verify you are really using 4.1 passwords):

1) You can check this by inspecting the value of server variable old_passwords with

show variables like 'old_passwords'

It must be zero, see 
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_old_passwords

2) If old_passwords is 1, set it to 0
3) Reset the password with
set password for 'user'@'host' = password( '123' )
 (if old_passwords is 1, then it will function password will behave the same than function old_password).

Hopefully, that should get you back on track, otherwise let us know.
[4 Jul 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".