blocks|key|2185460|text|我想我想出来了！这可能与密码的长度有关。一开始，为了方便起见，我只是设置了一个单一字符的密码，但当尝试将Eclipse报告软件与MySQL连接时，我遇到了一些问题。我更改了密码以使其更长，这解决了BIRT的问题，但更好的是，它似乎也解决了Workbench的问题！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2185461|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I think I figured it out! It could have something to do with the length of the password. At first I had just set it up with a single-character password for my convenience, but I ran into some issues when trying to connect the Eclipse BIRT reporting software with MySQL. I changed the password to make it longer, and that solved the problem with BIRT, but even better, it seems to have solved the problem with Workbench as well!

blocks|key|456643|text|我也有过同样的问题。我发现，在尝试运行简单的select语句时，打开的第一个实例继续旋转，似乎没有理由。在不关闭所有MySQL工作台的情况下，甚至不能关闭打开的选项卡。但是，如果您再次打开同一个实例，它似乎运行良好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|456644|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had this same issue. I found out that the first instance you open just continues to spin when trying to run simple select statements with what seems to be no reason. You cannot even close the tab once it is open without closing all of MySQL Workbench. However, if you open up the same instance again it seems to work fine.

blocks|key|265959|text|在我的例子中，Mac版本的MySQL工作台社区6.3.8CE构建了1228+(64位)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|265960|sudo+chown+-R+<USER>:staff+/Applications/MySQLWorkbench.app|code-block|syntax|javascript|265961|应用，解决了问题。|265962|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

In my case MySQL Workbench Community (GPL) for Mac OS X version 6.3.8 CE build 1228 (64 bit) with 

<pre><code>sudo chown -R &lt;USER&gt;:staff /Applications/MySQLWorkbench.app
</code></pre>

applied, fixed the problem.

blocks|key|456893|text|当我将版本降级到6.1.7+:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|456894|​|456895|📷|atomic|offset|length|456896|456897|但是缺少了旧版本中的快速操作图标功能:(|456898|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/5c76862604363c6371b6afc4ea9b0b74.png|imageAlt^0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@$G|X|H|Y|1|Z]]|A|$]]|$1|I|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

It worked for me when I downgraded the version to 6.1.7 :)

<a href="https://i.stack.imgur.com/ZaAbN.png" rel="nofollow"><img src="https://i.stack.imgur.com/ZaAbN.png" alt="enter image description here"></a>

But missing the quick action icons functionality in the old version :(

blocks|key|2185733|text|MySQL+Workbench+6.3.9现在可用(2/14/17)，它似乎解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2185734|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

MySQL Workbench 6.3.9 is available now (2/14/17) and appears to fix this problem.

blocks|key|456602|text|我也有同样的问题，但它是在重新启动后修复的。也许值得一试。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|456603|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had the same problem, but it was fixed after a reboot. Maybe worth trying.

blocks|key|456922|text|我有同样的问题，我挖掘了所有的互联网，但没有解决问题，然后我决定使用另一个工作台。我发现了"DBeaver+-通用数据库管理器“的官方网站：http://dbeaver.jkiss.org/和免费的，它是可以容忍的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|456923|entityMap|0|LINK|mutability|MUTABLE|url|http://dbeaver.jkiss.org/^0|1Y|P|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I had same problem and I digged all internet but dont resolved problem and then I decided use another workbench. I found "DBeaver - Universal Database Manager" official site : <a href="http://dbeaver.jkiss.org/" rel="nofollow noreferrer">http://dbeaver.jkiss.org/</a> and free and its tolerable.

blocks|key|457019|text|我在"macOS+10.12.3“安装的macOS版本6.3.8CE+build+1228+(64位)的MySQL工作台社区(GPL)上也遇到了同样的问题。我发现问题来自于MSQL设置为“默认目标MySQL版本”的错误版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|457020|步骤1:打开终端并检查MYSQL版本的|offset|length|style|BOLD|457021|mysql+--version|code-block|syntax|javascript|457022|我的机器：|457023|mysql+14.14+5.7.9__，用于osx10.9+(x86_64)，使用EditLine包装器|blockquote|457024|步骤2:打开MySQL工作台工具，然后转到菜单上苹果图标附近的"MYSQLWorkbench“|457025|步骤3:工作台首选项->+->+MySQL+->默认目标MySQL版本:+5.6|457026|步骤4:将当前默认值从5.6更改为5.7.9，然后确定步骤5:+MYSQLWorkbench+->退出->打开并检查结果.|457027|希望这能帮到别人。|457028|entityMap^0|0|0|J|0|0|0|C|5|0|0|L|0|0|14|0|0|1P|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@$D|13|E|14|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|15|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|16|8|@]|9|@]|A|$]]|$1|O|3|P|5|Q|7|17|8|@$D|18|E|19|F|G]]|9|@]|A|$]]|$1|R|3|S|5|6|7|1A|8|@$D|1B|E|1C|F|G]]|9|@]|A|$]]|$1|T|3|U|5|6|7|1D|8|@$D|1E|E|1F|F|G]]|9|@]|A|$]]|$1|V|3|W|5|6|7|1G|8|@$D|1H|E|1I|F|G]]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1J|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|10|$]]

I got same problem on "macOS 10.12.3" installed "MySQL Workbench Community (GPL) for Mac OS X version 6.3.8 CE build 1228 (64 bit)". It's always not responding after working around I found that problem comes from MSQL Workbench is set "Default Target MySQL Version" wrong version.

Step 1: open Terminal and check your MYSQL Server version 

<pre><code>mysql --version
</code></pre>

