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:
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
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
- Go to http://localhost/phpMyAdmin and test your phpMyAdmin access.
Congratulations! You are now able to access your databases.
Source: https://www.ostraining.com/blog/coding/error-1045-phpmyadmin/
Category: How To
Thanks this was so helpfull