Root pasword

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

Root pasword

Postby Kurnia » 17. December 2012 06:05

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 ?
Kurnia
 
Posts: 2
Joined: 28. November 2012 09:25
XAMPP Version: 1.8.0
Operating System: Windows

Re: Root pasword

Postby Altrea » 17. December 2012 06:12

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
free software according to purpose of usage
XAMPP 1.8 for local development/testing only
Zend Server 6 (free) for production environments
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 4496
Joined: 17. August 2009 13:05
XAMPP Version: 1.8.0
Operating System: W7Ux64

Re: Root pasword

Postby Kurnia » 17. December 2012 06:38

Thank you for the answer, it is very helpfull.
Kurnia
 
Posts: 2
Joined: 28. November 2012 09:25
XAMPP Version: 1.8.0
Operating System: Windows


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 0 guests