Solve the problem of "mysql service Error 1069 cannot be started", mysql1069

Solve the problem of "mysql service Error 1069 cannot be started", mysql1069

Today, when I was on the road, my colleague sent a message saying that the website background could not be accessed. That's an emergency!

Arriving at the company and logging on to the server is normal. Fortunately, it does not seem to be a problem with the server itself. The error prompt should be a problem with mysql.

Check the service options. The status is not started. when MYSQL is started, the system prompts an error: "mysql service cannot be started on the local computer. Error 1069: the service cannot be started due to logon failure ", this makes me very depressed. How can I get errors in MYSQL? The following describes the solution.

1,

Open your server (My VPS), select my computer, right-click, and choose manage]

2,

On the Management page, find local users and groups, select users, and find MYSQL users in user.

3,

Select MYSQL user, right-click the user, and select set password. A dialog box is displayed, enter the new password and confirm the password, and click OK ].

4,

After completing the preceding steps, find service and application on the Management page, select service, and find the MYSQL service option.

5,

Right-click MYSQL service options and select Properties. A dialog box is displayed. Select the logon tab. Then, enter the password you just changed and click OK.

6,

Finally, return to the Service Page, right-click MYSQL service options, and select start ]. You can.