I downloaded the latest MySQL connector for .Net and I got this error "Authentication with old password no longer supported, use 4.1 style passwords."
I found a StackOverflow post on how to fix it so I stupidly logged in as root with Sqlyog and run these two quires:
SET SESSION old_passwords=FALSE; SET PASSWORD = PASSWORD('[your password]');
Now I can't log in as root. Is there a way to reverse it back to use old_password? The root password length is 41 from 16. I can't upgrade every users password because there are other users using it and I don't want to break. What's my option here? Can I use instance config wizard to change root password?
EDIT: My server is Win2003 Standard, IIS6 and I can have admin access to the server.