Home / server / Questions / 476596
In Process
Jack
Asked: 2013-02-08 12:37:54 +0800 CST

MySql - Is there a way to reverse to use old password?

  • 772

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.

mysql

1 Answers

  1. The documentation explains how to reset the root password. The summary is to create a file containing SQL statements to set the password:

    UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

    Then stop mysqld, and manually start it again, but telling it to execute this SQL file:

    sudo -u mysqld mysqld_safe --init-file=/home/me/mysql-init
    • 2