How to solve that? /Como resolver ?
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'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
1- Go to file my.ini (windows) or my.cnf (linux), and go to the line / Ve al archivo my.cnf en linux o a my.ini en windos:
[mysqld]Set old_passwords to false belongs to the mysqld section, if you can't find it there, just add it:[mysqld]old_passwords = 0
2- Restart you server/ Reinicia tu servidor.
3-Run that comand / Corre el siguiente comando:
mysql> SHOW VARIABLES LIKE 'old_passwords'
+---------------+-------+| Variable_name | Value |+---------------+-------+| old_passwords | OFF |+---------------+-------+
And old_passwords must appear like OFF.
4-Update your users passwords with :
UPDATE mysql.user SET password= PASSWORD(¨NEW PASSWORD¨);
And you password must look like :
*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
