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/....
My SQL apply configuration ->starting the server is failed,how to fix this
same problem for me to
Solve...hua.mujhe bhi yhi problem ara he@@NITHYASARATHIMCSE
your problem resolved or not?