[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?
'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.