MySQL Bugs: #69386: My SQL Connector for .NET 6.6.5 Issue with Old Password Error

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:	Windows (Windows 7 64bit)
Assigned to:	Assigned Account	CPU Architecture:	Any

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

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.

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".