SQL migration playbooks questions

I would expect that a socket connection is used by root when connecting to localhost, not the details from /root/.my.cnf?

Another user was having problems like this the other day, perhaps there might be some suggestions in this thread that help you?