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

Question

This might seem redundant but I was unable to find a correct solution.

I was unable to login to mysql using the mysql console.It is asking for a password and I have no clue what I actually entered.(Is there a way to get the password or change it?) This is how my config.inc look.

When I try to open phpmyadmin I get this error(#1045 - Access denied for user 'root'@'localhost' (using password: YES))

<?php

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
 $cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'prakash123';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';


/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';


?>

I have tried to uninstall( Plus Deleted all the related files) WAMP and reinstall.It didn't help either. While reinstalling WAMP server it is not asking for any username password stuff I don't know why. Any help is highly appreciated.

Have you tried to move away the database 'mysql' (which is where the credentials live) and see, if it is recreated on restart? — Eugen Rieck
– Eugen Rieck, Commented May 30, 2013 at 20:58
Look here: stackoverflow.com/questions/2703996/… I'd say that $cfg['Servers'][$i]['password'] = 'prakash123'; prakash123 is your password. — helenbn
– helenbn, Commented May 30, 2013 at 21:01
#2002 Cannot log in to the MySQL server this is the new error I get when moved Mysql @Eugen Rieck — Prakash
– Prakash, Commented May 30, 2013 at 22:23
@helenbn I know prakash123 is my password but I was not able to open PHPMyadmin — Prakash
– Prakash, Commented May 30, 2013 at 22:24

Ritesh · Accepted Answer · 2022-06-15 13:09:55Z

39

I first changed the root password running mysql at a prompt with

mysql -u root -p

Update password:

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

Edited line in the file config.inc.php with the new root password:

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

Stop and re-start mysql service (in Windows: mysql_stop.bat/mysql_start.bat)

and got phpMyAdmin to work!

EDIT 2017: for MySQL≥5.7 use authentication_string in place of Password (see this answer):

`UPDATE mysql.user SET authentication_string=PASSWORD('MyNewPass') WHERE User='root';

`

edited Jun 15, 2022 at 13:09

Ritesh

4,9987 gold badges34 silver badges43 bronze badges

answered Oct 15, 2013 at 11:16

user2314737

29.7k20 gold badges109 silver badges126 bronze badges

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

3 Comments

yashhy Over a year ago

after doing this kill mysql process and start it again!

Stan Derksen Over a year ago

What should I do if mysql -u root -p requires a password, and anything you try results in the #1045 error?

developer Over a year ago

@StanDerksen The password in my case of mysql -u root -p was the root password for the server.

radbyx · Accepted Answer · 2019-04-25 10:48:10Z

10

The problem was I have 2 instances of Mysql installed and I didn't know the password for both instances.Just check if port 80 is used by any of the programs. This is what I did

1.Quit Skype because it was using port 80.(Please check if port 80 is used by any other program).

2.Search for Mysql services in task manager and stop it.

3.Now delete all the related mysql files.Make sure you delete all the files.

4.Reinstall

edited Apr 25, 2019 at 10:48

radbyx

9,72022 gold badges93 silver badges133 bronze badges

answered Aug 8, 2013 at 20:19

Prakash

8,0565 gold badges51 silver badges45 bronze badges

Comments

yunhasnawa · Accepted Answer · 2013-10-27 20:18:05Z

5

Well, there are many solutions already given above. If there are none of them works, maybe you should just try to reset your password again to 'root' as described here, and then reopen http://localhost/phpMyAdmin/ in other browser. At least this solution works for me.

answered Oct 27, 2013 at 20:18

yunhasnawa

9651 gold badge15 silver badges30 bronze badges

Comments

ramin rostami · Accepted Answer · 2014-12-29 09:08:29Z

2

mysql -u root -p
UPDATE mysql.user SET Password=PASSWORD('mypass') WHERE User='root';
Flush the privileges: FLUSH PRIVILEGES;
Exit by typing: Exit
Edited line in the file config.inc.php with the new root password: $cfg['Servers'][$i]['password'] = 'mypass'
be succss

answered Dec 29, 2014 at 9:08

ramin rostami

3153 silver badges5 bronze badges

1 Comment

zahid Over a year ago

UPDATE mysql.user SET Password=PASSWORD('yourpassword') WHERE User='root'; if some one using the mysql5.7. the above update does not work in this version...

halkujabra · Accepted Answer · 2015-01-21 17:42:06Z

2

Go to 'config.inc.php'. Write your password over here - $cfg['Servers'][$i]['password'] =''

answered Jan 21, 2015 at 17:42

halkujabra

2,9524 gold badges28 silver badges38 bronze badges

Comments

Saturminus Combie · Accepted Answer · 2015-01-26 03:18:04Z

2

This process is quite simple in correcting the the error. What is happening is a failure to connect to phpMyAdmin. In order to fix the problem you simply need to provide the correct password to the system phpMyAdmin configuration file located in apps\phpMyadmin\config.ini.php 1. the root should already be set as user 2. Insert the password between ' ' and that it.

If you still have problems then this means that the user name and /or the password need to be updated or inserted into the DB. to do this use the command line tool and do an update.

UPDATE mysql.user SET Password=PASSWORD('Johnny59 or whatever you want to use') WHERE User='root';

edited Jan 26, 2015 at 3:18

answered Jan 26, 2015 at 2:52

Saturminus Combie

213 bronze badges

Comments

Hussain Rahimi · Accepted Answer · 2015-06-20 09:08:13Z

2

Go to config.inc.php, find $cfg['Servers'][$i]['password'] and remove any password provided, i.e change $cfg['Servers'][$i]['password'] = 'password'; with $cfg['Servers'][$i]['password'] = '';

Now you can launch phpMyAdmin

Selecting Users menu from phpMyAdmin, select the root user and click Edit previlidges. Now scroll down to Change Password area, switch between No Password and Password to provide your new password. that's it.

edited Jun 20, 2015 at 9:08

answered Jun 20, 2015 at 8:52

Hussain Rahimi

8518 silver badges19 bronze badges

Comments

Ngeno · Accepted Answer · 2015-06-22 09:15:19Z

2

I had the same error today. I had installed Djangostack and when I checked my task manager there were two instances of mysqld running. I checked one was for wamp server and the other was for django stack. I ended the one for django stack, restarted all services in wamp server and I was able to access phpmyadmin

answered Jun 22, 2015 at 9:15

Ngeno

213 bronze badges

Comments

fantja · Accepted Answer · 2016-08-02 11:39:45Z

2

after installation i started wamp and i was asked for user and pass which were already set on default (user:admin pass: dots), and that was wrong with a message from your topic. Than, i just entered:

Username: root 
Password: (leave it empty)

and it worked for me!!

answered Aug 2, 2016 at 11:39

fantja

915 bronze badges

Comments

ata · Accepted Answer · 2018-06-16 13:50:31Z

2

Go to C:\xampp\phpMyAdmin
Edit the config.inc.php file
Replace $cfg['Servers'][$i]['auth_type'] = 'config'; by $cfg['Servers'][$i]['auth_type'] = 'cookie';

For now on the PHPMyAdmin will ask you for your password, no more error.

edited Jun 16, 2018 at 13:50

ata

3,6935 gold badges22 silver badges32 bronze badges

answered Feb 20, 2018 at 20:35

Jean Duclos

212 bronze badges

Comments

Timi Jegede · Accepted Answer · 2018-07-01 23:43:10Z

2

This worked for me. In your config file

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

In your mysql shell, login as root

mysql -u root

change your password or update if you've forgotten the old one

UPDATE mysql.user SET Password=PASSWORD('yourpassword') WHERE User='root';

stop and restart your mysql server from the xampp control panel. phpmyadmin can login to see your databases

answered Jul 1, 2018 at 23:43

Timi Jegede

291 bronze badge

Comments

Martin54 · Accepted Answer · 2024-05-01 19:36:44Z

2

mysql.exe->Run as administrator or go to the following path C:\wamp\bin\mysql\mysql5.5.24\bin

and then right click on mysql.exe go to properties and then select tab as Compatibility and see the bottom of dialog box in privilege level and just check the Run this program as an administrator and then click apply ok.

Finished now you open success phpMyadmin.

edited May 1, 2024 at 19:36

Martin54

1,9002 gold badges18 silver badges39 bronze badges

answered Aug 5, 2013 at 15:40

arokiya

212 bronze badges

Comments

рüффп · Accepted Answer · 2013-10-24 09:36:31Z

1

Try the following code:

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

if you see Password column field as 'No' for the 'root' user in Users Overview page of phpMyAdmin.

edited Oct 24, 2013 at 9:36

рüффп

5,52434 gold badges74 silver badges125 bronze badges

answered Oct 24, 2013 at 9:17

Peris

293 bronze badges

Comments

bcag2 · Accepted Answer · 2017-01-26 10:45:58Z

1

with MariaDb, above solutions doesn't works.

Use (exemple below with ubuntu 16.04 and mariadb-server Distrib 10.0.28):

    sudo mysql_secure_installation
    …
    Change the root password? [Y/n] 
    New password:

answered Jan 26, 2017 at 10:45

bcag2

2,4992 gold badges20 silver badges38 bronze badges

Comments

盧力韜 · Accepted Answer · 2017-08-14 01:28:10Z

1

I have encountered similar mistakes, and later found that my password is wrong.

answered Aug 14, 2017 at 1:28

盧力韜

731 silver badge4 bronze badges

Comments

Sebastian Brosch · Accepted Answer · 2019-03-14 12:35:13Z

1

For UNIX, try this. It worked for me:

connect MySQL use Navicat Premium with inital root/"password"
UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N' WHERE User = 'root' AND Host = 'localhost'; FLUSH PRIVILEGES;
restart MySQL

edited Mar 14, 2019 at 12:35

Sebastian Brosch

43.8k15 gold badges78 silver badges89 bronze badges

answered Feb 17, 2017 at 2:37

Aaron

191 bronze badge

1 Comment

Stephen Rauch Over a year ago

When giving an answer it is preferable to give some explanation as to WHY your answer is the one.

Mahedi Hasan · Accepted Answer · 2017-08-23 15:41:19Z

0

First you have to go config.inc.php file then change the following instruction

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

or

edited Aug 23, 2017 at 15:41

answered Aug 23, 2017 at 15:30

Mahedi Hasan

97613 silver badges19 bronze badges

1 Comment

Kishan Solanki Over a year ago

what is the path for that file?

Kaizoku Gambare · Accepted Answer · 2017-10-10 11:38:31Z

0

If you arrived here because you can't log into your phpMyAdmin, then try the root password from your Mysql instead of the password you put during phpMyAdmin installation.

answered Oct 10, 2017 at 11:38

Kaizoku Gambare

3,4533 gold badges33 silver badges42 bronze badges

Comments

STiLeTT · Accepted Answer · 2017-12-01 11:10:40Z

0

Just now I have this situation and I have tried this way which is very easy.

First stop your mysql service using this command:

service mysql stop

and then just again start your mysql service using this command

service mysql start

I hope it may help others... :)

