Quote:
I am not using password yes, and I am not connecting to localhost.localdomain but rather just localhost
basically this a a MySQL authentication issue – connection is OK!
first:
“using password = YES ” just tells that you are using password. MySQL will not send print the password in readable form on the screen, but use this 'metafor”
next:
“I am not connecting to localhost.localdomain but rather just localhost” . Yes that is a problem with the configuration on certain variants of *nix!
“database user name and password using the command line login in a shell” Problem is that a shell logon is not tunnelling and the two may be treated differently by the OS.
This FAQ has some similar discussions..
http://www.webyog.com/faq/23_36_en.html
Is it possible to create a 'user'@'localdomain' by using some alias or the ip? What about 127.0.0.1 as host ??
This 'localdomain' occurring form time to time can be tricky. And I am naot the expert to answer it.
Please post any solution that you may find – by studying configuration, experimenting or by the help of others.