brew mysql 无法启动_求助！Mac下无法启动mysql8了

求助！mac上用brew安装的mysql8，出现了 “only_full_group_by“ 的错误，于是尝试修复，但是没有成功，反而 mysql -uroot -p无法启动, 就算将my.cnf改回来后一直提示ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (38)

目前my.cnf里面内容如下

Default Homebrew MySQL server config

[mysqld]

# Only allow connections from localhost

bind-address = 127.0.0.1

我执行mysql.server start, 报错信息如下：

./usr/local/Cellar/mysql/8.0.19/bin/mysqld_safe: line 144: /usr/local/var/mysql/APPLEdeAir.err: Permission denied

/usr/local/Cellar/mysql/8.0.19/bin/mysqld_safe: line 144: /usr/local/var/mysql/APPLEdeAir.err: Permission denied

/usr/local/Cellar/mysql/8.0.19/bin/mysqld_safe: line 199: /usr/local/var/mysql/APPLEdeAir.err: Permission denied

/usr/local/Cellar/mysql/8.0.19/bin/mysqld_safe: line 144: /usr/local/var/mysql/APPLEdeAir.err: Permission denied

ERROR! The server quit without updating PID file (/usr/local/var/mysql/APPLEdeAir.pid).

到err日志文件后，显示如下

2020-02-03T05:02:07.6NZ mysqld_safe Logging to '/usr/local/var/mysql/APPLEdeAir.err'.

2020-02-03T05:02:07.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql

2020-02-03T05:02:07.520013Z 0 [ERROR] [MY-000077] [Server] /usr/local/opt/mysql/bin/mysqld: Error while setting value 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.

2020-02-03T05:02:07.520275Z 0 [ERROR] [MY-010119] [Server] Aborting

2020-02-03T05:02:07.520413Z 0 [Note] [MY-010120] [Server] Binlog end

2020-02-03T05:02:07.6NZ mysqld_safe mysqld from pid file /usr/local/var/mysql/APPLEdeAir.pid ended

我的mysql使用brew 安装的，具体信息如下

Open source relational database management system

https://dev.mysql.com/doc/refman/8.0/en/

Conflicts with:

mariadb (because mysql, mariadb, and percona install the same binaries.)

percona-server (because mysql, mariadb, and percona install the same binaries.)

/usr/local/Cellar/mysql/8.0.19 (294 files, 293.9MB) *

Poured from bottle on 2020-02-03 at 16:06:48

From: https://mirrors.tuna.tsinghua.edu.cn/git/homebrew/homebrew-core.git/Formula/mysql.rb

==> Dependencies

Build: cmake ✘

Required: openssl@1.1 ✔, protobuf ✔

==> Requirements

Required: macOS >= 10.10 ✔

==> Caveats

We've installed your MySQL database without a root password. To secure it run:

mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:

mysql -uroot

To have launchd start mysql now and restart at login:

brew services start mysql

Or, if you don't want/need a background service you can just run:

mysql.server start

==> Analytics

install: 71,868 (30 days), 210,462 (90 days), 838,233 (365 days)

install-on-request: 68,082 (30 days), 199,896 (90 days), 784,746 (365 days)

build-error: 0 (30 days)

```