edited Dec 1, 2017 at 11:10

STiLeTT

1,09211 silver badges23 bronze badges

answered Dec 1, 2017 at 10:51

Sachin Shah

4,5634 gold badges26 silver badges55 bronze badges

Comments

Guntar · Accepted Answer · 2020-01-09 23:52:47Z

0

After I updated my MySql, I was getting the same error message. It turned out that after installing a different version on MySql, inside the my.ini, the port was different. Previous MySql version had port 3306 but the new one have port 3308. Check your MySql my.ini, if it is different use the port from .ini in your connection.

answered Jan 9, 2020 at 23:52

Guntar

5231 gold badge11 silver badges25 bronze badges

Comments

saber tabatabaee yazdi · Accepted Answer · 2020-02-19 17:51:13Z

0

php artisan serve

this command get the env contents for the first time and if you update .env file need to restart it.

in my case my username and dbname is valid and php artisan migrate worked

but need to cntrl+c , to cancel php artisan serve , and run it again

php artisan serve

answered Feb 19, 2020 at 17:51

saber tabatabaee yazdi

4,9953 gold badges53 silver badges63 bronze badges

Comments

Deepam Gupta · Accepted Answer · 2021-04-06 06:34:59Z

0

Check the name of Environment Variable

Case with me:

I was using sqlalchemy in a python-flask project and got this issue.
IDE used: PyCharm
In my config.py file I had setup SQLALCHEMY_DATABASE_URI as:

