How To Fix MySQL ERROR 1045 (28000): Access Denied For User

By | February 15, 2016

MySQL ERROR 1045 (28000): Access Denied For UserAfter completing installation of server of a local host if you try to access the phpMyAdmin, you may come across an error code #1045 Access Denied for user ‘root’@’localhost’ (using password: Yes).

This error primarily comes into action when the local host is not assigned with complete accessing authority or may be the password that is facilitated is incorrect. If these things will be happening then you may encounter this error.

But in this article you will be guided properly to find a way around for avaoiding and solving this error, for any local host server with the help of phpMyAdmin.

Image will appear as shown below;

MySQL ERROR 1045 (28000): Access Denied For User

Manual Repair for Error 1045

Step 1: Open MySQL console

With the help of WAMP, do left click on your WAMP icon positioned at the bottom right area of the screen of your desktop and go to MySQL console.

But this part can be ignored if you already have the correct password;

  • Type: use mysql
  • Hit enter
  • Set password for MySQL: Update mysql.user

Step 2: Set Password= PASSWORD (Enter Your Password Here)

Where User=”root”

  • Replace your password with your chosen password
  • Hit Enter
  • Wash out the Priviliges
  • Exit
  • Again hit Enter

Step 3: Open file situated in files of local server and edit it.

Make use of a text editor like Notepa++ to open file.

Switch to My Computer> C Drive> (Folder Of Local Server MAMP/XAMPP/WAMP)> APPS> PHPMYADMIN>

  • Locate this line of code: $cfg [‘Servers’][$i][‘password’] = “; //MySQL password
  • Make alteration with the freshly created password from step 2.
  • Click save

Step 4: Access phpMyAdmin

You can make access of phpMyAdmin by switching to the http://localhost/phpMyAdmin/

After finishing all the steps above hopefully you will be able to access the database with no issue.

Fully Automated Solution To Fix Error 1045:

For if the above stated solution does not help you to get rid of the error code 1045 then best alternative available is MYSQL Repair Tool is the most reliable tool to fix error in SQL Server Error 1045 user access denied. It also recovers corrupted and damaged database files without backup. It also recovers stored procedures, views, indexes, tables, unique/primary keys etc. that are saved in your damaged SQL database.

downloadnow buynow learn-more-button-orange

STEPS TO SOLVE  ERROR 1045 (28000):

Step 1: Start with Stellar Phoenix Database Repair for MySQL . Software and you can see the main interface as shown below.

Step 2: Click on ‘Select’ button & then select ‘Repair corrupt database which is stored at default location of MySQL’ option to select your database from default location and then click.

Step 3: The left pane shows the preview of database and its component in a tree like structure after completing scanning process.

Step 4: After previewing your database, to start repair process click ‘Repair’ button in file menu on the main user interface. Stellar Phoenix Database Repair for MySQL dialog box appears. Click Yes.

Step 5: After successful completion of the process, a message box is displayed as ‘repair process finished successfully’. Click ‘OK’ to close the message box.

Step 6: If you want to select the database manually then select ‘Manual selection of database to repair’ option & then click browse. Browse the folder dialog box opens. Select the folder that contains database and click ‘OK’.