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

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.

• Using WAMP, left click your WAMP icon located at the bottom right of your desktop and click on MySQL Console.
• Guide to accessing MySQL using XAMPP
• Guide to accessing MySQL using MAMP.

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 config.inc.php file located in your local server files

• 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 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 http://localhost/phpMyAdmin/.
• Congratulations! You are now able to access your databases.