0

I am having trouble starting up a server through MySQL Workbench. From the navigator pane on the left side of Instance -> Start/Shutdown, I tried the "Start Server" button at which point the server will look like it will try to start. The workbench will get hung up at this point and indefinitely not respond with a "thinking" mouse icon while in the workbench app.

This is my first time learning to use MySQL workbench, which I want to say that when I initially installed MySQL Workbench a server did start after installation and worked fine. It was after restarting my computer and checking on the workbench the next day (today) that the server no longer runs. I'm not seeing any MySQL references in my Services (services.msc) that might relate to starting up but that might also be because I did not install as a Windows Service. My original troubleshooting was in trying to establish a connection, which I realized it was because the server wasn't running. Could someone help me understand why the server isn't starting? Or would it be recommended to install the workbench as a Windows Service to avoid the issue I'm having?

enter image description here Screenshot of the MySQL Workbench window where the application will get hung up when starting the server.

Current setup: Personal workstation, Windows 10 (64 bit), MySQL Workbench 8.0 (version 8.0.29 build 1751076 CE 64 bits). I do not plan on running the server 24/7 since this is my personal workstation.

Screamcheese
  • 105
  • 1
  • 10

2 Answers2

3
  1. Right-click on My Computer
  2. Select Manage
  3. Select Services under Servies and applications
  4. Find MySQL among the services and open it.
  5. Choose Automatic as a start option.
  6. Click on start.
  7. Press Apply & OK then exit.
  8. It is not necessary, but I still recommend restarting PC.
Pubudu
  • 3
  • 2
jkalandarov
  • 564
  • 5
  • 15
  • jkalandarov I did install as a Windows service and tried manually starting up the service but will immediately stop right after starting. – Screamcheese Jun 05 '22 at 18:08
  • https://stackoverflow.com/questions/35670755/the-mysql-service-on-local-computer-started-and-then-stopped – jkalandarov Jun 06 '22 at 05:32
0

The solution below fixed my issue. I definitely recommend installing MySQL Server as a windows service and making sure uncheck mark the box that says to start when Windows starts unless you plan to have your computer as a dedicated server.

Source from @Lazycoder_007

This solution uses the window's mysql installer which you have used to install your MySQL.

  1. Start your windows mysql installer. For me it was "mysql-installer-community-8.0.20.0"
  2. Then remove/uninstall the SQL Server and remove all configurations
  3. Manually delete the SQL Server folder from "C:\Program Files\MySQL\MySQL Server 8.0."
  4. Start your mysql installer again and install the SQL Server again
  5. You can check now that the MySqL Server has started.
Screamcheese
  • 105
  • 1
  • 10