当前环境是:
mysql> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 5.7.16 |
| protocol_version | 10 |
| slave_type_conversions | |
| tls_version | TLSv1,TLSv1.1 |
| version | 5.7.16 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | osx10.11 |
+-------------------------+------------------------------+
当前mysql服务器数据文件的缺省位置:
mysql> show variables like '%datadir%';
+---------------+------------------------+
| Variable_name | Value |
+---------------+------------------------+
| datadir | /usr/local/mysql/data/ |
+---------------+------------------------+
1 row in set (0.01 sec)
之后,我停止了mysql的服务。开始编辑my.cnf
sh-3.2# cp /usr/local/opt/mysql/support-files/my-default.cnf /etc/my.cnf
sh-3.2# vi /etc/my.cnf
sh-3.2# grep -v ^# /etc/my.cnf
[mysqld]
log_bin=/usr/local/mysql/data/binarylog/binlog
log_bin_index=/usr/local/mysql/data/binarylog/binlog.index
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sh-3.2# mkdir -p /usr/local/mysql/data/binarylog
sh-3.2# chown -R mysql:mysql /usr/local/mysql/data/binarylog
之后,就无法启动mysql服务了。只有我删除etc文件夹下的my.cnf文件,才可以启动mysql服务。
希望得到大家的帮助,不胜感谢!