Page 1 of 1

Root pasword

PostPosted: 17. December 2012 06:05
by Kurnia
I changed password for user 'root' with phpMyAdmin from blank to 'admin'. It is done successfully. 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)."
I tested to open(user : root, password 'admin') with another MySQL GUI(SQLyog) and it is done successfully. Is it my mistakes or something wrong with phpMyAdmin ?

Re: Root pasword

PostPosted: 17. December 2012 06:12
by Altrea
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.

best wishes,
Altrea

Re: Root pasword

PostPosted: 17. December 2012 06:38
by Kurnia
Thank you for the answer, it is very helpfull.