MySQL service fails to start when installed to a GPT formatted disk

book

Article ID: 100032758

calendar_today

Updated On:

Description

Error Message

"Windows could not start the MySQL service on Local Computer"

Cause

This issue is only seen when MySQL is installed to a GPT formatted disk.

Resolution

Use the following steps to verify the disk MySQL is to be installed to is GPT formatted:
  1. ​Open a new command prompt window
  2. Type in "diskpart" and hit enter
  3. The Microsoft DiskPart utility will be displayed
  4. When the prompt returns type in "list disk" and hit enter
  5. A list of disks will be displayed
  6. If the disk MySQL is installed to has an asterisk "*" under the "Gpt" column, then the disk is GPT formatted
If the disk MySQL is installed to (or will be installed to) is GPT formatted, use the following steps to resolve/prevent the issue:
  • Use the following steps for a Clearwell Upgrade:
    • Note: If the version of MySQL currently installed matches the version of the upgrade, then this issue may be resolved using the following steps. If the versions do not match, please use the solution listed under the Clearwell installation below
  1. Prior to running the Clearwell upgrade, go to (Drive letter where MySQL is installed):\MySQL
  2. Open the "my.ini" file
  3. Find the header/comment "#*** INNODB Specific options ***"
  4. Directly under this header type in "innodb_flush_method=normal" (without the doube quotes)
  5. Save this file
  6. Start the Clearwell upgrade process
 
  • Use the following steps for a Clearwell installation:
  1. During the installation an error will be displayed in a pop up window stating that the MySQL service could not be started
  2. When this error is displayed, do not cancel or continue the installation. Continue to step 3
  3. Go to the directory (Drive letter where MySQL is to be installed):\MySQL
  4. Open the "my.ini" file
  5. Find the header/comment "#*** INNODB Specific options ***"
  6. Directly under this header type in "innodb_flush_method=normal" (without the doube quotes)
  7. Save this file
  8. Start the MySQL service manually from the "services.msc" console
  9. Resume the Clearwell installation

 

Issue/Introduction

Windows requires that all disks larger than 2TB be formatted using GPT instead of the standard MBR. If MySQL is installed to a GPT disk then the service will fail to start during a Clearwell upgrade, installation, or starting the service manually from services.msc.
 

Additional Information

ETrack: 3892821
Powered by Wolken Software