How to solve the problem of error Nr.1045 during mysql installation, mysqlnr.1045
When MySQL is installed in windows, the following error occurs: Access denied for user 'root' @ localhost' (using password: No, this problem occurs because you have installed mysql on your machine or configured a new password for this installation, in the last step of the application, the configuration failed due to some reasons such as out of the card or failed to start the service. The final result is that the configuration failed and the password settings have been saved. In this way, after adjusting the service and other reasons, when re-configuring, we will find that an old password input box is added when setting the password. In fact, this is nothing. It is not difficult to enter the old password and reset the password when you know the password. The key is that even if the old password is correct, you still cannot complete the configuration, in the last step, I encountered another error during password authentication. The cause of the error was the password problem, prompting that the old password was incorrect.
Solution:
1. Management Tools --- stop the Mysql service in the service.
2. Control Panel --- uninstall Mysql and delete the C: \ Program Files \ MySQL directory.
3. This isKeyIn one step, the password cannot be modified only in the previous two steps, because MySQL still has files, that is, in C: \ Documents ents and Settings \ All Users \ Application Data (Application Data is a hidden folder) in the MySQL folder, this file is not cleared is the root cause of the old password reinstalled in MySQL. Delete the MySQL folder.
4. Check whether the my. ini file exists in the C: \ WINDOWS directory and delete it.
5. Delete HEKY_LOCAL_MACHINE, SOFTWARE, and MYSQL in the registry.
HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet001 \ Services \ Eventlog \ Application \ MySQL directory Deletion
HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet002 \ Services \ Eventlog \ Application \ MySQL directory Deletion
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ Application \ MySQL directory Deletion
After completing the preceding steps, you can reinstall MySQL and perform new configuration.
The above is the solution to the error during mysql installation. I hope it will be helpful for your learning, and I hope you can provide more support to the customer's house.