MySQL 与 MacOS Sierra 的兼容性

MySQL Compatibility with MacOS Sierra

提问by Bob

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

有人知道 macOS Sierra 上 MySQL 社区服务器/工作台的任何兼容性问题或怪癖吗？我最近在以前从未安装过 MySQL 的 Mac 上进行了安装，但它似乎无法正常工作。（现在也许我只是设置错误，但由于安装程序没有提供似乎并非如此的高级选项。）

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 mysqldactually doing anything—the whole setup just appears to be deadlocked. Any ideas?

我可以创建模式和表，但是当我去实际查询表时什么也没有发生。活动指示器无休止地旋转。我查看了 Activity Monitor，它没有显示mysqld实际执行任何操作——整个设置似乎陷入僵局。有任何想法吗？

Here's what I'm trying to use:

这是我正在尝试使用的内容：

• MySQL Community Server 5.7.15
• MySQL Workbench 6.3.7
• macOS Sierra 10.12 (16A323)

• MySQL 社区服务器 5.7.15
• MySQL 工作台 6.3.7
• macOS Sierra 10.12 (16A323)

采纳答案by Bob

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!

我想我想通了！它可能与密码的长度有关。起初，为了方便起见，我只是使用单字符密码对其进行了设置，但是在尝试将 Eclipse BIRT 报告软件与 MySQL 连接时遇到了一些问题。我更改了密码以使其更长，这解决了 BIRT 的问题，但更好的是，它似乎也解决了 Workbench 的问题！

回答by Jonathan

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.

我有同样的问题。我发现当您尝试运行简单的 select 语句时，您打开的第一个实例只是继续旋转，而这似乎没有任何原因。在不关闭所有 MySQL Workbench 的情况下，您甚至无法在打开选项卡后将其关闭。但是，如果您再次打开同一个实例，它似乎工作正常。

回答by gmo

UPDATE!

macOS High Sierra needsMySQL Workbench 6.3.10

See changelogfor 6.3.10 version

更新！

macOS High Sierra需要MySQL Workbench 6.3.10

请参阅6.3.10 版本的变更日志

---

---

SOLVED in version 6.3.9

已在 6.3.9 版中解决

Tested on:

测试：

macOS Sierra
Version 10.12.3 (16D32)

macOS Sierra
版本 10.12.3 (16D32)

MySQL

MySQL

Workbench 6.3.9
Version 6.3.9 build 10690321 CE (64 bits) Community
----> OK

Workbench 6.3.9
版本 6.3.9 build 10690321 CE（64 位）社区
----> OK

Download: MySQL Workbench 6.3.9
^{Packages for Sierra (10.12) are compatible with El Capitan (10.11) and are Yosemite (10.10)}

下载：^{适用于 Sierra (10.12) 的}MySQL Workbench 6.3.9
^{软件包与 El Capitan (10.11) 兼容并且是 Yosemite (10.10)}

Changelog: ^{among others...}

• In some cases, executing a query caused MySQL Workbench to become unresponsive when the host was macOS Sierra. (Bug #25036263, Bug #83658)

更新日志：^{除其他外...}

• 在某些情况下，当主机是 macOS Sierra 时，执行查询会导致 MySQL Workbench 无响应。（错误＃25036263，错误＃83658）

---

---

下面代码片段中的原始答案：

I ***temporary*** solved changed the ***group*** of the application.  

I tried everything, uninstalling, reinstall, change many settings... finally I thought that must be something with the security... was not normal, I check firewall rules, nothing... And just in case, I try with file permission and it was there.

I was installed in the ***admin group***.  
Changed to ***staff*** solve the problem.  

    $ sudo chown <USER>:staff /Applications/MySQLWorkbench.app

> <sup>Where of course, `<USER>` is **your** username</sup>

    Ex.
    $ sudo chown gmo:staff /Applications/MySQLWorkbench.app

Tested and working!

 - Go back to admin group... problem came back.
 - Changed to staff again... problem solved.

I hope this is a global solution, please check yours.


###Edit:
Solution not stable, problem came back after a few attempts.  
Try with `root:admin`, the same... 

---

### UPDATE
*`Workaround until new version is release`*

Roll back to 6.2 version and working good.

Tested on:
> macOS Sierra  
> Version 10.12 (16A323)

MySQL
> Workbench 6.3  
> Version 6.3.7 build 1199 CE (64 bits) Community  
> http://dev.mysql.com/downloads/workbench/6.3.html  
> `----> FAILS`  
> <sup>*Randomly, even changing group or creating new instances.*</sup>

> Workbench 6.2  
> Version 6.2.5.0 build 397 (32 bits) Community  
> http://dev.mysql.com/downloads/workbench/6.2.html  
> `----> OK`  
> <sup>*Work as expected.*</sup>

回答by Vladimir Trifonov

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

在我的情况下，Mac OS X 版本 6.3.8 CE build 1228（64 位）的 MySQL Workbench Community (GPL) 与

sudo chown -R <USER>:staff /Applications/MySQLWorkbench.app

applied, fixed the problem.

应用，解决了问题。

回答by Gagandeep Gambhir

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

当我将版本降级到 6.1.7 时，它对我有用:)

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

但是缺少旧版本中的快速操作图标功能:(

回答by unknownrisk

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

MySQL Workbench 6.3.9 现已推出（2/14/17）并且似乎解决了这个问题。

回答by David Doan

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.

我在“macOS 10.12.3”上遇到了同样的问题，安装了“MySQL Workbench Community (GPL) for Mac OS X version 6.3.8 CE build 1228 (64 bit)”。解决后总是没有响应我发现问题来自 MSQL Workbench 设置为“默认目标 MySQL 版本”错误版本。

Step 1: open Terminal and check your MYSQL Server version

第 1 步：打开终端并检查您的 MYSQL Server 版本

mysql --version

My machine:

我的机器：

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

mysql Ver 14.14 Distrib 5.7.9，用于 osx10.9 (x86_64) 使用 EditLine 包装器

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

第 2 步：打开 MySQL Workbench 工具，然后转到菜单上 Apple 图标附近的“MYSQLWorkbench”

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

第 3 步：工作台首选项 -> 建模 -> MySQL -> 默认目标 MySQL 版本：5.6

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

步骤 4：将当前默认值从 5.6 更改为 5.7.9 然后确定 步骤 5：MYSQLWorkbench -> 退出 -> 打开并检查结果。

Hope this help someone.

希望这有助于某人。

回答by katsu

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 : http://dbeaver.jkiss.org/and free and its tolerable.

我遇到了同样的问题，我挖掘了所有互联网，但没有解决问题，然后我决定使用另一个工作台。我找到了“DBeaver - 通用数据库管理器”官方网站：http://dbeaver.jkiss.org/并且免费且可以接受。

回答by Henrik Sandberg

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

我有同样的问题，但它在重新启动后修复。也许值得一试。

回答by Mtthc

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

如果 Jonathan 的解决方案不能解决您的问题，请尝试重新打开同一个 mysql 实例，这对我有用。