MySQL and Perfect Setup Mandriva 2007
I have done both this setup and have done Mandriva 2005 dozens of times with no problems. I have now reformatted the drives a half dozen times, and reinstalled fresh and I keep getting the same results. When I do:
mysqladmin -u root password (my password here)
it returns, with no error. Then I do this:
mysqladmin -h servername.domain.com -u root password (my password here)
I get this as a result:
mysqladmin: connect to server at 'servername.domain.com' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Like I said, I have used these tutorials as guides dozens of times with no problems, this time, I get the same thing over and over. What am I doing wrong?