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.
Hello! Do you know if they make any plugins
to assist with SEO? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good success.
If you know of any please share. Kudos! You can read similar
blog here: Eco bij