How To Fix MySQL ERROR 1045 (28000): Access Denied For User
Published by admin on December 26, 2015
After 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;
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 config.inc.php file situated in files of local server and edit it.
Make use of a text editor like Notepa++ to open config.inc.php file.
Switch to My Computer> C Drive> (Folder Of Local Server MAMP/XAMPP/WAMP)> APPS> PHPMYADMIN> Config.inc.php
- 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 SQL 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.
STEPS TO SOLVE THE ERROR:
Step 1: Don’t further use MS SQL server, since process of repair is completed on corrupt database copy so tap ‘OK’ button and carry on.
Step 2: Hit ‘Select database’ button and decide on the path of corrupt MDF file. Then search your corrupt database file by using ‘Look in’ and ‘File Type’ button. Hit the ‘Scan file’ button to start repairing process.
Step 3: The absolute listing of recoverable objects of a database is in the tree view on left side of the window. You can see the preview by tapping any object.
Step 4: Start Repair to commence the procedure and save repaired file in desired spot then hit browse button and define path, else repaired file will be saved in ‘Default SQL Location’. Press ‘Ok’ button.
Conclusion- Hope with the given solution you can fix the error msg 605 in the SQL Server. It can be repaired easily with the SQL Repair tool it is the best solution to fix any error in the SQL server database files. It is easy to use and recovers the data easily without any hassle.
157 Total Views 3 Views Today