Re: [cobalt-users] Mysql: Root's rights are gone

["Ian" <cobalt@xxxxxxxxxxxxx>]

On 28 May 2003 at 17:03, Maurice de Laat wrote:

> Hello,
> 
> I guess I do have an issue here where root's rights are gone in mysql...
> 
> Symptoms:
> 
> All php/mysql websites still function. All users can login to
> phpmyadmin, and work without any error.
> 
> Root can also login with phpmyadmin, but can't browse any databases, the
> error is:
> select command denied to user: 'root@localhost' for table 'xxx'
> 
> If root wants to edit the users, an error comes up:
> Warning: Supplied argument is not a valid MySQL result resource in
> /home/phpMyAdmin/user_details.php on line 970, and below that: no user(s)
> found.
> 
> This happened after someone wanted to create a user, or edit that new user's
> rights. He may have deleted rights or users or something else...
> 
> MySql has not yet been restarted; I don't know if doing so will make things
> worse.
> 
> I do have a mysqldump of all databases from last night, and par instructions
> from raqbackup, I know how to restore that. But I prefer not to restore all
> the databases, because there's no error in them (at least not at this
> point), and that will delete all new information after last night.
> 
> Thank you for any help.
> -- 
> Maurice de Laat

You do not have to restore all the databases, just the 'mysql' 
database.

This contains all the usernames / passwords / hosts / permissions 
etc.

Regards

Ian
--