[Client does not support authentication protocol], i have read the page in mysql

[cpthk]

[Client does not support authentication protocol], i have read the page in mysql http://dev.mysql.com/doc/mysql/en/Old_client.html
and i type :
SET PASSWORD FOR(enter)
'gladiaconair'@'localhost' = OLD_PASSWORD('newpwd');(enter)
and it say's:
mysql> SET PASSWORD FOR
    -> gladiaconair@localhost = OLD_PASSWORD('newpwd');
Query OK, 0 rows affected (0.00 sec)
it does not do anything to me.
can everyone help me with?

[Nibbler]

'0 rows affected' means it didn't change anything. Make sure you specified the correct user. Alternatively use a pre 4.1 version of mysql. This is not a coppermine issue so we can't really help you much.