ROOT access denied when altering privileges

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
----------------
labsy@seznam.org
----------------



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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
----------------
labsy@seznam.org
----------------



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=labsy@seznam.org


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



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org