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?