ROOT access denied when altering privileges

[email protected] Sat, 16 Dec 2006 08:57:17 +0100
Newsgroups gmane.comp.db.mysql.windows
Organization Skupina SGH
Message-ID <[email protected]>
Hello experts,

 I use MySQL 5.0.27 without problems since it was released.
 But now all of the sudden, my ROOT user fails with some privileges
 administration tasks:

 --
 mysql> REVOKE ALL PRIVILEGES ON `anyDatabase` . * FROM 'someuser'@'localhost';
 ERROR 1044 (42000): Access denied for user 'root'@'%' to database 'anyDatabase'
 --
 
 On the other hand, ADDING privileges and users works!
 Also creating and deleting databases works!

 --
 CREATE USER 'testuser'@ 'localhost' IDENTIFIED BY '****************';
 --
 
 I tried to repair and optimize "mysql" table,
 then I did FLUSH PRIVILEGES,
 restarted MySQL server...
 but still I cannot revoke privileges when I am looged in as "root".

 Then I created new "root2" user,
 granted almost all privileges to it - success.
 But also with this new "root2" user i STILL CANNOT REVOKE PRIVILEGES.

 Any idea?
 

--
Best regards,
Andrej
----------------
[email protected]
----------------



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]