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?