i have a mysql installation with lots of users and grants. But one grant is unique, since its supposed to be a simple DB user and usually does not need GRANT privileges. However someone added it when the account where added. It looks like this:
GRANT USAGE ON *.* TO 'freg2'@'%' IDENTIFIED BY PASSWORD '*XXXXX'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, \ REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, \ LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, \ CREATE ROUTINE, ALTER ROUTINE \ ON `freg2`.* TO 'freg2'@'%' WITH GRANT OPTION;
I searched the net (and this site) for a solution on how to remove that "GRANT OPTION" thingy, without recreating the whole grant/account . so far without luck.
Is there really no way just to remove "this" privilege or right from that account ?
thanks in advance.