We Successfully instal WAMP server in localhost for programing, but after installing WAMP server we tryping to
access the phpMyAdmin you may encounter the error:
#1045 Access Denied for user 'root'@'localhost' (using password: YES).
This may happen if you provided a wrong password or if your root@localhost database user was not granted the necessary rights to access the database.
or
#1045 Access Denied for user 'root'@'localhost' (using password: NO).
In this tutorials; shows how to solve this problem easily.
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'] = ''; - 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.