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

["Robert Roose" <robertr@xxxxxxxxxxxxx>]

just restore the mysql database.. this will restore all needed rights to the databases.


> -----Oorspronkelijk bericht-----
> Van: Maurice de Laat [mailto:muisnetw@xxxxxxxxx]
> Verzonden: woensdag 28 mei 2003 17:03
> Aan: cobalt-users@xxxxxxxxxxxxxxx
> Onderwerp: [cobalt-users] Mysql: Root's rights are gone
> 
> 
> 
> 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
> 
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>