phpMyAdmin access denied for user 'root'@'localhost' (using password: NO)

Question

I am unable to connect to my MySQL in xampp I have this error:

MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO) mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) 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.

CONFIG.INC.PHP file

<?php
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';

/*
 * End of servers configuration
 */

?>

guzuer · Accepted Answer · 2017-07-14 21:09:06Z

42

found a solution, in my config file I just changed

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

to

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

answered Jul 14, 2017 at 21:09

guzuer

7311 gold badge6 silver badges8 bronze badges

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

1 Comment

krishna Over a year ago

this worked for me. Why should we choose HTTP but not config?

haihui · Accepted Answer · 2017-12-19 11:41:36Z

18

/* Authentication type and info */
$cfg['Servers'][$i]['password'] = '';<----your password

or

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'pma';

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

to

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'your user';

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

edited Dec 19, 2017 at 11:41

haihui

1,1031 gold badge19 silver badges26 bronze badges

answered Dec 19, 2017 at 10:44

user9117601

1891 silver badge2 bronze badges

Comments

Dharman · Accepted Answer · 2021-11-04 08:58:36Z

12

You may have set different passwords for user 'root' or have been changed your password. I had the same error as:

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)

and I found that my root password for PHPMyAdmin is not the same on both 'mysql' and 'phpmyadmin' databases, so I updated my password for 'phpmyadmin' database same as 'mysql' database as follow:

sudo gedit /etc/phpmyadmin/config-db.php

and update the fields

$dbuser='root';

$dbpass='myNewPassword'; <-- update your new password here

edited Nov 4, 2021 at 8:58

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered May 28, 2019 at 16:23

Farhikhteh

1211 silver badge5 bronze badges

2 Comments

melic Over a year ago

The answer for my problem is to fix privilege granted user information instead of 'root' as @Farhikhteh told

Julian Silvestri Over a year ago

This solved my issue! for some strange reason the username and password set by default was not overwritten on installation, going to the config-db.php file led me to my issue! You saved me !

Dharman · Accepted Answer · 2021-11-04 08:59:01Z

9

Change the value of

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

in your ~/xampp/phpMyAdmin/config.inc.php

Here my username is groot and password is groot.

edited Nov 4, 2021 at 8:59

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Oct 19, 2018 at 9:26

Jendorski Labs

5352 gold badges11 silver badges24 bronze badges

Comments

CodeView · Accepted Answer · 2021-03-05 20:13:19Z

7

It happened with me before: go to path for windows

C:\xampp\phpMyAdmin\

go to path for linux:

/etc/phpmyadmin/

found file name is :
config.inc.php open file
change this:

['password'] = ''

to:

['password'] = 'root'

this default
It might be any password if you changed it from the control panel

answered Mar 5, 2021 at 20:13

CodeView

5003 silver badges16 bronze badges

Comments

Paul Roub · Accepted Answer · 2018-05-09 20:43:06Z

4

Edit the file xampp/mysql/bin/my.ini

Add

skip-grant-tables

under [mysqld]

edited May 9, 2018 at 20:43

Paul Roub

36.5k27 gold badges88 silver badges95 bronze badges

answered May 9, 2018 at 20:33

alireza Hosseinzade

491 bronze badge

3 Comments

szatti1489 Over a year ago

Its very dangerous: "When MySQL is started with this parameter, it completely avoids checking its grant tables upon connection and upon query. This means anyone can log in from anywhere, and do anything on the database." code.openark.org/blog/mysql/dangers-of-skip-grant-tables

Daniel Wondyifraw Over a year ago

later you grant that using mysql query and then turn of skip-grants a quick workaround

Tomas Gonzalez Over a year ago

Downvote: it's a bad idea to do that. You should reset the root password (search stackoverflow, there's tons of posts on that) or create an appropriate user, grant te appropriate permissions and configure you config.inc.php

Nakshtra Pradhan · Accepted Answer · 2018-10-18 22:55:38Z

4

Follow these steps- 1.go to config.inc.php file and find - $cfg['Servers'][$i]['auth_type']

2.change the value of $cfg['Servers'][$i]['auth_type'] to 'cookie' or 'http'.

3.find $cfg['Servers'][$i]['AllowNoPassword'] and change it's value to true.

Now whenever you want to login, enter root as your username,skip the password and go ahead pressing the submit button..

Note- if you choose authentication type as cookie then whenever you will close the browser and reopen it ,again you have to login.

answered Oct 18, 2018 at 22:55

Nakshtra Pradhan

1113 bronze badges

3 Comments

Bhavin Thummar Over a year ago

I have set this but at time of login I am fetching this error "Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin."

Nakshtra Pradhan Over a year ago

@BhavinThummar is it working when you are using incognito mode??

Robert Over a year ago

Weird that this one is not the accepted answer, it is the most simpler and logical. With this setup (though I prefer AllowNoPassword to false) you will get prompted by the native phpMyAdmin login form. With this method, it becomes just matter of changing the auth_type to cookie . Obviously, from command prompt, you will use mysqladmin -u root password to set your own new secure password

Jean-Élisée Yao · Accepted Answer · 2019-03-08 18:52:44Z

4

