MySQL: Why are there two roots localhost, and localhost.localdomain?
 

I installed MySQL recently. The first thing I did was try to change the password and remove anonymous login. However, when I select the user table, I notice that by default there are two root account and two anonymous accounts. One is for localhost and the other is for localhost.localdomain. I am not knowledgable about networking, what's the difference between localhost and localhost.domain?

Paul

is kind of like an alias, I might not try to explain it because I will get it wrong. However I wanted to tell you that you can easily automate the post-installation process by executing the mysql_secure_installation command from the shell. It's a text-wizard that automate the root password, delete test tables, etc.

I read through the documentation again. Basically, when you install MySQL, it actually creates two accounts. One is for access from the local machine, the other allow remote access. I assume that localhost is for local access and localhost.localdomain is for remote. You also have two accounts for anonymous login.

Note that this dual account only applies to Linux. When you install MySQL on windows, there is only one account.

I would also remove the remote root account for security. So you start with only a root user that can only access mysql from the machine itself.

Even then I think the best option is to go into the /etc/my.cf file and set the skip-networking.

That's assuming that the web server is on the same machine as the MySQL? If that's the case, you can't turn off networking.

Reading through the documentation, one of the recommendation is to run MySQL under another account other than root. This account should have no file permission. That way when mysql is compromised, the attacker can't use the file functionality to get to the rest of the machine. I notice that on my system, mysqld is already running as the user mysql. Either MySQL install this by default or mysql_secure_installation command that Jzarecta mentioned install it that way.

Paul

To my knowledge, it is by default user/group mysql/mysql.