Re: Demote root?
Login as root.
Create a new "super" user to replace root.
Provide the new "super" user with SUPER privilege, along with all the usual suspects.
FLUSH PRIVILEGES to make mysql re-read the privileges table.
Logout.
Login as the new "super" user.
Revoke all the unwanted privileges, including SUPER, from root.
FLUSH PRIVILEGES.
http://dev.mysql.com/doc/refman/5.6/en/privileges-provided.html
Good luck,
Barry.
Subject
Written By
Posted
Re: Demote root?
June 01, 2014 09:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.