[cobalt-users] MySQL Passwords

["Gregory Ogorek" <greg@xxxxxxxxxxxxxx>]

I know this has been covered at least 10 times, but I just can't find it.
What I do find is conflicting command lines for this.

MySQL on a RaQ 3.  My password works fine for localhost.  I have the
PHPmyadmin installed and running fine logging in as root on localhost.

Then I go to the command line.  Type

>mysql -u root -p
Enter Password: mypassword

And I get this:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

I'm able to log into mysql when I use the -h hostname.domain.ext tag.  I log
in, update the password for this root user.  And I can still log in using:

mysql -h hostname.domain.ext -u root -p
Enter Password: <blank>

I'm in.

Now PHPMyAdmin won't work.  Says the root@localhost has access denied.

When all this started, the web interface worked, but I couldn't log in using
the command line.  Now that I was able to log in using the command line in
addition to the actual hostname, the web interface does not work and I still
can't login using localhost at the command line.

What is happening?

GregO
greg@xxxxxxxxxxxxxx