entityMap|blocks|key|bjv8g|text|为了解决这个问题，我将MySQL工作台降级到6.1。现在我可以运行我的查询了，它不会挂起。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

To resolve this issue, I downgraded MySQL Workbench to 6.1. Now I am able to run my query and it doesn't hang.

entityMap|blocks|key|bf92u|text|这似乎有帮助|type|unstyled|depth|inlineStyleRanges|entityRanges|data|bms5o|一些|5icei|使用不同的用户连接到数据库，然后与原始用户重新连接。|ficeu|我即将降级，就像公认的答案所说的那样，因为这并不能每次都解决它。^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|I|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|J|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|K|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|L|9|@]|A|@]|B|$]]]]

This seemed to help some of the time, but not 100%:
Connect to the database with a different user, and then re-connect with the original user.

I'm about to downgrade like the accepted answer says though, as this doesn't solve it every time.

entityMap|blocks|key|7vl89|text|我发现，如果你使用最新的6.3版本，为了让查询正常工作，你必须打开第一个连接，然后忽略它，然后打开第二个连接。这将在工作台中创建两个选项卡。如果您在第二个选项卡中执行查询，它将起作用。如果您尝试在第一个选项卡，它挂起。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|fqntc|我还发现你必须强制退出工作台。|epiuh|我希望mysql的人能解决这个问题。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|H|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|I|9|@]|A|@]|B|$]]]]

I found that if you use the latest 6.3 version, that in order to get queries to work, you have open a first connection and ignore it and then open a second connection. This creates two tabs in the workbench. If you perform your queries in the second tab, it works. If you try in the first tab, it hangs.

I also have found that you have to do a force quit the workbench.

I hope the mysql folks get this fixed.

entityMap|blocks|key|80eof|text|我发现删除缓存和工作区文件夹内容(~/Library/Application+Support/MySQL/Workbench)再次起作用。我没有发现的是如何确保它不会再次挂起:-(|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4jscj|我还发现，如果我从菜单中手动关闭连接选项卡，并从菜单中退出WB，而不是从操作系统窗口的按钮中退出，那么下一次似乎会更稳定。|9gg4l|PS:我正在使用SSH连接，所以这可能是由于这个原因，但它并不总是发生。|d1nmg|更新:干净安装，没有SSH配置，这个问题仍然存在。除非您手动删除缓存文件夹文件，否则它将继续挂起。^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|I|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|J|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|K|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|L|9|@]|A|@]|B|$]]]]

