SQLSTATE(HY000) (2000) mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication.

1 문제상황

[root@zetawiki ~]# cat a.php
<?php
$dbh = new PDO("mysql:host=13.57.92.46", 'testuser', 'P@ssw0rd');

[root@zetawiki ~]# php a.php
PHP Fatal error:  Uncaught exception 'PDOException' with message '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' in /root/test.php:2
Stack trace:
#0 /root/test.php(2): PDO->__construct('mysql:host=13.5...', 'testuser', 'P@ssw0rd')
#1 {main}
  thrown in /root/test.php on line 2

2 같이 보기

• PHP Fatal error: Uncaught exception 'PDOException' with message 'could not find driver'