How to solve the mysql installation error 1045 problem

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.

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\Roaming<-->%AppData%[ win7 and above]
C:\Documents and Settings\[user name]\Application Data<-->%AppData%[XP]
C:\ProgramData<-->%ProgramData%[win7 and Above]
C:\Windows<-->%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!