Why Does MySQL Configuration Get Stuck at 'Starting Server'?

MySQL Configuration Halts at "Starting Server": Troubleshooting and Resolution

MySQL users may encounter a frustrating issue where the configuration process freezes at "starting server." This article delves into the causes of this problem and provides a detailed solution that has proven effective for many.

Problem Description:

During the server configuration stage of the MySQL installer, the process gets stuck at "starting server." The log displays that all other configuration steps have been completed successfully.

Cause:

This issue is attributed to an error in the "Run service as..." option. By default, the MySQL installer attempts to set the service account to "Network Service," but a bug causes it to ignore this setting and select "Local System Account" instead.

Solution:

To resolve this problem, follow these steps:

1. Wait for the installation to time out or continue waiting for an extended period.
2. Once the "Configuration is taking longer than expected..." message appears, click "OK."
3. Navigate to Services (Start -> Control Panel -> Administrative Tools -> Services) and find MySQL56.
4. Right-click on MySQL56 and select "Properties."
5. Switch to the "Log On" tab.
6. Correct the "This account:" setting to "Local System Account."
7. Enable the "Allow service to interact with desktop" option.
8. Click "Apply" and navigate back to the "General" tab.
9. Start the MySQL56 service.
10. Return to the MySQL Installer dialog. You will notice that all configuration steps are now complete.
11. Finish the installation process and complete setup.

By following these steps, you will successfully configure the MySQL service and avoid the "starting server" halt. Enjoy the seamless use of your MySQL database.

The above is the detailed content of Why Does MySQL Configuration Get Stuck at 'Starting Server'?. For more information, please follow other related articles on the PHP Chinese website!