How to solve the 1069 error when starting mysql

The reason for the 1069 error when starting mysql is that the login password of the server has been changed. The solution: 1. Find the mysql user in the management user and reset the mysql password; 2. Find the mysql service option in the service. Just log in to the mysql service again with the changed password in the properties.

The operating environment of this tutorial: windows7 system, mysql8.0.22 version, Dell G3 computer.

How to solve the 1069 error when starting mysql

When starting MYSQL, it prompts an error: "The mysql service cannot be started on the local computer. Error 1069: The service cannot be started due to login failure." Let me introduce myself below Solution

1. Open your own server (mine is a VPS), then select [My Computer], right-click, and select [Manage]

2. Under the [Management] interface, find [Local Users and Groups], select [Users], and then find the [MYSQL] user in [Users].

3. Select the [MYSQL] user, then right-click, select [Set Password], and then an input dialog box will pop up, enter the new password and confirm the password, and then [OK] 】.

4. After completing the above, also find [Services and Applications] under the [Management] interface, then select [Services] and find the [MYSQL] service options.

5. Right-click in the [MYSQL] service option, select [Properties], and then a dialog box will pop up. At this time, select the [Login] tab. Then enter the password you just changed and confirm.

6. Finally, return to the [Service] interface, right-click on the [MYSQL] service option, and select [Start]. That's it.

Recommended learning: mysql video tutorial

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