Kurnia wrote:But when I started phpMyAdmin again it('admin') is not recognized by phpMyAdmin and I get wrong message :
"Access denied for user 'root'@'localhost' (using password: NO)."
You don't get a wrong message. phpmyadmin tries to connect without any password, and thats absolutely correct.
Just because you change a password in mysql, phpmyadmin can't know that automatically.
You have to tell phpmyadmin what you want to do. You have two possibilities:
- Write down your phpmyadmin password in your phpmyadmins config.inc.php
- change the auth_type value in your phpmyadmins config.inc.php from config to cookie or http and login yourself
The second option is the recommend one from security point of view.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~free software according to purpose of usageXAMPP 1.8
for local development/testing onlyZend Server 6 (free)
for production environments
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~It's like porn for programmers