求助!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)
```