Re: MySQL: What if .... ?
| From: | Hugh Bothwell | Date: | Mon, 10 Dec 2001 17:23:19 +0000 |
| Subject: | Re: MySQL: What if .... ? | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-10830@lists.php.net to get a copy of this message | ||
"G Schneider" <jefferrs@blueyonder.co.uk> wrote in message
news:20011209165715.77318.qmail@pb1.pair.com...
> What do you do if the only root user has removed all his own privileges?
>
> How do you rectify the situation without reinstalling MySQL?
>
> Thanks,
> - Jefferrs
MySQL keeps its own privileges database as a set of files
in mysql/data/mysql ... if you have a backup of this directory,
you could restore it.
Failing that, possibly someone could tell you how to
manually patch one or more of these files to reset the
privileges.