How to solve the problem that mysql service cannot start 1069

Solution to the 1069 error that the mysql service cannot be started: 1. Find the mysql user in the administrative user and reset the mysql password; 2. Find the mysql service option in the service, and reset it with the changed password in the properties. Just log in to the mysql service. The reason for the 1069 error is that the login password of the server has been changed.

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

How to solve the problem that the mysql service cannot start 1069

Problem description:

After modifying the server password, the database cannot be connected. Log in to the server to check that the DB2 service is not available. When starting, an error occurs when starting the service: "Error 1069, the service cannot be started due to login failure."

Solution

The 1069 error occurs because the login password of the server has been changed.

1. Right-click [My Computer] → [Management] → [Service] → Find the [mysql] service, right-click [Properties], and enter the correct user name and password in the [Login] tab. Re-enter and test again. Or you can modify the Mysql startup user to the local system account. As shown before modification:

2. After the modification is completed, restart the Mysql service.

Note: If you change it to a system account, the Mysql service will be started with the system account permissions. If there are vulnerabilities in the Mysql program, the security of the system may be reduced.

Recommended learning: mysql video tutorial

The above is the detailed content of How to solve the problem that mysql service cannot start 1069. For more information, please follow other related articles on the PHP Chinese website!