如何找回丢失的phpMyAdmin密码，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?

我在Mac上的XAMPP上运行本地主机。在某些时候,我在phpMyAdmin中设置了一个我忘记的密码。任何人都可以帮我回到phpMyAdmin吗?我已经遵循了大量的教程,但它们都不起作用或者引用一些似乎不在我的计算机上的文件。有一个简单的方法吗?

When I try to open:

当我尝试打开时:

http://localhost 

I get:

The Server http://localhost:80 requires a username and password

8 个解决方案

#1

Reinstalling the software fixes the issue, just make sure not to delete the htdocs folder in the process.

重新安装软件可以解决问题,只需确保不要删除过程中的htdocs文件夹。

#2

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

您要编辑此文件:“\ 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.

其中'WhateverPassword'是您的新密码。

#3

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.

有一个名为resetroot.bat的批处理文件,位于xammp文件夹'C:\ xampp \ mysql'中运行它,它将删除phpmyadmin密码。然后你需要做的就是在xamp中启动MySQL服务并单击admin按钮。

#4

The question may be getting old, but I've struggled with the same issue just now.

这个问题可能会变老,但我刚才也遇到了同样的问题。

After deleting passwords with resetroot.bat, as instructed by Nedshed, you can choose another password by going to http://localhost/security/index.php

按照Nedshed的指示使用resetroot.bat删除密码后,您可以通过访问http://localhost/security/index.php来选择另一个密码。

#5

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

最好的方法是转到你的phpmyadmin文件夹并打开config.inc.php并将allownopassword = false更改为$ cfg ['Servers'] [$ i] ['AllowNoPassword'] = true;

#6

The only solution worked for me:

(source: https://*.com/a/22784404/2377343 )

(来源:https://*.com/a/22784404/2377343)

You need to stop Mysql and change user password using Commands.

您需要使用命令停止Mysql并更改用户密码。

#7

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

嗨这对我来说是Centos中的“/ opt / lampp / xampp security”

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

[root @XXXXX~]#/ opt / lampp / xampp安全

XAMPP: Quick security check...

XAMPP:快速安全检查......

XAMPP: Your XAMPP pages are secured by a password.

XAMPP:您的XAMPP页面由密码保护。

XAMPP: Do you want to change the password anyway? [no] yes

XAMPP:你还想改变密码吗? [不]是的

XAMPP: Password:

XAMPP: Password (again):

XAMPP:密码(再次):

XAMPP: Password protection active. Please use 'xampp' as user name!

XAMPP:密码保护处于活动状态。请使用'xampp'作为用户名!

XAMPP: MySQL is not accessable via network. Good.

XAMPP:MySQL无法通过网络访问。好。

XAMPP: MySQL has a root passwort set. Fine! :)

XAMPP:MySQL有一个root passwort集。精细! :)

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

XAMPP:用户'守护程序'的FTP密码仍设置为'xampp'。

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

XAMPP:你想更改密码吗? [是]

XAMPP: Password:

XAMPP: Password (again):

XAMPP:密码(再次):

XAMPP: Reload ProFTPD...ok.

XAMPP:重新加载ProFTPD ......好的。

XAMPP: Done.

[root@XXXXX ~]#

#8

Unless you have changed your password the default setting dont require you to enter a password to connect to the MYSQL server, try:

除非您更改了密码,否则默认设置不需要您输入密码以连接到MYSQL服务器,请尝试:

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

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

如果没有,那么您可以将数据库导出到外部文件,只需按照这些说明操作即可。

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

if you are unable to access phpMyAdmin then try,

如果您无法访问phpMyAdmin然后尝试,

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