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
-10
Reinstalling the software fixes the issue, just make sure not to delete the htdocs folder in the process.
重新安装软件可以解决问题,只需确保不要删除过程中的htdocs文件夹。
#2
29
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
14
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
3
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
0
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
0
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
0
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
-4
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/
#1
-10
Reinstalling the software fixes the issue, just make sure not to delete the htdocs folder in the process.
重新安装软件可以解决问题,只需确保不要删除过程中的htdocs文件夹。
#2
29
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
14
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
3
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
0
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
0
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
0
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
-4
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/