OK, I've come to the conclusion that I'm doing something wrong, but can't for the life of me figure out what it is. Going over and over and over documentation, I must be interpreting something wrong, because I think I'm doing what it says.
I'm setting up a new box with CentOS. Installed MySQL, and it's running. Now I get to setting the password. Here's the issue.
I start with:
mysqladmin -u root password SQLROOTPASSWD.
No problem
Then I try:
mysqladmin -h myserver.mydomain.com -u root password SQLROOTPASSWD.
This is where things go South. I get the response
mysqladmin: connect to server at '(my server)' failed
"Access denied for user 'root'@'192.168.1.160' (using password: NO)'
I'm at a loss. Hours of fighting with this, and I'm nowhere... Help?