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

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

1
SET old_passwords = 0;
2
SET PASSWORD FOR 'root'@'localhost' = PASSWORD ('admin');
3
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD ('admin');
4
FLUSH PRIVILEGES;

Leave a Reply

Your email address will not be published. Required fields are marked *