MySQL Forums
Forum List  »  Knowledge Base

Re: Best parctive for renaming root user
Posted by: Thomas Kettenbach
Date: December 27, 2008 11:49AM

I haven't tested it, however:
mysql organizes its users int the mysql database. You may just do an
update mysql.user set user = 'the_secret_user' where user = 'root';
flush privileges;

Options: ReplyQuote

Written By
Re: Best parctive for renaming root user
December 27, 2008 11:49AM

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.