very good article..I got some doubts ..If we have copy user* from recover instance to original instance only root user will be copied..What about if we have other users like backup user,other users?????

And also i have faced table corruption when i copy from 3307 to 3306.

Although this is Nice article , I did this step before, but that was much easier than this.

1- Go to /var/lib/mysq/mysql
2- vim user.MYD
3- check the password in the file
4- In Every production server there will be backup user with reload privileges
5- enter the MySQL with backup user
6- below command will show the backup user encrypted password
select user,password from mysql.user where user=’backup’;
7- now on OS command prompt replace with below command

sed -i ‘s/611c244e5a929da3/1d86bc847e3f5728/g’ user.MYD

8- enter the mysql prompt with backup user and execute below command

FLUSH TABLE;
FLUSH PRIVILEGES;
now exit

9- enter with root new password of backup user password without restarting MySQL

minimum backup user privileges needed.for production database

GRANT SELECT, RELOAD, EXECUTE, SHOW VIEW, EVENT ON *.* TO ‘backup’@’localhost’

That is super helpful and it does save lives especially for mission critical applications.

Quick question: If someone is logged in with the old root password, and the above is done, will he be logged out or will he still be logged in?