Knowledgebase: WebHosting & E-mail
How to fix Mysql error : PDOException: SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
Posted by Shivin Hameed on 22 September 2012 01:36 PM

On your php websites, you might encounter an error like the one specified below.

=======================================================

PDOException: SQLSTATE[HY000] [2000] 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'). 

=======================================================

Solution to fix this problem :

Through your Control panel, create a new mysql user with a complex password and give privileges to this user for your database.

On your website config.php, change the databse username and password with the newly created user credentials.

(5 vote(s))
Helpful
Not helpful

Comments (0)