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

user_1571610 0
Viewed 10442

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 able to do

mysql_secure_installation

which throws

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

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
user_5419620

Like @sbkrogers says, must to remove the line, but since I use Homebrew to install mysql@5.7:

  1. My file is located on /opt/homebrew/etc/my.cnf. Where remove mysqlx-bind-address = 127.0.0.1

  2. After the first aborted installation, following folders need to be deleted:

    • /opt/homebrew/Cellar/mysql@5.7
    • /opt/homebrew/var/mysql

  3. ...then try to install again. brew install mysql

  4. After the installation was success, restart terminal

user_109060120
Related