I am trying to install mysql. I removed all mysql installations from my system. Follow these steps.
- brew remove mysql
- brew cleaning
- Following is this link to delete all mysql.
- Completely searched for any mysql related files
- restart the computer.
Now a new installation brew install mysql, and I get an error in the hte step postinstall. Terminal output:
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
Last 15 lines from /Users/Sahil/Library/Logs/Homebrew/mysql/01.mysqld:
2015-11-15T08:04:05.376664Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use
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
I am trying to run brew postinstall mysql, but that does not help either. Exit:
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:
These open issues may also help:
groonga-normalizer-mysql: avoid sandbox problem https:
mysql: Add patches for memcached build failure https:
percona-toolkit does not depend on MySQL https:
no memcached support in most recent MySQL brew port https:
MySQL not woking with --datadir option https:
mysql-proxy 0.8.5 failed to build with mysql-connector-c 6.1.6 https:
mysql-connector-c++ cannot build with mariadb https:
mysql failed to build on 10.10 https:
Packages with --with-mysql option not satisfied by mariadb https:
source
share