Search code examples
mysqlmacosinstallation

Warning: The post-install step did not complete successfully when trying to install mysql using brew in Mac OS High Sierra

Trying to install mysql5.7 with brew on Mac OS High Sierra.

I have used the following commands:

sudo rm -rf /usr/local/var/mysql/
brew install mysql@5.7
brew postinstall mysql@5.7

Got the below errors:

2019-10-05T02:59:24.136970Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-10-05T02:59:24.138997Z 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2019-10-05T02:59:24.215676Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-10-05T02:59:24.232279Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-10-05T02:59:24.286214Z 0 [ERROR] unknown variable 'mysqlx-bind-address=127.0.0.1'
2019-10-05T02:59:24.286281Z 0 [ERROR] Aborting

Because of which I couldn't do:

mysql_secure_installation

which throws:

Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Solution

  • If you are able to find your my.cnf file (for me, it was in /usr/local/etc/my.cnf) you should remove the below line:

    mysqlx-bind-address = 127.0.0.1