Start a FREE 7 day trial! Get training videos and books, plus expert support:  

Coding Tutorials and Blog Posts

How to Solve Error #1045 in phpMyAdmin

After installing a local server and trying to access phpMyAdmin, you could possibly encounter the error: #1045 Access Denied for user 'root'@'localhost' (using password: YES).

If root@localhost wasn't granted the necessary rights to access the database or you provided the wrong password, you will then encounter this error.

Following this tutorial will help guide you on bypassing this error, for any local host server using phpMyAdmin.

If you get an Error #1045 in phpMyAdmin it will look like the image below:


Step 1: Open your MySQL console.


Step 2: Enter the Provided Command Lines


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

  • Type in: use mysql;
  • Press Enter.
  • Set your MySQL Password: UPDATE mysql.user

SET Password=PASSWORD("EnterYourPasswordHere")
WHERE User="root";

  • Replace "EnterYourPasswordHere" with your new chosen password.
  • Press Enter.
  • Flush the privileges: FLUSH PRIVILEGES;
  • Exit by typing: Exit
  • Press Enter.

Step 3: Open and edit your file located in your local server files

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

Step 4: Access phpMyAdmin

  • You can access phpMyAdmin by going to https://localhost/phpMyAdmin/.
  • Congratulations! You are now able to access your databases. 


Start a FREE 7 day trial! Get training videos and books, plus expert support:  


All of our tutorials are published under the Creative Commons Attribution-NonCommercial license. This means:
  • You can re-use these tutorials.
  • You can modify these tutorials.
  • You must link back to our original tutorial.
  • You can't use these tutorials commercially.
Click here to read the full license.