What i have to use - this is my query:
UPDATE db_users SET passwd=PASSWORD('xxxx') where login LIKE 'root';
and this is what i get back:
Query OK, 0 rows affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 0 Warnings: 1
If i set any other value for passwd='xxxx' I get a success.
So...