MySQL Cannot Connect to MySQL 4.1+ Using the Old Insecure Authentication

January 8, 2015

Install phpMyAdmin di localhost AppServ namun kemudian tidak bisa diakses karena alasan old password? Begini caranya

Database connection failed: 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’).

login via Run -> cmd
login ke mysql dgn user root

SET old_passwords = 0;
SET PASSWORD FOR 'root'@'localhost' = PASSWORD ('admin');
SET PASSWORD FOR 'root'@'' = PASSWORD ('admin');