Not the answer you need?
Register and ask your own question!

Pros and cons of changing the root username in MySQL

sawoznysawozny EntrantCurrent User Role Novice
Well, like it says on the tin, I'm curious if anyone has renamed the [email protected] MySQL user ID in operations and why (or, conversely, if you pushed back against it when requested and, of course, why). I can see there being a slight security advantage in that if a bad / injected script depended on the username being root, it wouldn't work, but I can also see an operational disadvantage for useful utilities not working because the root user doesn't exist (if they don't make it easy to use another user ID).

In my case, the only time I use the root user is for local client tool operations and I can easily put whatever I want after the -u switch, but I'm curious if anyone on the forums got bit in some other way by doing this (or avoided getting bit by not doing it) or if making the change saved somebody from a security issue.


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.