MySQL Workbench crash when Starting/Stopping Server

Question

I just downloaded the latest version of MySQL Workbench and going to start the server crashes, Any solution?

Wargo

yeah it doesn't stop the server, the gui cursor gies to runninf, but nithing happens. i wil let it run for a while. but you can post a bug report and post here the link, so hat others can vote on it – Sharice

I understand, but I have to start the server I need to study. How can I do? – Wargo

start services(app) on your computer and look for MySQL80, it will be runnign as it is on autostart – Sharice

I can't find any mysql in services – Wargo

it must be there as your screenshot suggest it is running. have you ordered it by name and looked? – Sharice

The screenshot is not mine is the same as the one that says stopped in red to me. – Wargo

you have to install mysql server together with the workbench, workbench allone brings no server with him. – Sharice

Answer 1

I had the same problem and made a post about it here:

MySQL Workbench Freezing when Starting/Stopping Server

Unfortunately no one was able to give a solution to how to do it from workbench.

But luckily you can do it from outside the workbench. Open the "Services" app on your PC (I assume you're using Windows, may be worth clarifying...) look for "MySQL80" (or something similar to that depending on your MySQL version), click it, and use the controls there to start and stop your MySQL server.

This can be automated with a Powershell script as well if you're that lazy like me.

Cocks

I can't find any mysql in services – Wargo

@Nicolos make sure you're under Services (Local), they should be listed in alphabetical order – Cocks

Yes I am in local computer services but mysql does not come out – Wargo

have you posted a bug report on oracles bug tracker? – Sharice

Not yet, i need to start the server I need to study. – Wargo

you can use dbfiddle to study, but see my comment on your post – Sharice

Win+R then services.msc is a shortcut. MySQL80 is what shows for me after installing MySQL with MySQL Installer 8.0.33. Right click -> Stop to stop the MySQL service. – Concernment

Answer 2

Found how to solve it for myself, hope it will serve others. When installing workbench it doesn't install the mysql server. To install it, run mysql installer (https://dev.mysql.com/downloads/installer/), you can download the slim web installer. After launching it, click the 'Add' button on the right, then go to MySql Servers, select the latest server to install and proceed with wizard to set it up and you should be fine.

Certainty

Answer 3

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)!

Modlin

Answer 4

No reinstalling magic worked for me, just got rid of 8.0.32, and installed 8.0.11, works fine now. Haven't tested other versions yet.

Mancunian

On a free OS or a commercial one ? – Mcneese

Answer 5

Sometimes, a syntax error in a User Snippets file causes the crash. Try opening the file and see if there are any redundant newlines, etc., especially at the beginning and the end of the file. The file location on Windows is as follows:

C:\Users\{USERNAME}\AppData\Roaming\MySQL\Workbench\snippets

Hepta

Answer 6

Just open Mysql installer and reconfigure mysql server again. It works for me

Protactinium

Answer 7

1. Search for MySql installer and open that1

2. the reason your database is not working because you dont have mysql server. 3. after opening it, click on "add" then browse for mysql server. 4. select the mysql server that you want to install. Now click on install. 5. After adding that, install it.

if even after not working, then search for Services in your laptop,

1. look for MySql80 then enable it

Derick

Answer 8

This is happening due to the actual MySQL service being down.

Go to task manager -> Services. Find MySQL80 service and rightClick -> Start. Will take a few seconds to start.

Now when you connect Workbench, it will successfully connect after the password prompt.

Task manager screenshot

Suburban

Answer 9

The problem occurs as a result of the server running on a different port from the one the workbench is listening on,

At MySQL connections at home you will see the port your server runs, on enter image description here, Take that port number and adjust it on your MySQL configurator executable which you can find on your start menu,

Or adjust the configuration file itself by changing the TCP/IP port and port to listen on in the file C:\ProgramData\MySQL\MySQL Server 8.4\my.ini

Once you make the changes you're all set

Pietra

Answer 10

1. You can start/stop the server from the Windows services.

If you can't find MySQL in services, you can run the installer again, then select reconfigure on MySQL server, navigate to Windows Service and enable the Configure MySQL Server as a Windows Service option.

2. You can use an SQL command to shut down the server.

Create a new SQL tab, type shutdown; and execute the script. Note: the workbench might try to restart the server, in which case, you will have to quickly close the window after running the script. After that, you can re-open the workbench.

Cutpurse

Answer 11

Basically is because there is no mysql installed on your computer. My teacher just told me to download workbench, but forgot completely to say, hey download MYSQL first.. After that, you won't have more crashes, it happened to me.

once is done try again, probably sure it will help you inmediately..

Gourmont

This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review – Unattended