Why Does MySQL Configuration Hang at 'Starting Server' on Windows 8?

MySQL Configuration Hangs at "Starting Server"

During the MySQL installation process on Windows 8, users may encounter an issue where the configuration process stalls at the "starting server" stage. The provided log indicates that several configuration steps have been completed successfully, including stopping the server (if necessary), updating the firewall, and adjusting the Windows service.

To resolve this issue, follow these steps:

1. Install MySQL using the "mysql-installer-web-community-5.6.23.0.msi" file.
2. Select the "Custom" installation option and install MySQL servers 5.6.22 - X64 and MySQL Connectors -> Connector ODBC/5.3.4 - 64.
3. Proceed through the configuration wizard and specify a MySQL Root Password.
4. Add a new MySQL user by selecting "Add user" and providing a username and password.
5. Check the option to "Configure MySQL Server as a Windows Service."
6. Select "MySQL56" as the Windows Service Name and enable "Start the MySQL Serve at System Startup."
7. Crucially, ensure that "Run Service as..." is set to "Standard System Account" (this setting may initially be incorrect due to a bug).
8. Proceed with the installation and wait for the configuration to time out.
9. While the installation is timing out, navigate to the Services management window and right-click on the "MySQL56" service.
10. Select "Properties" and go to the "Log On" tab. Change the "This account:" setting to "Local System Account" and allow the service to interact with the desktop.
11. Return to the general tab and click "Start" to initiate the service.
12. Complete the MySQL Installer wizard by clicking "Finish."

By following these steps, including the crucial adjustment of the service log on settings, you should be able to successfully complete the MySQL configuration process.

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