How to solve "Unable to start mysql service error 1069"

Today, when I was on the road, a colleague sent me a message saying that the website backend was inaccessible. It was so urgent!

I rushed to the company and logged into the server. Everything was normal. Fortunately, it seemed that it was not a problem with the server itself. Looking at the error message, it should be a problem with MySQL.

I checked the service options and found that it was not started. When I started MYSQL, an error message appeared: "Unable to start the MySQL service on the local computer. Error 1069: Unable to start the service due to a login failure." This made me very depressed. How could an error occur in MYSQL? Here is my own solution

1.

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

2.

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

3.

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

4.

After completing the above, also in the [Management] interface, find [Services and Applications], then select [Services], and find the [MYSQL] service option.

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 click OK.

6.