What to do if mysql installation gets stuck

You may encounter a stuck situation when installing MySQL. This can be frustrating, but don’t worry, we can fix this problem with some simple steps.

1. Check system requirements

First, you need to make sure that your system meets the MySQL installation requirements. On the official MySQL website, you can see the system requirements for installation files. If your system does not meet the requirements, then you need to upgrade your system or use another version of MySQL.

2. Turn off the firewall

When installing MySQL, the firewall may block the installation program from communicating with the MySQL server. Therefore, we need to turn off the firewall and ensure that the installer can communicate with the MySQL server.

If you are using a Linux system, you can use the following command to turn off the firewall:

sudo systemctl stop firewalld.service
sudo systemctl disable firewalld.service

If you are using a Windows system, you can follow the following steps to turn off the firewall:

• Open the Control Panel
• Click on “System and Security”
• Click on “Windows Defender Firewall”
• Select “Turn off Windows Defender Firewall”

3. Check port occupancy

Before installing MySQL, you need to make sure that no other applications are occupying the ports required by MySQL. You can use the following command to check the port occupancy:

If you are using a Linux system, you can use the following command:

sudo lsof -i:3306

If you are using a Windows system, you can follow the following steps Check the port occupancy:

• Open the CMD window
• Enter the following command:

netstat -ano | find ":3306"

If there are other applications occupying port 3306 in the output results, You need to kill the processes of these applications. If you are unclear about the contents of these processes, please consult relevant technical personnel.

4. Clean up the installation residual files

If you have tried to install MySQL before, but something went wrong during the installation process, there may be some installation residual files left behind. These residual files may affect your new installation. Therefore, we need to clean these residual files.

If you are using a Linux system, you can use the following command to clean up the installation residual files:

sudo rm -rf /var/lib/mysql
sudo rm /etc/my.cnf

If you are using a Windows system, you can follow the following steps to clean up the installation residual files:

• Open Windows Explorer
• Enter C:\Program Files\MySQL
• Delete the MySQL folder
• Search for the my.ini file, if found , please delete it.

5. Reinstall MySQL

Now that we have taken some steps to resolve the stuck issue, we can reinstall MySQL.
Before reinstalling, it is recommended that you use the uninstall tool to completely uninstall MySQL to ensure that the previous installation will not interfere with the new installation.
If you are using a Linux system, use the following command in the terminal to uninstall MySQL:

sudo apt remove --purge mysql*

If you are using a Windows system, you can follow the following steps to uninstall MySQL:

• Open Control Panel
• Click "Programs and Features"
• Find MySQL and select "Uninstall".

Now, you can re-download and install MySQL. Usually, the problem can be solved after reinstallation.

Conclusion

MySQL is a very good database, but you may encounter various problems during the installation process. When you encounter the problem of MySQL installation being stuck, you can first check the system requirements, turn off the firewall, check the port occupancy, clean up the residual installation files, and then reinstall MySQL. I hope this article can help you install MySQL smoothly.

The above is the detailed content of What to do if mysql installation gets stuck. For more information, please follow other related articles on the PHP Chinese website!