How to solve the problem of error Nr.1045 during mysql installation, mysqlnr.1045

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.