There is option to recover root access without restarting MySQL Service. But that needs creating another instance without InnoDB engine. Once we have another instance. We can copy the .frm, .myi & .myd files to new instance and change/recover root user password as we normally do in new instance and copy them back to original instance.
No comments:
Post a Comment