Question
Table of Contents
When I install the MySQL Server using the MySQL Installer, the installation process freezes at the apply configuration steps for system tables upgrade.
Solution 1
If you’re upgrading MySQL from one version to another version of your database.
Fix: Do a mysqldump first, nuke the entire MySQL installation, install MySQL from scratch, restore your databases… being sure to skip any system tables like the mysql + performance + sys tables… so only backup + restore user data tables.
Solution 2
If you aren’t updating MySQL versions, then running a system tables upgrade is a NOP (no operation, nothing occurs).
Solution 3
Anytime you have a problem like this refer to the system logs, which will usually surface problem instantly Refer to OS docs to determine where your logs live + in the case of MySQL, maybe the MySQL website.
Alex Lim
Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook
