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

[Maurice de Laat <muisnetw@xxxxxxxxx>]

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