I found that deleting the cache and workspaces folder contents (~/Library/Application Support/MySQL/Workbench) it works again. What I haven't found is how to ensure it doesn't hang again :-(

I also found that if I manually close the Connection tab from the menu and exit WB from the menu and not from the OS window buttons it seems more stable next time.

PS: I am using SSH connection so it may be due to this but it is not always happening.

UPDATE: A clean install and no SSH configurations the issue still persists. Unless you manually go and delete the cache folder files it continues to hang.

entityMap|blocks|key|cm91q|text|在我的示例中，它将connection->+SSL+->Use+SSL设置从"If+available“更改为"No”。OSX+10.12.1上的Workbench+6.3.8现在可以为我工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

In my case, it was changing the connection->ssl->Use SSL setting from "If available" to "No". Workbench 6.3.8 on OSX 10.12.1 now works for me.

entityMap|blocks|key|2hi8b|text|更新3:+MacOS+HighSierra中的问题已修复|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2rrc2|MySQL工作台6.3.10|2621s|..。|bdplr|更新2:看起来这个bug在MacOS+HighSierra中又出现了。请参见|acdhu|https://bugs.mysql.com/bug.php?id=83658|5th5h|了解更多详细信息。|9janl|有一个非官方的版本可以解决这个问题。您可以通过以下地址下载：|7hj01|https://drive.google.com/drive/folders/0B2fTesDcrHzVRGVFWEdILWpuaEE?usp=sharing|6ljiq|构建是由Bob+Davenport创建的。请参见|7cq8v|https://bugs.mysql.com/bug.php?id=87714|2aq91|2l5v6|更新:错误已在|73e6i|MySQL工作台6.3.9|15gli|9k5v3|9pc19|这是一个已知的MySQL错误：|9qgql|http://bugs.mysql.com/bug.php?id=83658|76dub|由MacOS中引入的GateKeeper路径随机化引起。请参见|3m45j|https://weblog.rogueamoeba.com/2016/06/29/sierra-and-gatekeeper-path-randomization/|cpot1|5ivhv|一种可能的解决方法是删除隔离ACL：|4ptbl|xattr+-dr+com.apple.quarantine+"/Applications/MySQLWorkbench.app"|code-block|syntax|javascript^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|1H|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|1I|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|1J|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|1K|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|1L|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|1M|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|1N|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|1O|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|1P|9|@]|A|@]|B|$]]|$2|S|4|T|6|7|8|1Q|9|@]|A|@]|B|$]]|$2|U|4|L|6|7|8|1R|9|@]|A|@]|B|$]]|$2|V|4|W|6|7|8|1S|9|@]|A|@]|B|$]]|$2|X|4|Y|6|7|8|1T|9|@]|A|@]|B|$]]|$2|Z|4|F|6|7|8|1U|9|@]|A|@]|B|$]]|$2|10|4|-4|6|7|8|1V|9|@]|A|@]|B|$]]|$2|11|4|12|6|7|8|1W|9|@]|A|@]|B|$]]|$2|13|4|14|6|7|8|1X|9|@]|A|@]|B|$]]|$2|15|4|16|6|7|8|1Y|9|@]|A|@]|B|$]]|$2|17|4|18|6|7|8|1Z|9|@]|A|@]|B|$]]|$2|19|4|F|6|7|8|20|9|@]|A|@]|B|$]]|$2|1A|4|1B|6|7|8|21|9|@]|A|@]|B|$]]|$2|1C|4|1D|6|1E|8|22|9|@]|A|@]|B|$1F|1G]]]]

UPDATE 3: The problem is fixed for MacOS HighSierra in <a href="https://dev.mysql.com/downloads/file/?id=474219" rel="noreferrer">MySQL Workbench 6.3.10</a>.

UPDATE 2: It looks like the bug is recurring again in MacOS HighSierra. See <a href="https://bugs.mysql.com/bug.php?id=83658" rel="noreferrer">https://bugs.mysql.com/bug.php?id=83658</a> for more details.

There is an unofficial build that fixes the problem. You can download it at: <a href="https://drive.google.com/drive/folders/0B2fTesDcrHzVRGVFWEdILWpuaEE?usp=sharing" rel="noreferrer">https://drive.google.com/drive/folders/0B2fTesDcrHzVRGVFWEdILWpuaEE?usp=sharing</a>

The build was created by Bob Davenport. See <a href="https://bugs.mysql.com/bug.php?id=87714" rel="noreferrer">https://bugs.mysql.com/bug.php?id=87714</a> for more details.

<hr>

UPDATE: The bug is fixed in <a href="https://dev.mysql.com/downloads/file/?id=468289" rel="noreferrer">MySQL Workbench 6.3.9</a>.

----------------------- original answer -----------------------

It is a known MySQL bug: <a href="http://bugs.mysql.com/bug.php?id=83658" rel="noreferrer">http://bugs.mysql.com/bug.php?id=83658</a> caused by GateKeeper Path Randomisation introduced in MacOS Sierra. See <a href="https://weblog.rogueamoeba.com/2016/06/29/sierra-and-gatekeeper-path-randomization/" rel="noreferrer">https://weblog.rogueamoeba.com/2016/06/29/sierra-and-gatekeeper-path-randomization/</a>.

A possible workaround is to remove the Quarantine ACL:

<pre><code>xattr -dr com.apple.quarantine "/Applications/MySQLWorkbench.app"
</code></pre>

entityMap|blocks|key|al6gp|text|我通过删除用户库文件夹并返回到版本6.2.5来解决这个问题。但今天发现问题又回来了。所以今天我删除了用户库文件夹，回到了6.1.7版本。现在，它又开始工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

I was getting around the problem for awhile by deleting the user library folder and dropping back to version 6.2.5 ... but today found the problem was back. So today I deleted the user library folder and dropped back to version 6.1.7. It's working again, for now.

entityMap|blocks|key|2drc1|text|在我的例子中，IP地址更改了为mySQL提供服务的位置。刷新DNS为我修复了它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3uali|sudo+dscacheutil+-flushcache;
sudo+killall+-HUP+mDNSResponder;+
say+cache+flushed|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

In my case, the IP address changed where mySQL was served.
Flushing the DNS fixed it for me:

<pre><code>sudo dscacheutil -flushcache;
sudo killall -HUP mDNSResponder; 
say cache flushed
</code></pre>

entityMap|blocks|key|f3dfa|text|死亡的旋转轮是由于Sierra更新中引入的新功能，称为“|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4hglq|网守路径随机化|2tus8|“。|2t8eg|按照说明操作：|7jqh2|打开MySQL工作台:)|9q435|右键单击您的连接(很可能是“localhost”或“127.0.0.1”)|9an5a|选择“编辑连接”|8vano|在右侧窗口中选择“Connection>SSL”|61fpj|将“Use+SSL”从“If+available”更改为“No”|5jk5g|现在单击选项卡“System+Profile”|57e0f|选择“MacOS+X”作为系统类型|80jdm|单击“测试连接”|19hbq|制作者：|7bqqf|http://cordobo.com/2398-mysql-workbench-6-3-macos-sierra-hangs-on-simple-queries/^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|12|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|13|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|14|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|15|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|16|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|17|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|18|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|19|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|1A|9|@]|A|@]|B|$]]|$2|S|4|T|6|7|8|1B|9|@]|A|@]|B|$]]|$2|U|4|V|6|7|8|1C|9|@]|A|@]|B|$]]|$2|W|4|X|6|7|8|1D|9|@]|A|@]|B|$]]|$2|Y|4|Z|6|7|8|1E|9|@]|A|@]|B|$]]|$2|10|4|11|6|7|8|1F|9|@]|A|@]|B|$]]]]

