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

["Greg O'Lone" <greg@xxxxxxxxxxxxxxxx>]

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx 
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx] On Behalf Of 
> Maurice de Laat
> Sent: Wednesday, May 28, 2003 11:03 AM
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: [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
> 
Maurice,

Have you tried deleting and recreating the root user?

http://www.mysql.com/doc/en/Resetting_permissions.html


--
Greg O'Lone, President
Stretched Out Software, Inc
http://www.stretchedout.com