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 MySQL 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:
Let's learn how to get rid of it.
Step #1. Open Your MySQL Console
- Left click your WAMP icon located at the bottom right of your desktop.
- Click on MySQL Console.
Step #2. Enter the Provided Commands
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
- Go to My Computer > C Drive > WAMP > 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
- Go to https://localhost/phpMyAdmin and test your phpMyAdmin access.
Congratulations! You are now able to access your databases.
What's Next
Most major website platforms use MySQL as their default database. phpMyAdmin is 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.