Roundcube 0.9.0 - mysql DB error

[ese2709]

i have problem with my installation roundcube

roundcube version : 0.9.0
php : 5.4.11
mysql : 5.5.28
cpanel version : 11.34.1 (build 7)

error

Check DB config


Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password] in /home/xxx/public_html/mail/program/lib/Roundcube/rcube_db.php on line 144
DSN (write):  NOT OK(SQLSTATE[HY000] [2054] The server requested authentication method umknown to the client)
Make sure that the configured database exists and that the user has write privileges
DSN: mysql://xxx_mail:password@localhost/xxx_jpmail

i have make set privileges to user and add user to database...

someone can help me?

[alec]

This error message is shown when you are connecting to a MySQL database that has its passwords stored in the old password format (http://dev.mysql.com/doc/refman/5.0/en/old-client.html). Newer MySQL clients do not allow a connection to be made to databases using the old password format as it is less secure.

You can read about how to upgrade your MySQL passwords from the old format to the new format here: http://code.openark.org/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords

[ese2709]

I had ask my hosting... but they cannot give to disable old_password in mysql....

someone can help me to make others method to authentication for roundcube........