Why Does MySQL Server Configuration Hang at 'Starting Server'?

MySQL Server Configuration Hangs at "Starting Server"

Problem Description

When attempting to configure a MySQL server installed using MySQL Installer on Windows 8, the process stalls at the "starting server" step. The configuration log indicates that all other steps have completed successfully.

Attempts at Resolution

Several attempts to resolve the issue have been made without success:

• Uninstalling and reinstalling MySQL
• Deleting MySQL folders and registry entries

The Solution

The problem lies in an inconsistency between the selected service account and the actual account used to start the service during configuration.

To resolve this, follow these steps:

1. Access the MySQL service settings (Services -> MySQL56 -> Properties)
2. On the Log On tab, change the service account to "Local System Account"
3. Apply the change and start the service
4. All configuration steps should now complete successfully

Detailed Walkthrough

1. Install MySQL using mysql-installer-web-community-5.6.23.0.msi
2. Select "Custom" install and include MySQL Servers 5.6.22 - X64 and MySQL Connectors -> Connector ODBC/5.3.4 - 64
3. Configure the server as a Windows Service
4. Set the Windows Service Name to "MySQL56"
5. Check "Start the MySQL Serve at System Startup"
6. On the Run Service as... option, leave the Standard System Account checked (this setting will be disregarded due to a bug)
7. Wait for the configuration to time out and click "OK" to continue waiting
8. Navigate to Control Panel -> Administrative Tools -> Services
9. Find the MySQL56 service, right-click on it, and select Properties
10. On the Log On tab, change the service account to "Local System Account"
11. Return to the Services manager, start the MySQL56 service, and close the windows
12. All configuration steps will now complete successfully

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