Re: I crashed my installation
Read again, --skip-grant-tables is not capable of fixing the problem, rather it's an option that gives you access without login authentication to the mysql database so you can inspect and repair mysql.user login data and thus fix your access problem.
That will be just the beginning. Once you can log in, you'll need to check every row and column of every table to see what else is broken.
If there's a backup, you should just restore from that backup.
(And as you've learnt, always have a backup that's current enough to make it unnecessary to redo what you don't have time to redo.)
> Unknown/unsupported storage engine: InnoDB
Sometimes that's fixed by moving ib_logfile0 and ib_logfile1 out of the mysql data folder so that MySQL can rebuild them.
Edited 1 time(s). Last edit at 04/15/2019 07:32PM by Peter Brawley.
Subject
Written By
Posted
Re: I crashed my installation
April 15, 2019 07:25PM
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.