SAMPLE SYNTAX 

SELECT CONCAT(name, ' is in ', region) FROM cia WHERE name LIKE 'D%'

To fix this problem you need to run the following in MySQL command line:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user';

mysql> FLUSH PRIVILEGES;

More info on this:
http://dev.mysql.com/doc/mysql/en/old-client.html

Türkay DARCAN
Aynet Bili?im Teknolojileri A.?

This happens because the latest versions of MySql uses a new format for the password (it's a longer hash). In order for old clients to continue to use the newer server, you have to set the passwords on the server to their old format or upgrade your client. Because upgrading the client can sometimes be a pain, it's often easier to just update the passwords to the old format on the server.
Run mysql and login as root:

mysql -u root -p

UPDATE mysql.user
SET password=OLD_PASSWORD('somepassword')
WHERE user='someuser'
AND host='somehost';

flush privileges;