MySQL Forums
Forum List  »  Newbie

Re: MySQL Server 5.6 restart does not restore users and schemas
Posted by: Peter Brawley
Date: September 10, 2017 10:39AM

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.

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?

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.