I'd love to know why when you first install MySQL on a server there are three
root users entered into the users table each with different host addresses. One with
localhost one with
127.0.0.1 and one with
::1 (for IPv6).
I don't really understand why all three are necessary. Will it enhance security to delete the
root@::1 and only leave
email@example.com with access? Would that be a good thing to do or not? If not, what are the other host addresses used for?
NB: I'm running MySQL on an ubuntu based server.