Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to get back Lost phpMyAdmin Password, XAMPP

I have a local host running on XAMPP on a Mac. At some point I set a password in phpMyAdmin which I've ow forgotten. Can anyone help me get back into phpMyAdmin? I've followed a ton of tutorials but they all either don't work or refer to some file that doesn't seem to be on my computer. Is there an easy way?

When I try to open:

http://localhost 

I get:

The Server http://localhost:80 requires a username and password
like image 362
Ben Pearce Avatar asked May 12 '13 19:05

Ben Pearce


2 Answers

You want to edit this file: "\xampp\phpMyAdmin\config.inc.php"

change this line:

$cfg['Servers'][$i]['password'] = 'WhateverPassword';

to whatever your password is. If you don't remember your password, then run this command in the Shell:

mysqladmin.exe -u root password WhateverPassword

where 'WhateverPassword' is your new password.

like image 173
Ricardo Parker Avatar answered Sep 29 '22 03:09

Ricardo Parker


There is a batch file called resetroot.bat located in the xammp folders 'C:\xampp\mysql' run this and it will delete the phpmyadmin passwords. Then all you need to do is start the MySQL service in xamp and click the admin button.

like image 42
Nedshed Avatar answered Sep 29 '22 03:09

Nedshed