本文介绍了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';

然后重新启动.

一些魔术将会发生!

这篇关于XAMPP PhpMyAdmin错误1045,“对用户'root'@'localhost'的访问被拒绝的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-28 14:23