SQLALCHEMY_DATABASE_URI = os.getenv("DATABASE_URI")

Mistake I did (it was a silly mistake 😅)

While setting evironment_variables in PyCharm, I did:

SQLALCHEMY_DATABASE_URI=<my_db_uri>

Solution

I changed the above to:

DATABASE_URI=<my_db_uri>

Namaste 🙏

answered Apr 6, 2021 at 6:34

Deepam Gupta

2,7522 gold badges33 silver badges37 bronze badges

Comments

Nirbhay Kumar · Accepted Answer · 2024-10-16 19:39:47Z

0

In MySQL 8.0 and later, the GRANT statement does not support setting a password using IDENTIFIED BY. Instead, you should create the user or update the password separately using CREATE USER or ALTER USER.

Here's how you can properly grant privileges and set the password for the root user:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'myPassword';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

edited Oct 16, 2024 at 19:39

answered Oct 16, 2024 at 19:39

Nirbhay Kumar

11 bronze badge

Comments

Nander Speerstra · Accepted Answer · 2017-12-20 08:02:50Z

-1

In the my.ini file in C:\xampp\mysql\bin, add the following line after the [mysqld] command under #Mysql Server:

skip-grant-tables

This should remove the error 1045.

edited Dec 20, 2017 at 8:02

Nander Speerstra

1,5366 gold badges26 silver badges30 bronze badges

answered Dec 20, 2017 at 7:23

Abhikarsh

1

1 Comment

sebix Over a year ago

Please add that this may only be a temporary solution until a proper password is set!

radbyx · Accepted Answer · 2019-02-26 07:24:18Z

-1

if multiple myslq running on same port no enter image description here

Right click on wamp and test port 3306 if its wampmysqld64 its correct else change port no and restart server

edited Feb 26, 2019 at 7:24

radbyx

9,72022 gold badges93 silver badges133 bronze badges

answered Jun 16, 2018 at 12:00

Sachins

411 gold badge1 silver badge7 bronze badges

Collectives™ on Stack Overflow

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

25 Answers 25

3 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Case with me:

Mistake I did (it was a silly mistake 😅)

Solution

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

25 Answers 25

3 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Case with me:

Mistake I did (it was a silly mistake 😅)

Solution

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related