MySQL Forums
Forum List  »  Knowledge Base

Best parctive for renaming root user
Posted by: Jeff Medina
Date: May 30, 2008 08:55AM


I'm looking around for the best practice for renaming the default root user that was created during the install.

I'm a bit confused since I found an article that renames the root user by calling an update on the mysql.user table:

I also found that "rename" has been added since MySQL 5.0.2 but requires migrating privs and objects owned by the old user to the new user:

Some gui tools like Toad recreates the user then regrants the privs to the new user when renaming.

Which one would be the cleanest and supported way of renaming the "root" user as part of securing the db for version 5.0.45?


Options: ReplyQuote

Written By
Best parctive for renaming root user
May 30, 2008 08:55AM

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.