You need to modify the config-db.php and set your password to the password you gave to the user root, or else if he has no password leave as this ''.

edited Mar 8, 2019 at 18:52

answered Oct 3, 2018 at 12:49

Jean-Élisée Yao

1842 silver badges16 bronze badges

1 Comment

Ayush Vatsyayan Over a year ago

Please use the code formatting for e.g. adding config-db.php in code formatting as config-db.php. Do the same thing with value such as 'root' and ''. Also it will be very helpful if you could copy paste the part of file, along with location. Make sure, while pasting, you remove your private information such as credentials.

Web for Beginner · Accepted Answer · 2019-05-07 12:36:34Z

3

$cfg['Servers'][$i]['auth_type'] = 'HTTP';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '1234';

This solves my problem too. It just logs in automatically.

answered May 7, 2019 at 12:36

Web for Beginner

236 bronze badges

1 Comment

Bhavin Thummar Over a year ago

HTTP login opens the popup but the login is not working.

Rajanikanta Pradhan · Accepted Answer · 2019-03-01 07:47:41Z

2

This is the Different Solution, Check if your Services are running correctly, if WAMP icon showing orange color, and 2 out of 3 services are running it's showing, then this solution will work . Root cause:

If in your system mysql was there, later you installed WAMP then again one MYSQL will install as WAMP package, default port for MYSQL is 3306 , So in both mysql the port will be 3306, which is a port conflict, So just change the port it will work fine. Steps to change the Port.

Right click the WAMP icon.
Chose Tool
Change the port in Port used by MySql Section

answered Mar 1, 2019 at 7:47

Rajanikanta Pradhan

6521 gold badge9 silver badges13 bronze badges

Comments

Dharman · Accepted Answer · 2021-11-04 08:59:44Z

If you are using macbookpro and getting this error on XAMPP then you also need to change the permission of file config.inc.php. Sorry I was first time user of xampp on macbook pro and was not knowing its directory structure and other details so adding this answer for first time users.

From XAMPP interface click to 'go to Terminal' and from there use below commands

       root@debian: cd /opt/lampp/phpmyadmin

inside this directory you will find the config.inc.php Now use chmod 777 config.inc.php, please note that you need to make it writable you can use equivalent code instead of 777. I used 777 for me.

       root@debian: chmod 777 config.inc.php

Now open the file from explorer or network drive to any editor make the below changes -

search for 'Authentication type' in file, you will find it in comment

below this comment you will find

 $cfg['Servers'][$i]['auth_type'] = 'config';
 $cfg['Servers'][$i]['user'] = 'root';
 $cfg['Servers'][$i]['password'] = 'here_you_need_to_type_your_root_password';

now it still didnot work for me after this step, it was complaining about config file permission so I had to revert back the permission back to -rw-r--r-
```
   root@debian: chmod 644 config.inc.php
```

and then it worked fine.

Priya Dutta · Accepted Answer · 2019-01-06 18:21:37Z

1

In case none of the aforementioned solutions works for you, then simply do the under changes. Change this

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

to

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

and

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

to

$cfg['Servers'][$I]['auth_type'] ='cookies';

It works in my situation, possibly works on your situation also.

answered Jan 6, 2019 at 18:21

Priya Dutta

111 bronze badge

Comments

Shamal Sabah · Accepted Answer · 2019-05-16 11:14:38Z

1

Go got XAMPP->mysql->bin->my.ini

open the file with an editor and add 'skip-grant-tables' after mysql.

answered May 16, 2019 at 11:14

Shamal Sabah

2392 silver badges7 bronze badges

Comments

João Victor · Accepted Answer · 2018-10-12 14:29:21Z

0

Just do what the message is asking for, create the user pma@localhost in the phpMyAdmin panel with no password

answered Oct 12, 2018 at 14:29

João Victor

1011 bronze badge

Comments

A. Kiyoshi · Accepted Answer · 2020-10-24 03:07:06Z

0

Check /etc/phpmyadmin/config-db.php file

Go to terminal
run vi /etc/phpmyadmin/config-db.php
check the information
Hit Ctrl + X
Try login to phpmyadmin again through the web using the information from the config file.

answered Oct 24, 2020 at 3:07

A. Kiyoshi

611 silver badge13 bronze badges

Comments

kishan maru · Accepted Answer · 2020-11-27 10:05:28Z

0

Please run and re reconfigure your phpmyadmin

sudo dpkg-reconfigure phpmyadmin

answered Nov 27, 2020 at 10:05

kishan maru

411 gold badge3 silver badges8 bronze badges

Comments

Dharman · Accepted Answer · 2021-11-04 08:59:29Z

0

When you install the WAMPP in your machine by default the password of PhpMyAdmin is blank. so put root in user Section and left blank of password field. hope it works.

edited Nov 4, 2021 at 8:59

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Jun 12, 2020 at 6:49

Arun Prajapati

2792 silver badges6 bronze badges

Collectives™ on Stack Overflow

phpMyAdmin access denied for user 'root'@'localhost' (using password: NO)

17 Answers 17

1 Comment

Comments

2 Comments

Comments

Comments

3 Comments

3 Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

17 Answers 17

1 Comment

Comments

2 Comments

Comments

Comments

3 Comments

3 Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related