Wamp phpMyAdmin error #1045 - Access denied for user 'root'@'localhost'

Question

This is quite common problem and I found a lot of tutorials to help me solve it, although, there is one additional problem with my case...

This is my config settings in config.inc.php

$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

When I try to log in via wamp main page, the error shows:

1045 - Access denied for user 'root'@'localhost' (using password: YES)

AND this same is when I try to acces MyAdmin by CONSOLE!

No matter what I type as password or just press enter, it shows me this same error, and because of that i cant 'flush priviliges'.

What can I do?

Are you absolutely sure that these credentials are correct?

ggdx
– ggdx

2013-11-21 21:08:05 +00:00
Commented Nov 21, 2013 at 21:08 — ggdx
– ggdx, Commented Nov 21, 2013 at 21:08
Which part confused you?

ggdx
– ggdx

2013-11-21 23:31:55 +00:00
Commented Nov 21, 2013 at 23:31 — ggdx
– ggdx, Commented Nov 21, 2013 at 23:31

Chanaka Karunarathne · Accepted Answer · 2014-11-30 20:58:53Z

14

Step 1: Open your MySQL console.

Step 2: Enter the Provided Command Lines

$use mysql;
$UPDATE mysql.user SET password="PASSWORD("YourPassword") WHERE user="root";
$FLUSH PRIVILEGES;
$exit;

Step 3: Open and edit your config.inc.php file located in your local server files

Go to My Computer > C Drive > ( Your Local Server Folder, WAMP/MAMP/XAMPP ) > APPS > PHPMYADMIN > config.inc.php
Using a text editor, such as Notepad++, open your config.inc.php file.
Find this line of code: $cfg['Servers'][$i]['password'] = ''; // MySQL password
Change ['password'] = ''; --to--> ['password'] = 'YourPassword'; with the new chosen password you created from Step 2.
Click Save

Step 4: Go to phpmyadmin go to http://localhost/phpMyAdmin/.

answered Nov 30, 2014 at 20:58

Chanaka Karunarathne

2,0562 gold badges18 silver badges14 bronze badges

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

Comments

Bill the Lizard · Accepted Answer · 2014-07-25 17:11:01Z

7

Change the line:

$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 Jul 25, 2014 at 17:11

Bill the Lizard

407k213 gold badges579 silver badges892 bronze badges

answered Jul 25, 2014 at 16:51

Javi Ps

3094 silver badges11 bronze badges

1 Comment

Hernaldo Gonzalez Over a year ago

I change the file C:\wamp\apps\phpmyadmin4.1.14\config.inc.php, this line $cfg['Servers'][$i]['password'] = 'new pass'; and worked!

RiggsFolly · Accepted Answer · 2013-11-22 21:34:58Z

4

Did you add a password to the MySQL 'root' userid?

If not, by default it comes without a password. So use

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

and remove this its a defunct parameter since phpMyAdmon 3.2.0

$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

answered Nov 22, 2013 at 21:34

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Comments

Ankit Pandey · Accepted Answer · 2017-10-04 14:38:16Z

4

Try username = root and password is blank.

answered Oct 4, 2017 at 14:38

Ankit Pandey

1,9881 gold badge20 silver badges22 bronze badges

Comments

Chris · Accepted Answer · 2013-12-28 23:56:45Z

0

after changing the root password you must first enter the following in mysql console:

FLUSH PRIVILEGES;

before the changes will take effect

Do this by openening a terminal/command console and navigating to your mysql.exe example: C:\wamp\bin\mysql\mysql5.5.24\bin\mysql -u YOURUSERNAMEHERE -p

If you have fiddled with your root account and can no longer access it see the following link for resetting your root account:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

After this it should work fine as per your config.inc.php file

answered Dec 28, 2013 at 23:56

Chris

4,5931 gold badge35 silver badges38 bronze badges

Comments

Marian Nasry · Accepted Answer · 2017-10-04 15:54:31Z

0

go to control panel > administrative tool> service >

then you will find a list of items , navigate to MYSQL

right click on its properties , in general tab start type make it automatic

then apply / save

and finally restart all services in wamp

edited Oct 4, 2017 at 15:54

Marian Nasry

8159 silver badges22 bronze badges

answered Dec 3, 2013 at 14:15

man on edge

11

Comments

cursorrux · Accepted Answer · 2024-04-25 10:30:51Z

0

Follow below steps:

Open phpmyadmin
Select user account tab
Select "Edit Privileges" form root-localhost user account
Select change password and assign new password
Restart phpmyadmin.

If problem still exist then open C Drive > ( Your Local Server Folder, WAMP/MAMP/XAMPP ) > APPS > PHPMYADMIN > config.inc.php in editor and change line

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

to

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

edited Apr 25, 2024 at 10:30

cursorrux

1,4645 gold badges11 silver badges20 bronze badges

answered Apr 23, 2024 at 9:22

user24600338

1

Comments

debika sadhukhan · Accepted Answer · 2015-04-08 22:21:19Z

-2

On the MySQL error page, where two pink coloured error panels are appeared, you can find a small button at right side there. click on it.

answered Apr 8, 2015 at 22:21

debika sadhukhan

571 silver badge2 bronze badges

2 Comments

Stuart Siegler Over a year ago

How does this answer the question? Perhaps some detail and a screen shot would help...

Eric Hepperle - CodeSlayer2010 Over a year ago

Downvoted because @debika never followed up to clarify and the answer as it stands makes no sense

Collectives™ on Stack Overflow

Wamp phpMyAdmin error #1045 - Access denied for user 'root'@'localhost'

1045 - Access denied for user 'root'@'localhost' (using password: YES)

8 Answers 8

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1045 - Access denied for user 'root'@'localhost' (using password: YES)

8 Answers 8

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related