启动/停止服务器时MySQL Workbench崩溃
我刚刚下载了MySQL Workbench的最新版本，并开始启动服务器崩溃了吗？
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
我刚刚下载了MySQL Workbench的最新版本，并开始启动服务器崩溃了吗？
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
接受 或继续使用网站，即表示您同意使用 Cookies 和您的相关数据。
发布评论
评论（11）
我遇到了同样的问题，并在此处发表了一篇文章：
不幸的是，没有人能够从Workbench提供解决方案。
但幸运的是，您可以从工作台外部进行。打开PC上的“服务”应用程序（我认为您正在使用Windows，可能值得澄清...）查找“ mysql80”（或根据您的MySQL版本相似的内容），单击它，然后使用控制此处以启动并停止您的MySQL Server。
如果您像我一样懒惰，也可以使用PowerShell脚本自动化这一点。
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.
找到了如何为自己解决的方法，希望它能为他人服务。
安装Workbench时，它不会安装MySQL Server。
要安装它，请运行mySQL installer（ https://dev.mysql.com/ /a>），您可以下载Slim Web安装程序。
启动它后，单击右侧的“添加”按钮，然后转到MySQL服务器，选择要安装的最新服务器，然后使用向导进行设置，您应该没问题。
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.
解决该问题的唯一方法是使用
mySQL installer（ https：// dev https：// dev .mysql.com/downloads/installer ）。一旦您“删除”和“添加”，它将起作用（DB不会删除，因此不用担心）！
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)!
没有重新安装的魔术对我有用，刚刚摆脱了8.0.32，并安装了8.0.11，现在正常工作。尚未测试其他版本。
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.
有时，
用户摘要中的语法错误文件会导致崩溃。尝试打开文件，看看是否有任何冗余新线等，尤其是在文件的开始和结尾处。
Windows上的文件位置如下：
c：\ users \ {userName} \ appdata \ roaming \ mysql \ mysql \ workbench \ sippetsSometimes, a syntax error in a
User Snippetsfile 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只需打开MySQL安装程序，然后重新配置MySQL Server即可。它对我有用
Just open Mysql installer and reconfigure mysql server again. It works for me
2。有MySQL Server。
3。打开它后，单击“添加”，然后浏览MySQL Server。
4。选择要安装的MySQL服务器。现在单击安装。
5。添加后，安装它。
即使在不工作后，请在笔记本电脑中搜索服务，
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,
这是由于实际的MySQL服务正在下降而发生的。
转到任务经理-GT;服务。
查找MySQL80服务和右键 - ＆GT;开始。将需要几秒钟的时间开始。
现在，当您连接工作台时，它将在密码提示下成功连接。
任务管理器屏幕截图
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
问题是由于服务器
在其他端口上运行的服务器从Workbench侦听的，在家里的MySQL Connections上，您会看到服务器运行的端口，on
或通过更改tcp/ip端口和端口来调整配置文件本身，以在文件
c：\ programData \ mysql \ mysql \ mysql Server 8.4 \ my.ini进行更改后全部设置
The problem occurs as a result of the server
running on a different portfrom 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.iniOnce you make the changes you're all set
如果您在服务中找不到MySQL，则可以再次运行安装程序，然后在MySQL Server上选择重新配置，导航到
Windows Service，并启用将MySQL Server配置为Windows Service 选项。创建一个新的SQL选项卡，类型
shutdown;并执行脚本。注意：Workbench可能会尝试重新启动服务器，在这种情况下，您必须在运行脚本后快速关闭窗口。之后，您可以重新开放工作台。
If you can't find MySQL in services, you can run the installer again, then select reconfigure on MySQL server, navigate to
Windows Serviceand enable theConfigure MySQL Server as a Windows Serviceoption.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.
基本上是因为您的计算机上没有安装MySQL。
我的老师刚刚告诉我下载Workbench，但完全忘了说，嘿，首先下载mysql。
之后，您不会发生更多的崩溃，这发生在我身上。
完成后，再试一次，可能会确保它会立即帮助您。
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..