Skip to content

A special way to install MySQL on Windows 11

Problem Background

MySQL 5.5 or MySQL 5.7 on Windows 11 business version 23H2, but encountered installation interruptions and service startup failures, leading to unsuccessful database deployment. As a result, the DEMS client software service could not be initialized properly.

Primary Reason

  1. MySQL 9.2 does not support mysql_native_password
    The current system (based on AMD architecture) is only compatible with MySQL 9.2. However, this version uses caching_sha2_password or other newer authentication plugins by default, and no longer supports mysql_native_password.
    This results in authentication failure when Shelleyes DEMS client attempts to connect using the legacy plugin.

Potential Cause

2. Poor compatibility of MySQL 5.5 / 5.7 installers
These older MySQL versions were not optimized for Windows 11 23H2. As a result, the following issues may occur during installation:

  • Setup process is interrupted, citing service startup errors
  • MySQL service fails to register or initialize properly
  • Data directory is not created successfully

3. System permission and security policy restrictions
Windows 11 23H2 enforces stricter security controls (e.g., registry write restrictions, service registration protection). Legacy installers may lack the necessary privileges and could be blocked or forcibly terminated by the system.

 Observed Symptoms

  • Option 1: If MySQL 5.5 / 5.7 must be used, consider deploying the ZIP archive version (non-installer) and manually configuring my.ini and Windows service registration.
MySQL_Installation_GuideDownload
  • Option 2: Switch to a more compatible OS version (e.g., Windows 10, or Windows 11 21H2 / 24H2) Additional Advice: If possible, we recommend using a system version better suited to MySQL 5.7 for improved stability and continued support for legacy authentication.