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
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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

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
Operating System: Windows


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 8 guests