Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’)

1. generate mysql5 hash value of mysql password

2. execute SET PASSWORD FOR ‘username’ = ‘*aa1420f182e88b9e5f874f6fbe7459291e8f4601′ in phpmyadmin

References

1. http://www.insidepro.com/hashes.php

2. http://stackoverflow.com/questions/4807072/windows-7-php-mysql-connection-issues