Best parctive for renaming root user
Hi,
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:
http://dev.mysql.com/tech-resources/articles/securing_mysql_windows.html
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:
http://dev.mysql.com/doc/refman/5.0/en/rename-user.html.
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?
Thanks,
Jeff
Subject
Views
Written By
Posted
Best parctive for renaming root user
8942
May 30, 2008 08:55AM
3393
November 13, 2008 12:14PM
3178
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.