Fixing MySQL Initialization Error: mysqlx-port and Database Initialization Failed

Поділитися
Вставка
  • Опубліковано 17 жов 2024
  • This video addresses a common MySQL server initialization error related to the mysqlx-port configuration and the "initialize database failed" issue. Learn how to modify your Windows registry settings to increase ephemeral ports and reduce the TIME_WAIT state, ensuring smoother MySQL operations.
    Steps Covered:
    Uninstall MySQL Server and Workbench:
    Completely uninstall MySQL Server and MySQL Workbench from your system.
    Delete the MySQL file directory (usually found in C:\Program Files\MySQL).
    Open Registry Editor:
    Press Win + R, type regedt32, and press Enter.
    Navigate to the TCP/IP Parameters Key:
    Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters.
    Add MaxUserPort:
    Right-click on the Parameters key, select New DWORD (32-bit) Value.
    Name it MaxUserPort.
    Set its value to 65534.
    Add TcpTimedWaitDelay:
    Right-click on the Parameters key, select New DWORD (32-bit) Value.
    Name it TcpTimedWaitDelay.
    Set its value to 30.
    Restart Your Computer:
    Reboot your machine to apply the changes.
    Reinstall MySQL:
    Download and install MySQL Server and Workbench again.
    Proceed with the initialization and configuration.
    Important: Before making any changes to the Windows registry, ensure you back it up and understand how to restore it if needed.
    Useful Links:
    Microsoft Knowledge Base: How to back up and restore the registry: support.microso....
    MySQL Documentation: Can't connect to MySQL server on Windows: dev.mysql.com/....

КОМЕНТАРІ • 4

  • @nethraselvaraj6787
    @nethraselvaraj6787 2 місяці тому

    My SQL apply configuration ->starting the server is failed,how to fix this

    • @NITHYASARATHIMCSE
      @NITHYASARATHIMCSE 2 місяці тому

      same problem for me to

    • @Abhii-07
      @Abhii-07 2 місяці тому

      Solve...hua.mujhe bhi yhi problem ara he​@@NITHYASARATHIMCSE

    • @Z-TIMES
      @Z-TIMES Місяць тому

      your problem resolved or not?