Home / mySQL / How to Solve #1045 Error in phpMyAdmin

How to Solve #1045 Error in phpMyAdmin

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.

Loading Facebook Comments ...
Social Media Auto Publish Powered By : XYZScripts.com