MySQL Forums
Forum List  »  Newbie

Re: MySQL Server 5.6 restart does not restore users and schemas
Posted by: Nicholas Taylor
Date: September 10, 2017 11:02AM

Peter Brawley Wrote:
> To restart the mysql server, it's not necessary to
> restart the machine it's running on. Just restart
> the service, eg in the Windows service applet.
> Did you make direct changes to MySQL datadir files
> or folders? If so, (i) that's usually disastrous,
> (ii) you might try bringing down the mysql server,
> undoing those changes, then bringing it back up
> again.

Hi Peter, I knew there was a way, but decided a restart of the PC was needed anyway. I didn't make any changes to the datadir. I only modified the settings in the my.cnf file to utilize all threads.

> To remove Workbench as a variable, did you try
> accessing the database(s) and tables in question
> via the mysql client as a user with privs for
> them? What happens when you do that?

I tried connecting via the client with my username, but it tells me that I'm not allowed permission. I am looking at my error log and I see some errors:

Warning - No existing UUID has been found so we assume that this is the first time this server has...

Error - InnoDB: .\libdata1 can't be opened in read-write mode

Error - InnoDB: The system tablespace must be writable!

Error - Plugin 'InnoDB' init function returned error.

Error - Plugin 'InnoDB' registratino as a STORAGE ENGINE failed.

Error - Unknown/Unsupported storage Engine: InnoDB

Error - Aborting

Options: ReplyQuote

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.