'MySQL Workbench Freezing when Starting/Stopping Server
I recently started using MySQL Server and Workbench (both version 8.0), and noticed a strange issue: When I load Workbench, go to Server -> Startup/Shutdown and click "Stop Server", MySQL will freeze. Here's a picture:
When I press Stop Server, it first gives me a windows prompt about allowing it to make changes, then as you can see it freezes and grays out. The same thing happens if the server is off and I press Start Server.
I've uninstalled and reinstalled everything related to MySQL, cleared MySQL from Program Files & Program Data, and had zero luck. The server does turn on/off from Component Services however, so my temporary solution has been a poorly written powershell script to turn it off and on.
If anyone has a solution for why it won't turn on in Workbench please let me know.
Solution 1:[1]
The only way to fix the issue is using MySQL Installer (https://dev.mysql.com/downloads/installer). Once you 'Remove' and 'Add', it will work (the DB will not be deleted, so no worries)!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | KimchiMan |