phpMyAdmin - 无法连接 - 无效设置 - 自从我添加了 root 密码 - 被锁定

2021-11-20 00:00:00 root mysql phpmyadmin

我运行 XAMPP,几天前,我通过 phpmyadmin 为 root 密码设置了密码从那一刻起我就无法访问 phpMyAdmin

我关注了

解决方案

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

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

你必须确保这个字段有你的 mysql root 密码(你设置的那个).

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

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.

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:

解决方案

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'] = '';

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

相关文章