求助！Mac系统中错误的修改了my.cnf后, 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)