My server is centos 7.4, mysql 5.5.
In my.cnf
,I set skip-name-resolve = 0
,which means mysql will use user@127.0.0.1
even I run user@localhost
.
Then, when I create a new user, which one is better, user@localhost
or user@127.0.0.1
?
Also, you can find root@localhost
,root@127.0.0.1
,root@::1
in a newly installed mysql.Actually there should be only one root user.Which one should be use?