password causes access denied

[tempsup]

Hi, whenever i try to set the password for the user, i get the access denied. I was abled to get into the database after removing the password.

I had tried using the ./mysqladmin flush-privileges, ./mysqladmin reload, after changing the password in the grant tables.

Does anyone know wat's wrong?? Thanx for all helps rendered.
below is the error msg.


# ./mysql -u mis -p
Enter password:
ERROR 1045: Access denied for user: 'mis@localhost' (Using password: YES)

 

[rzs0502]

What are the result(s) to the following query in the mysql database?

SELECT host FROM user WHERE user='mis';

 

[tempsup]

+-----------+
| host |
+-----------+
| localhost |
+-----------+
1 row in set (0.02 sec)

here's the result

 

[rzs0502]

Check if the password you are typing matches that of the entry in the user table.

SELECT password, password('whatever') FROM mysql WHERE user='mis';

 

[tempsup]

i had checked and ia m very sure that the password is correct. I had used 'password' as the password.

 

[rzs0502]

Tricky

SELECT host, db, user FROM db WHERE user='mis'; -->
+------+-----------+---------+
| host | db | user |
+------+-----------+---------+
| % | mydb | mis |
+------+-----------+---------+
1 row in set (0.01 sec)

SELECT host, user, password FROM user WHERE user='mis'; -->
+-----------+---------+------------------+
| host | user | password |
+-----------+---------+------------------+
| % | mis | 1bbeb95d5f956444 |
+-----------+---------+------------------+
8 rows in set (0.05 sec)

That's all that should be required...

Have you tried setting the password manually?
UPDATE user SET password=PASSWORD('password') WHERE user='mis';
And then mysqladmin flush-privileges