The spinning wheel of death is due to the new feature introduced in the Sierra update called "<a href="http://devstreaming.apple.com/videos/wwdc/2016/706sgjvzkvg6rrg9icw/706/706_whats_new_in_security.pdf">Gatekeeper Path Randomization</a>". 

Follow the instructions:

<ul>
<li>Open MySQL Workbench :)</li>
<li>Right click on your connection (most likely “localhost” or “127.0.0.1”)</li>
<li>Choose “Edit connection”</li>
<li>On the right hand window select “Connection > SSL”</li>
<li>Change “Use SSL” from “If available” to “No”</li>
<li>Now click on the tab “System Profile”</li>
<li>Choose “MacOS X” as System Type</li>
<li>Click “Test connection”</li>
</ul>

Credits: <a href="http://cordobo.com/2398-mysql-workbench-6-3-macos-sierra-hangs-on-simple-queries/">http://cordobo.com/2398-mysql-workbench-6-3-macos-sierra-hangs-on-simple-queries/</a>

entityMap|blocks|key|iofh|text|这在6.3.8中仍然是一个开放的错误：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7leb6|https://bugs.mysql.com/bug.php?id=82231|7aed1|可能的解决方法是打开具有相同连接的辅助选项卡并在其中工作。然而，不管怎样，它还是会时不时地崩溃。|5hkfs|在这个bug被修复之前，我使用免费的Mysql+Workbench来替代普通的工作。对于mac用户，我建议|7212l|https://sequelpro.com|dc2bs|..。^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|M|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|N|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|O|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|P|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|Q|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|R|9|@]|A|@]|B|$]]]]

This is still an open bug in 6.3.8:
<a href="https://bugs.mysql.com/bug.php?id=82231" rel="nofollow noreferrer">https://bugs.mysql.com/bug.php?id=82231</a>

The possible workaround is to open secondary tab with the same connection and work in there. However it crashes anyway from time to time.

Until the bug is fixed I use free Mysql Workbench aleternative for common work. For mac users I would suggest <a href="https://sequelpro.com" rel="nofollow noreferrer">https://sequelpro.com</a>.

entityMap|blocks|key|5liik|text|版本6.3.9解决了这个问题，但是这个版本没有显示在“检查升级”选项中，你需要直接从网站下载。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|997ba|MySQL工作台官方下载页面^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

The version 6.3.9 solved the problem, but this version is not showing in "Check for upgrades" option, you need to download directly from the site.

<a href="https://dev.mysql.com/downloads/workbench/" rel="noreferrer">MySQL Workbench official download page</a>

entityMap|blocks|key|f1vmk|text|6.3.9修复了mac中的问题。这是链接|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5ghea|MySql+6.3.9^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

6.3.9 fixed the issue in the mac. Here is the link <a href="https://dev.mysql.com/downloads/file/?id=468289" rel="nofollow noreferrer">MySql 6.3.9 </a>

