phpMyAdmin-无法连接-无效的设置-自从我添加了root密码以来-已被锁定 [英] phpMyAdmin - can't connect - invalid setings - ever since I added a root password - locked out

问题描述

我运行XAMPP， 几天前，我已经通过phpmyadmin为root密码设置了密码 从那时起我一直无法访问phpMyAdmin

I run XAMPP, a few days back i had set up a password for the root password through phpmyadmin I am not able to access phpMyAdmin ever since that moment

我关注了此链接中的帮助，但一切似乎都很好(在config.inc.php中).我什至尝试完全释放xampp，重新启动Windows，然后重新安装xampp，但仍然指向localhost/phpmyadmin，但出现以下错误

I followed help on this link but everything seems fine there (in config.inc.php). I even tried unistalling xampp fully, restarting windows and then reinstalling xampp, but still pointing to localhost/phpmyadmin I get the following error

MySQL said: 
Cannot connect: invalid settings. 
phpMyAdmin tried to connect to the MySQL server, and the server rejected the
connection. You should check the host, username and password in your
configuration and make sure that they correspond to the information given
by the administrator of the MySQL server.

我还尝试按照mysql网站帮助中的说明通过mysqld.bat重置root密码，但无济于事

I Also tried to reset root password through mysqld.bat as given on mysql's website help but to no avail

请帮助！ 这是描述情况的屏幕截图:

Please Help! Here's a screenshot describing the situation:

推荐答案

进入XAMPP安装文件夹中的phpMyAdmin目录.将有一个名为config.inc.php的文件.在该文件中，找到以下行:

Go inside your phpMyAdmin directory inside XAMPP installation folder. There will be a file called config.inc.php. Inside that file, find this line:

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

您必须确保此字段具有您的mysql根密码(您设置的密码).

you must make sure that this field has your mysql root password (the one that you set).

这篇关于phpMyAdmin-无法连接-无效的设置-自从我添加了root密码以来-已被锁定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！