Right now the various mysql_* modules will pull default connection
information from the ~/.my.cnf file. This is especially important to
make things repeatable especially when the server is newly provisioned
and insecure.
But it doesn't use the socket information in the ~/.my.cnf file.
Instead if your sever has the socket in a different spot you need to
explicitly set it in every task. Not a huge deal, just slightly
annoying when you don't need to specify the user/pw for each task.
Would a PR be accepted that would use the socket from .my.cnf as the
login_unix_socket if one exists?