Page 1 of 1

Added pw to Root, can no longer access

PostPosted: 22. November 2012 20:34
by AlerekNightfall
Hey there~

I've been using xampp / mysql for a server DB, and recently noticed in phpmyadmin the notice that I need to set a password for root....so I did, for both accounts. After setting the password for the second account, I can no longer access phpmyadmin, at all. I can login via the command prompt, but cannot find a way to do so via the webbased admin panel.

How can I get back to my usual localhost/phpmyadmin page?

edit: My idiot self didn't think to try 127.0.0.1/phpmyadmin, all is well again.

Re: Added pw to Root, can no longer access

PostPosted: 22. November 2012 20:38
by Altrea
Hi AlerekNightfall,

you need to tell phpmyadmin, that you don't want to login via config any more:
  • Open \xampp\phpMyAdmin\config.inc.php
  • search for the line $cfg['Servers'][$i]['auth_type'] = 'config';
  • replace the line with $cfg['Servers'][$i]['auth_type'] = 'cookie';
  • save the file
  • clear your browser cache
  • try again to access phpmyadmin

best wishes,
Altrea