Re: Accidentally delete 'root' account
A workaround. On another machine, install the same version of MySQL. Ensure innodb_file_per_table is ON and that it has a working root account with full privs. Once it's working without error, bring it down.
On the existing system, ensure also that innodb_file_per_table is ON. Bring down this server too. Copy the mysql database table files from the other installation's data\mysql folder into this installation'sdata\mysql folder. Move data\ib_logfile* to a safe place. Start it up, log in as root.
Please let us know the result.
Subject
Written By
Posted
Re: Accidentally delete 'root' account
May 30, 2022 03:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.