How to Solve Error #1045 in phpMyAdmin

How to Solve Error #1045 in phpMyAdmin
After installing a local WAMP server and trying to access your phpMyAdmin, you may encounter the error:

#1045 Access Denied for user 'root'@'localhost' (using password: YES).

This may happen if your root@localhost database user was not granted the necessary rights to access the database. Or if you provided a wrong password.

In this tutorial, you will learn how to solve this error for the WAMP local server using phpMyAdmin.

If you get the #1045 Access Denied... in phpMyAdmin it will look like the image below:

tutuploadsphpMyAdmin-Access-Denied.png

Let’s learn how to get rid of it.

Step #1. Open Your MySQL Console

tutuploadsmedia_1338949643300.png

  • Left click your WAMP icon located at the bottom right of your desktop.
  • Click on MySQL Console.

Step #2. Enter the Provided Commands

tutuploadsmedia_1338949812597.png

If you have a password, you can ignore this part.

  • Type in:
    use MySQL;
  • Press Enter.
  • Set your MySQL password with the following command, replacing “EnterYourPasswordHere” with your new chosen password:
    UPDATE mysql.user SET Password=PASSWORD("EnterYourPasswordHere") WHERE User="root";
  • Press Enter.
  • Flush the privileges by typing:
    FLUSH PRIVILEGES;
  • Exit by typing:
    Exit
  • Press Enter.

Step #3. Edit Your config.inc.php File

tutuploadsmedia_1338949961143.png

Using a text editor, such as Notepad++, open your config.inc.php file.

  • Go to My Computer > C Drive > (Your Local Server Folder, WAMP/MAMP/XAMPP) > APPS > PHPMYADMIN > config.inc.php
  • Find the following line of code:
    $cfg['Servers'][$i]['password'] = ''; // MySQL password
  • Change the 'password' to the newly chosen password you created in Step #2.
  • Click Save.

Step #4. Access Your phpMyAdmin

tutuploadsphpmyadmin7.png

  • Go to http://localhost/phpMyAdmin and test your phpMyAdmin access.

Congratulations! You are now able to access your databases.

Additional Reading

What’s Next

Most major website platforms use MySQL as their default database. phpMyAdmin is a free software, written in PHP, which makes it easy to manage your MySQL databases.

Subscribe to our “How to Use phpMyAdmin to Manage MySQL” video class and learn how to install and use phpMyAdmin. This class will be a huge help to you if you use any PHP-based software.

Author

0 0 votes
Blog Rating
Subscribe
Notify of
142 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
pankaj

C:\xampp\phpMyAdmin

waseem

Here is the smart way to fix this error 🙂

go to the wamp [w] icon on right side of you desktop near the time.left click go to [mysql] left click [services] select [restart] and smile 🙂

if not restart your pc open browser and refresh the page 🙂

preety

thanxxx it works..

frustrated

I tried this..both restarting the mysql services and restarting the PC. Neither worked with Firefox.

Erich Marti

it will not work that way, I spent half a day no one around here knows the simple answer to a simple question…you probably installed the MYSQL on your pc long time ago and had set a password that you forgot, neither of changing code works, all you need to do either remebmber the old password or unistal and install the MYSQL

buha

how about this one:

#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

Raviteja Panchagnula

One of the possible reasons for this,

make sure that no other MySql is running other than the one in wamp. Check for the mysql running in task manager processes and kill it, before running the wamp. Later restart the wamp and the browser.(Be aware by killing the process the MySql(not in wamp) installed will not work, to make this work again goto mysql installed folder in bin you find mysqld application file run it, then your old mysql(not in wamp) will run again).

miyuru gomes

solved my problem thanks

Ikben

Nice one thanks alot it really helped me

Ryota Bannai

thanks. My problem, MAMP is running without Apache.

divesh

I am having problem plz help me out

Ryota Bannai

what your problem like?

Anonymous

Thank you very much , solved my problem

alex-smirnov

Sure! Glad to hear our tutorial helped you. We just added some links to related tutorials and video lessons. Please check them out.

Cheers,
Alex

rohullah

thank you so much the easiest and best answer thanks alot

omar

it works, thanks

lampard

thank you so much

Guest

Greatest tutorial very very helpful

Guest

I installed WAMP and ended up changing the port to 8080. because another app was using port 80. That worked and I got Apache working fine. When I go to phpMyAdmin I get the:

#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.

I never logged into phpMyAdmin or set up a password so it should work fine… I try to use the MySql Console and when I try the suggested password it just closes, when I try no password, it just closes. I am the admin. Do you think it has to do with the port change? any suggestions?

Guest

This information was really useful, it helped us solve mysql related issue.

Thanks,

Prasadi

thank you so so so much!

Deelux

You are AWESOME…! This worked like a charm! Thanks so much for taking the time to make this guide!

Bill T

Thank you for this well stated, very straight forward solution to the 1045 error problem. After trying many other proposed solutions, to no avail, this is the one that worked on the first try.

mikail

I was searching for this answer whole my live,thanks

Pratik Goyal