entityMap|blocks|key|3oqpi|text|升级到6.3.9修复了这个问题。6.3.4一直挂在我的问题上。不幸的是，Help+>+Check+for+Updates并没有显示任何可用的更新，所以我找到了源代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

Upgrade to 6.3.9 fixed the issue. The 6.3.4 was hanging on queries for me. Unfortunately the Help > Check for Updates didn't indicate any updates were available, so I went to the source.

entityMap|blocks|key|bgubh|text|我终于下载了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|brmdh|MySQL工作台6.3.10|3d0t6|并安装|c8q1l|98n28|解决了我的问题。我已经下载了|2v85k|231o5|来自bellow|b0u4h|https://dev.mysql.com/downloads/workbench/|cvfru|它对我很有效..我想这对你会有用的..^0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|Q|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|R|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|S|9|@]|A|@]|B|$]]|$2|G|4|D|6|7|8|T|9|@]|A|@]|B|$]]|$2|H|4|I|6|7|8|U|9|@]|A|@]|B|$]]|$2|J|4|D|6|7|8|V|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|W|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|X|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|Y|9|@]|A|@]|B|$]]]]

<ol>
<li>At last I have downloaded MySQL Workbench 6.3.10 and install MySQL Workbench 6.3.10 and solved my problem. I have downloaded MySQL Workbench 6.3.10 from bellow link <a href="https://dev.mysql.com/downloads/workbench/" rel="nofollow noreferrer">https://dev.mysql.com/downloads/workbench/</a></li>
<li>It is working for me.. I think this will work for you..</li>
</ol>

entityMap|blocks|key|fidcl|text|作为一种临时/即时的解决方案，这可能会有所帮助。如果我尝试手动键入以下查询，MySQL工作台将挂起，尤其是在x.*|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|59d38|66jjg|SELECT+
++++x.*
FROM+x_table+x;|code-block|syntax|javascript|8sb2j|但是，如果我在另一个编辑器中编写MySQL，并将其粘贴到中并运行查询，它就不会挂起。|d5ig3|版本:+MacOS+Big+Sur+(11.2)、MySQL+Workbench+8.0^0|1I|3|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|Q|9|@$A|R|B|S|C|D]]|E|@]|F|$]]|$2|G|4|-4|6|7|8|T|9|@]|E|@]|F|$]]|$2|H|4|I|6|J|8|U|9|@]|E|@]|F|$K|L]]|$2|M|4|N|6|7|8|V|9|@]|E|@]|F|$]]|$2|O|4|P|6|7|8|W|9|@]|E|@]|F|$]]]]

This can probably help as a temporary/immediate solution. If I try to manually type the below query, MySQL Workbench hangs, especially at <code>x.*</code>
<pre><code>SELECT 
 x.*
FROM x_table x;
</code></pre>
But if I write the SQL in another editor and paste it in MySQL Workbench and run the query, it doesn't hang.
Versions: MacOS Big Sur (11.2), MySQL Workbench 8.0

I am using MySQL Workbench 6.3.7 build 1199 CE (64 bits) on a Mac with OS X Yosemite 10.10.5. I am connecting to an Amazon RDS MySQL instance.

When I enter a simple query such as

<pre><code>select * from `devices`;
</code></pre>

and click the lightning-bolt-with-cursor icon, the query starts, indicated by the spinner activating next to the "SQL File 4" tab in the following screenshot. However, the query doesn't complete and it just hangs. The white-hand-in-red-stop-sign icon is disabled.

<a href="https://i.stack.imgur.com/rtr7a.png"><img src="https://i.stack.imgur.com/rtr7a.png" alt="screenshot of MySQL Workbench in hung state"></a>

I can only force quit MySQL Workbench from this point on. If I try to do a regular quit, nothing happens.

How can I consistently run a simple query on my database? Sometimes it works (maybe 10% of the time), but it mostly just hangs.

MySQL Workbench 6.3 (Mac) hangs on simple queries

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

 我使用的是MySQL Workbench 6.3.7 build 1199CE (64位)，安装了OS Yosemite10.10.5。我正在连接一个Amazon RDS MySQL实例。 当我输入一个简单的查询时，比如 select * from `devices`; 然后单击带有光标的闪电图标，查询开始，由下面屏...

问MySQL Workbench 6.3 (Mac)在简单查询时挂起
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL Workbench 6.3 (Mac)在简单查询时挂起EN