Windows mysql Boot 1069 error "Unable to start service due to logon failure" method

Problem phenomenon

The MySQL service under Windows failed to start, reported a 1069 error.

Cause of the problem

If MySQL starts the user's password or permissions error, it causes the Windows Server MySQL startup to "fail to start the service because of logon failure" error.

Solution Solutions

Right click on "My Computer" → "Manage" → "services" → find "MySQL" Service Right click on "Properties", on the "Login" tab, re-enter the correct user name and password before testing. Alternatively, you can modify the MySQL startup user to the local System account. Before modification

After modification

Restart the MySQL service after the modification is complete.

Note: If you modify the system account, the MySQL service will start with the System account privileges, if there is a bug in the MySQL program may reduce the security of the system.

Reference: http://www.myhack58.com/Article/sort099/sort0100/2016/76850.htm

Windows mysql Boot 1069 error "Unable to start service due to logon failure" method