XAMPP PhpMyAdmin 错误 1045，“拒绝用户 'root'@'localhost' 的访问
我看到这个问题已经被问过很多次了，但我没有找到解决我的问题的方法.在 config.inc.php
I see this question has been asked many times, but I don't find a solution for my problem. Tried all possible combinations in config.inc.php
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';
/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
我安装了 XAMPP.在 PhpMyAdmin 中，我修改了 root@localhost 的密码.我可以使用新密码登录 PhpMyAdmin.
I installed XAMPP. In PhpMyAdmin I modified the password of root@localhost. I am able to login to PhpMyAdmin using the new password.
但是，当我按照 drupal 安装步骤添加新用户 Drupal 时，出现此错误:
But when I Add a new user Drupal as per drupal installation steps, I get this error:
Error 1045, "Access denied for user 'root'@'localhost' (Password: YES)
但是仍然创建了drupal用户，但没有创建mysql中的drupal数据库.
But still the drupal user gets created but the drupal database in mysql doesnt get created.
当我尝试单独创建 drupal 数据库时，我能够做到.
When I try to create drupal database separately I am able to do it.
除此之外，我尝试了 MySQL.exe -u root -p.它在那里工作正常，所以我不确定.
Apart from this I tried MySQL.exe -u root -p. It works fine there, so I am not sure.
推荐答案
在 config.inc.php
In the config.inc.php
编辑
$cfg['Servers'][$i]['auth_type'] = 'whatever_it_is';
到
$cfg['Servers'][$i]['auth_type'] = 'cookie';
然后重新启动.
一些魔法会发生！！
相关文章