首先看日志文件:
tail -f /usr/local/mysql/data/mysqld.local.err
发现配置plist配置文件丢失了,是下面这个路径的文件
/Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
这是8.0.13版本的mysql正常的此文件的内容:
Labelcom.oracle.oss.mysql.mysqld
ProcessTypeInteractive
Disabled
RunAtLoad
KeepAlive
SessionCreate
LaunchOnlyOnce
UserName_mysql
GroupName_mysql
ExitTimeOut600
Program/usr/local/mysql/bin/mysqld
ProgramArguments
/usr/local/mysql/bin/mysqld
--user=_mysql
--basedir=/usr/local/mysql
--datadir=/usr/local/mysql/data
--plugin-dir=/usr/local/mysql/lib/plugin
--log-error=/usr/local/mysql/data/mysqld.local.err
--pid-file=/usr/local/mysql/data/mysqld.local.pid
--keyring-file-data=/usr/local/mysql/keyring/keyring
--early-plugin-load=keyring_file=keyring_file.so
WorkingDirectory/usr/local/mysql
除了这个问题以外,还发现数据目录下的文件无权限读写了,进入到数据目录,使用chmod命令修改权限,我这里为了方面就统一设置为了755
sudo chmod -R 775 /usr/local/mysql/data