MySQL Forums
Forum List  »  Newbie

accidently deleted my root privileges MySQL 5.7 on Linux Mint 18
Posted by: Dave Henzler
Date: June 30, 2018 07:22AM

Been working just fine. I was adding a new account and noticed root access to it which for some reason I decided was not what I wanted. Erased it, and I now have no privileges.

Accomplished this using phpMyAdmin. works fast! even making big mistakes.

HELP ! I've tried everything to restart mysqld --skip-grant-tables &

and can't get it to work... says socket isn't there.. of course not mysqld isn't running.

The only way I can stop and start mysqld seems to be with:

#service mysql stop

#service mysql start

I've got some Word Press sites that I'll be needing to update. This is killing that.

Dave

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.