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]