Replace Root User

[tidrion]

Obviously everyone knows that mysql ships with the default root user. I was wondering (for security) if it was possible to replace the root user with another user account or if the root user had certain privaliges that others could not have.

 

[sleipnir214]

All user permissions, including the permissions for the root user, are, to the best of my knowledge, defined in the mysql database -- there is nothing built into the code for the admin user.

You should be able to modify the username for the root user in the user table in the mysql database and issue a "flush privileges" query.



Want the best answers? Ask the best questions!

TANSTAAFL!!