XAMPP PhpMyAdmin Error 1045, "Access denied for user 'root'@'localhost'

Question

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

I installed XAMPP. In PhpMyAdmin I modified the password of root@localhost. I am able to login to PhpMyAdmin using the new password.

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)

But still the drupal user gets created but the drupal database in mysql doesnt get created.

When I try to create drupal database separately I am able to do it.

Apart from this I tried MySQL.exe -u root -p. It works fine there, so I am not sure.

try keeping password blank

PravinS
– PravinS

2016-03-24 11:42:51 +00:00
Commented Mar 24, 2016 at 11:42 — PravinS
– PravinS, Commented Mar 24, 2016 at 11:42

Tunaki · Accepted Answer · 2016-01-27 22:11:05Z

2

In the config.inc.php

edit

$cfg['Servers'][$i]['auth_type'] = 'whatever_it_is';

to

$cfg['Servers'][$i]['auth_type'] = 'cookie';

Then restart.

And some magic will happen!!

edited Jan 27, 2016 at 22:11

Tunaki

138k46 gold badges370 silver badges443 bronze badges

answered Jan 27, 2016 at 21:58

McAkinyi Adams

212 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matt Clark · Accepted Answer · 2015-06-11 04:15:12Z

1

Try changing

$cfg['Servers'][$i]['host'] = 'localhost';

to

$cfg['Servers'][$i]['host'] = '127.0.0.1';

edited Jun 11, 2015 at 4:15

Matt Clark

28.7k20 gold badges78 silver badges126 bronze badges

answered Jan 22, 2014 at 12:52

Johnathan Barrett

5562 gold badges7 silver badges26 bronze badges

1 Comment

Kripa Over a year ago

It was already '127.0.0.1', I changed it 'localhost'. Both does not work.

Robert · Accepted Answer · 2015-06-11 08:05:03Z

0

$cfg['Servers'][$i]['auth_type'] = 'config';

to

$cfg['Servers'][$i]['auth_type'] = 'cookie';

Restart and you will be asked for the password the next access to the phpmyadmin page

edited Jun 11, 2015 at 8:05

Robert

5,31843 gold badges70 silver badges115 bronze badges

answered Jun 11, 2015 at 7:47

raju gupta

591 silver badge5 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

1045 - access denied for user 'root'@'localhost' (using password yes)

I have tried everything but this is the best solution

Solution : Open xampp control panel config.inc.php

$cfg['Servers'][$i]['auth_type'] = 'config'; to

$cfg['Servers'][$i]['auth_type'] = 'cookie';

Work fine !!

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Nov 24, 2015 at 3:02

Chattar Singh Rathore

1

Comments

garfbradaz · Accepted Answer · 2017-07-23 13:41:54Z

0

Add the following in:

/opt/lampp/phpmyadmin/config.inc.php

Code:

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'admin';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

edited Jul 23, 2017 at 13:41

garfbradaz

3,5268 gold badges46 silver badges71 bronze badges

answered Jul 23, 2017 at 11:41

Ahmad Ali

192 bronze badges

Collectives™ on Stack Overflow

XAMPP PhpMyAdmin Error 1045, "Access denied for user 'root'@'localhost'

5 Answers 5

Comments

1 Comment

Comments

1045 - access denied for user 'root'@'localhost' (using password yes)

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

1045 - access denied for user 'root'@'localhost' (using password yes)

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related