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@localhost
& root@::1
and only leave [email protected]
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.