My machine: 

<blockquote>
 mysql Ver 14.14 Distrib 5.7.9, for osx10.9 (x86_64) using EditLine
 wrapper
</blockquote>

Step 2: Open MySQL Workbench tool then go to "MYSQLWorkbench" near Apple icon on menu

Step 3: Workbench Preferences -> Modeling -> MySQL -> Default Target MySQL Version: 5.6

Step 4: Change current default from 5.6 into 5.7.9 then OK
Step 5: MYSQLWorkbench -> Quit -> Open and check result.

Hope this help someone.

blocks|key|2185395|text|如果Jonathan的解决方案不能解决您的问题，请尝试重新打开同一个mysql实例，这对我是有效的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2185396|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Try to reopen the same mysql instance if the Jonathan's solution doesn't resolve your problem, this works for me.

blocks|key|2185417|text|我把我的从6.2.12升级到6.3.7，这对我很有帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2185418|我将注意到，为同一个实例打开第二个选项卡确实有效，但我发现我永远无法关闭第一个选项卡，它总是挂在任何查询上。还有..。尝试甚至退出应用程序将需要我强制-杀死它。在我看来，这不是一个可以接受的流程，所以升级对我来说很重要。我的猜测是，安装正确设置权限或用户组。|2185419|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I upgraded mine from 6.2.12 to 6.3.7 and that did the trick for me. 

I will note that opening a 2nd tab for the same instance did work, but I found that I could never close the first and it always hung on any query. And... trying even quit out of the app would require me to force-kill it. Not an acceptable flow in my opinion, so the upgrade was important to me. My guess is that the install correctly set permissions or user groups.

blocks|key|456748|text|这个问题似乎只有在使用MySQL工作台时才会发生。如果使用命令行客户机(/usr/local/+mysql+/bin/mysql)，则可以从mysql服务器获得答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|456749|尝试这样做:+1.执行/usr/local/mysql/bin/mysql+--user=YOUR_USER+--password=YOUR_PASSWORD+2.键入"use+sys;“3.键入"select+*+from+sys_config;”|456750|现在，我们必须找出工作台不工作的原因。|456751|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

This problem seems to be happening only when using MySQL Workbench.
If you use the command line client (/usr/local/mysql/bin/mysql), it is possible to get an answer from mysql server.

Try to do it:
1. Execute /usr/local/mysql/bin/mysql --user=YOUR_USER --password=YOUR_PASSWORD
2. Type "use sys;"
3. Type "select * from sys_config;"

Now, we have to find out why the Workbench doesn't work.

blocks|key|2185625|text|尝试使用127.0.0.1作为主机名，而不是localhost。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2185626|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

try using 127.0.0.1 as the hostname, instead of localhost.

blocks|key|456961|text|在我的Mac上，有时当我试图运行查询或关闭几个选项卡时，我会得到无限的旋转器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|456962|对我起作用的是删除自动保存的工作区。删除~/Library/Application\+Support/MySQL/Workbench/sql_workspaces中的所有条目|offset|length|style|CODE|456963|或者你认识的那些人引起了问题。删除这些内容后，它可以很好地工作。|456964|entityMap^0|0|K|1P|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

On my Mac, sometimes I get the infinite spinner when I try to run queries or close several tabs. 

What worked for me was deleting the auto saved workspaces. Delete all entries in 
<code>~/Library/Application\ Support/MySQL/Workbench/sql_workspaces</code> or the ones that you know are causing a problem. It works fine after deleting these.

blocks|key|2185753|text|在没有工作台的MacOS+10.12.6上，Ver+8.0.23似乎对我工作正常。我喜欢SequelPro。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2185754|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Ver 8.0.23 seems to work ok for me on MacOS 10.12.6 without workbench. I like SequelPro.

blocks|key|457083|text|mysql工作台版本6.3.10适用于Sierra10.12.6。一般来说，向后兼容性是存在的，即较新的硬件可以运行较旧版本的软件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|457084|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

mysql workbench version 6.3.10 worked for sierra 10.12.6.
Generally, backward compatibility exists i.e., newer hardware
can operate reasonably older version of software

Does anybody know of any compatibility issues or quirks with MySQL Community Server/Workbench on macOS Sierra? I recently did an installation on a Mac that had never held MySQL before and it doesn't seem to be working correctly. (Now maybe I just set it up wrong, but the since the installer offers no advanced options that doesn't seem to be the case.) 

I can create schemas and tables, but when I go to actually query the table nothing happens. The activity indicator spins endlessly. I took a look at Activity Monitor and it doesn't show <code>mysqld</code> actually doing anything—the whole setup just appears to be deadlocked. Any ideas?

Here's what I'm trying to use: 

<ul>
<li>MySQL Community Server 5.7.15</li>
<li>MySQL Workbench 6.3.7</li>
<li>macOS Sierra 10.12 (16A323)</li>
</ul>

MySQL Compatibility with MacOS Sierra

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

有没有人知道与MySQL社区服务器/工作台在macOS塞拉利昂上的兼容性问题或怪癖？最近，我在一台从来没有安装过MySQL的Mac上安装了一个设备，它似乎没有正常工作。(现在我可能把它设置错了，但installer提供的高级选项似乎不是这样的。)我可以创建模式和表，但是当我实际查询表时，什么都不会发生。活动指示器无休止地旋转。我看了一下活动监视器( Activity )，它没有显示mysqld实际

问MySQL与MacOS Sierra的兼容性
EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL与MacOS Sierra的兼容性EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL与MacOS Sierra的兼容性
EN