Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password] SQLSTATE[HY000]  The server requested authentication method unknown to the client
I get the error above while trying to connect to my MySQL database server on Hostgator, using a
PHP script on my local server. I understand it's a password hashing issue usually between pre MySQL 4.1 and MySQL 4.1+.
I've changed my local server to use the old_password following the instruction I found here.
After changing it to 16 bit hash, I still can not connect, and the error message remains the same. And more so, I can no longer login to
phpmyadmin. I'm using
XAMPP on windows. Please any suggestions on how to solve these problems?