Home  >  Article  >  Database  >  How to solve the mysql installation error 1045 problem

How to solve the mysql installation error 1045 problem

藏色散人
藏色散人Original
2021-12-28 10:44:158798browse

Mysql installation error1045 solution: 1. Stop the MySQL service; 2. Uninstall MySQL in the control panel; 3. Enter the system general data folder and delete the MySQL folder; 4. Reinstall MySQL.

How to solve the mysql installation error 1045 problem

The operating environment of this article: Windows 7 system, mysql version 5.5, Dell G3 computer.

How to solve the mysql installation error 1045 problem?

Error Error Nr.1045 occurs in the last step of installing MySQL Solution:

Connection Error
Error Nr.1045
Access denied for user 'root'@'localhost' (using password:NO)

1. Stop the MySQL service: This computer-->right-click Manage-->Services and Applications-->Services Find the service named "MySQL" and right-click to disable it

2. Enter the control panel to uninstall MySQL

3. Enter the system general data folder and delete the MySQL folder

Note that the XP and win7 directories are different

XP directory: C:\Documents and Settings\All Users\Application Data
win7/8/8.1/10 directory: C:\ProgramData or %ProgramData%

Note: win7/8/8.1/10 system does not display the general data folder by default, you need to view-->hidden items to display

Delete the MySQL folder in the picture above

4. Reinstall and no error will be reported this time


Attachment: Common system built-in environment variables
C:\Users\[username]\AppData\Roaming71fb34173e4ee87dab1f85dc1c283a44%AppData%[ win7 and above]
C:\Documents and Settings\[user name]\Application Data71fb34173e4ee87dab1f85dc1c283a44%AppData%[XP]
C:\ProgramData71fb34173e4ee87dab1f85dc1c283a44%ProgramData%[win7 and Above]
C:\Windows71fb34173e4ee87dab1f85dc1c283a44%SystemRoot%

Recommended study: "mysql video tutorial"

The above is the detailed content of How to solve the mysql installation error 1045 problem. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn