Re: ROOT access denied when altering privileges

Hello,

  I solved problems with
  ERROR 1044 (42000): Access denied for user 'root'@'%' to database 'anyDatabase'

  For some weird reason, user "root" was initialy set without these
  privileges:
Create_view_priv enum
Show_view_priv enum
Create_routine_priv enum
Alter_routine_priv

  So I edited MYSQL database and and manualy added these privileges in
  table "user" for user "root".

  Then reloaded privileges:
  FLUSH PRIVILEGES;

  And now user "root" can do REVOKE on all databases.

  Regards,
  Andrej

*****************************
*** YOUR ORIGINAL MESSAGE ***
-----------------------------
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]


-----------------------------
** END OF ORIGINAL MESSAGE **
*****************************



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