MYSQL Initialization Nightmare? Fix Database Errors FAST!

preview_player
Показать описание
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:

Рекомендации по теме
Комментарии
Автор

Thanks Ibrahim, it worked for me. You saved me!

ShivaniSharma-pfr
Автор

Thanks Ibrahim, it worked for me. Please follow the step mentioned.

Astudyias
Автор

Muito obrigado, faz 1 ano que tento corrigir esse problema, graças a você consegui fazer funcionar e finalizar o projeto da faculdade, muito obrigado!

alexandrebastiani
Автор

Still not resolved from this resolution

SumitSingh-fpmc
Автор

didnt work for me, followed each step properly yet didnt work 👎

taher...
Автор

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

nethraselvaraj
join shbcf.ru