mysql - brew mysql安装，posinstall步骤出错

Question

我一直在尝试安装 mysql。我从我的系统中删除了所有安装的 mysql。按照以下步骤进行

• brew 删除 mysql
• brew 清理
• 跟随 this link 卸载了所有的 mysql。
• 是否完整搜索了任何 mysql 相关文件
• 重启电脑

现在全新安装 brew install mysql 并且在 hte postinstall 步骤中出现错误。终端输出:

sahilgandhi:~ Sahil$ brew install mysql

==> Downloading https://homebrew.bintray.com/bottles/mysql-5.7.9.el_capitan.bott
Already downloaded: /Library/Caches/Homebrew/mysql-5.7.9.el_capitan.bottle.tar.gz
==> Pouring mysql-5.7.9.el_capitan.bottle.tar.gz
==> /usr/local/Cellar/mysql/5.7.9/bin/mysqld --initialize --user=Sahil --basedir
Last 15 lines from /Users/Sahil/Library/Logs/Homebrew/mysql/01.mysqld:
--initialize
--user=Sahil
--basedir=/usr/local/Cellar/mysql/5.7.9
--datadir=/usr/local/var/mysql
--tmpdir=/tmp

2015-11-15T08:04:05.376664Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-15T08:04:05.387829Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2015-11-15T08:04:05.387847Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2015-11-15T08:04:05.551157Z 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2015-11-15T08:04:08.618316Z 0 [Warning] InnoDB: New log files created, LSN=45790
2015-11-15T08:04:09.125841Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2015-11-15T08:04:09.403537Z 0 [ERROR] unknown variable 'thread_concurrency=4'
2015-11-15T08:04:09.403591Z 0 [ERROR] Aborting

Warning: The post-install step did not complete successfully
You can try again using `brew postinstall mysql`
==> Caveats
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.

To connect:
mysql -uroot

To have launchd start mysql at login:
  ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
Then to load mysql now:
  launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
Or, if you don't want/need launchctl, you can just run:
  mysql.server start
==> Summary
🍺  /usr/local/Cellar/mysql/5.7.9: 12629 files, 464M

我尝试运行 brew postinstall mysql 但这也无济于事。输出:

sahilgandhi:~ Sahil$ brew postinstall mysql
==> /usr/local/Cellar/mysql/5.7.9/bin/mysqld --initialize --user=Sahil --basedir
Last 15 lines from /Users/Sahil/Library/Logs/Homebrew/mysql/01.mysqld:
2015-11-15 14:01:55 +0530

/usr/local/Cellar/mysql/5.7.9/bin/mysqld
--initialize
--user=Sahil
--basedir=/usr/local/Cellar/mysql/5.7.9
--datadir=/usr/local/var/mysql
--tmpdir=/tmp

2015-11-15T08:31:55.974794Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-15T08:31:55.974968Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2015-11-15T08:31:55.974974Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2015-11-15T08:31:56.054515Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2015-11-15T08:31:56.054569Z 0 [ERROR] Aborting


READ THIS: https://git.io/brew-troubleshooting

These open issues may also help:
groonga-normalizer-mysql: avoid sandbox problem https://github.com/Homebrew/homebrew/pull/45889
mysql: Add patches for memcached build failure https://github.com/Homebrew/homebrew/pull/44650
percona-toolkit does not depend on MySQL https://github.com/Homebrew/homebrew/pull/41595
no memcached support in most recent MySQL brew port https://github.com/Homebrew/homebrew/issues/42935
MySQL not woking with --datadir option https://github.com/Homebrew/homebrew/issues/41160
mysql-proxy 0.8.5 failed to build with mysql-connector-c 6.1.6 https://github.com/Homebrew/homebrew/issues/41263
mysql-connector-c++ cannot build with mariadb  https://github.com/Homebrew/homebrew/issues/34578
mysql failed to build on 10.10 https://github.com/Homebrew/homebrew/issues/33448
Packages with --with-mysql option not satisfied by mariadb https://github.com/Homebrew/homebrew/issues/32973

Answer 1

我自己遇到过这个。在 MySQL 5.7.x 中，thread_concurrency 变量被移除。 (它已被弃用，这会导致警告，但是，除非您查看日志，否则您不会看到它。)错误发生是因为存在设置 thread_concurrency 的 my.cnf 文件。

遗憾的是，my.cnf 可能存在于多个地方。我建议首先查看 /usr/local/etc(这是我找到我的地方)。也可以写成~/.my.cnf。如果您在这些位置没有找到它，请考虑执行

找到 . -name my.cnf -print

来自 /usr。