You’re truly a superstar… i liked the way you explained… easy steps…saved my time..hats off!

Craiger

Thank you so much! Worked perfectly for me.

chemic

pretty nice solution..#thx 😀

vinod chauhan

there is still an error in using it .. i have dne all thiss,pls help me out

ravi

Thank you so much for sharing this useful information. this is really helpful to me and Now every thing is working fine.

Thanks again.

Santos

Thank you very much!! Perfect!!!

myavila

Thank you very much for this useful information. It really helped.

Ruthine

Hi, this worked. I should add that it didn’t work initially, I had to stop all services (on Wamp) and do a full restart of my computer before it finally worked. Might be because I have Window 7 on a partitioned section of my Mac system?? Thank you very much however. Saved my sanity.

FAISAL

GREAT SIR,,,ITS USEFULLL

D

Absolutely amazing! Thanks so much!

Nadeesha

Thank You very much for this useful information…

Sheela

Hello sir,

I could not set password in command prompt. when i run mysql.exe file there also i got same error when i run on browser. that is access denied for localhost user.

Please help me how to solve this error

Thanking you in advance

Zac Ang

It might because u have forget your old password that u have set long long time ago. U can go to previous website projects php files to check the database username and password that open connection of database for your php files.

arshad nawaz

thanks,great work

davidah

The fix worked great, but if you’re running WAMP with windows 7 you might need to clear your browser history and run WAMP as administrator.

gaps

You saved me my man. Thank you so much

frederick

Thanks man. You are indeed good at what you do. thank you once again. you are the man.

Leslie Luke

Need HELP! PLEASE: After installing a local server using WAMP and trying to access phpMyAdmin, I encountered error: #1045 Access Denied for user ‘root’@’localhost’ (using password: YES). I followed Tessa Mero’s instructions described in “How to Solve Error #1045 in phpMyAdmin – June 06, 2012 | Written by Tessa Mero” After typing UPDATE mysql.user SET Password-PASSWORD(“root”) WHERE User=”root”; mysql responed “Query OK, 3 rows affected. Rows matched:3 Changed:3 Warnings:0”. Then I typed FLUSH PRIVILEGES:, mysql responded “->”. What should I type from here? I am a beginner, please tell me what to do:

mysql> FLUSH PRIVILEGES:

->

THANKS in advance

Emmezali

Mysql will always do this, it’s basically asking you to keep going with the statement because you haven’t ended the statement with “;”. 

try this: 
FLUSH PRIVILEGES;
Instead of: 
FLUSH PRIVILEGES:

Leslie Luke

Just sent a message to ask for help regarding what to do after mysql> FLUSH PRIVILEGE:

->

I fixed the problem by fixing my typing error (“;” instead of “:”). That “:” created a syntax error and mysql returned “->” expecting a new line. Anyway, my problem is fixed and I am inside phpmyadmin now. Thanks!

mohid

work fine in my wamp sever. but log in page not show when start first. please any one help me? thanks lot.

Antonio Lacruz

Thank you a thousand times!

Ugo

Done! Thank you very much. You solve this problem

Vaishnavi

Awesome… Thank u very much. It worked for me and saved a big trouble.

Ketan Sawant

It is really very valuable

Done!

Thanks

Vikas Sharma

Error is same but it’s showing (using password: no)

and this solution is not working.

Is there any other solution?

jasonb

hi there

deleted a database from phpadmin then got the error msg

the troubble is i dont have a password to put into msql.exe

as anything i put there says acess denied

SanVar

Had the same error…
I did not change anything in configuration file.
Just changed
My Chrome->Prop->Target value
From : “C:\Program Files\Google\Chrome\Application\chrome.exe” –disable-web-security
To : “C:\Program Files\Google\Chrome\Application\chrome.exe

Karthick manoharan

no still i done all the changes its not happening ..still acces denied only im getting

w.izzy

you rule indeed

abc

The additional features for working with linked tables have been deactivated. how to solve this problem

Thanks

Thanks so much! For some reason it didn’t have a root user at all, only controluser (with no privileges). This, however, created the root user (I think it was the FLUSH PRIVILEGES-command that did it)

coolman88

For anyone who still gets the same error message screen after applying above steps, trying clearing your web browser cache.

Anas Ashraf

Hello every one i lost my config.inc.php file please tell me now what can i do ? how can i recover or install same file in phpmyadmin ??? Please do help me..

tired_as_a_runaway_slave

Many thanks great help Tessa …

hems

Thank you! This works

Brandon

I followed all of your steps but get this when entering https://localhost/phpMyAdmin/ into my browser: ‘This webpage is not available’

Soukaina Ouhame

thanks it works 🙂

john

#1273 how to solve it

wow2tharu

I had the same problem and none of this solutions works with me. Finally I realized that I was separately installed mySQL server 5.1 in to my PC. Uninstall it and then works fine along with the wamp default privileges. Thanks for the fix mentioned here. That was helpful too.. 🙂

Varun

mind blowing ! 😀

142
0
Would love your thoughts, please comment.x
()
x