Re: Unable to access DB password expired?

[Ryan Hoffman]

OK, the generic instructions worked for the root user. However, I am still unable to get the less-privileged user for the web app to reset its password.
Here are the errors I get:
mysql> ALTER USER '**********'@'localhost' IDENTIFIED BY '************';
ERROR 1396 (HY000): Operation ALTER USER failed for '***********'@'localhost'
and
mysql> UPDATE mysql.user SET authentication_string = PASSWORD('***********') WHERE
User = '**********' AND Host = 'localhost';
Query OK, 0 rows affected, 1 warning (0.01 sec)
Rows matched: 0 Changed: 0 Warnings: 1