When I start/restart the mysql service, I always see this row in the log:
2017-07-19T17:35:02.379166Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO)
What is it trying to do? And how can I set the user/password/host for this operation? (it should be 127.0.0.1
and not localhost
because I have skip_name_resolve=1
)
I already have a .my.cnf in my home folder, but mysql is running under the mysql user, so should I create a .my.cnf file in the mysql home? Would this be safe?
I'm using a Percona Server 5.7