How to return the lost password phpMyAdmin, XAMPP

Question

I have a localhost running on XAMPP on Mac. At some point, I set a password in phpMyAdmin, which I forgot. Can someone help me return to phpMyAdmin? I watched tons of textbooks, but all of them either do not work, or refer to some kind of file that does not 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 

Answer 1

Reinstalling the software fixes the problem, just make sure that you do not delete the htdocs folder in the process.

Answer 2

You want to edit this file: "\ XAMPP \ PHPMYADMIN \ config.inc.php"

change this line:

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

regardless of your password. If you do not remember your password, run this command in a command shell:

 mysqladmin.exe -u root password WhateverPassword 

where "WhateverPassword" is your new password.

Answer 3

There is a batch file called resetroot.bat located in the xammp folders "C: \ xampp \ mysql" and it will remove the phpmyadmin passwords. Then all you have to do is start the MySQL service in xamp and click on the xamp button.

Answer 4

The question may be outdated, but I am now struggling with the same problem.

After deleting passwords using resetroot.bat , according to the Nedshed instructions, you can choose a different password by selecting http://localhost/security/index.php

Answer 5

It is best to go to your phpmyadmin folder and open config.inc.php and change allownopassword = false to $ cfg ['Servers'] [$ i] ['AllowNoPassword'] = true;

Answer 6

The only solution for me:

(source: fooobar.com/questions/944832 / ... )

You need to stop Mysql and change the user password using commands.

Answer 7

Hi, this worked for me "/ opt / lampp / xampp security" in Centos

[root @XXXXX ~] # / opt / lampp / xampp security

XAMPP: quick security check ...

XAMPP: Your XAMPP pages are password protected.

XAMPP: Do you want to change your password anyway? [no Yes

XAMPP: Password:

XAMPP: Password (again):

XAMPP: password protection is active. Please use "xampp" as your username!

XAMPP: MySQL is not accessible through the network. Good.

XAMPP: MySQL has a set of root passwords. Excellent!:)

XAMPP: FTP password for user "daemon" is still set to "xampp".

XAMPP: do you want to change the password? [yes]

XAMPP: Password:

XAMPP: Password (again):

XAMPP: restart ProFTPD ... ok.

XAMPP: Done.

[root @XXXXX ~] #

Answer 8

If you have not changed your password, by default you do not need to enter a password to connect to the MYSQL server, try:

mysql_connect('localhost','root','');

if not, then you can export your databases to an external file, just follow these instructions.

http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html

if you cannot access phpMyAdmin try

http://www.simplehelp.net/2008/11/26/how-to-reset-a-lost-mysql-root-password/