[mysql]
socket=/usr/local/mysql/mysql.sock[mysqld]
innodb_force_recovery = 1basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
pid-file =/usr/local/mysql/data/mysql.pid
socket=/usr/local/mysql/mysql.sock
tmpdir = /usr/local/mysql/tmp
log-error=/usr/local/mysql/logs/error.log
log=/usr/local/mysql/logs/mysql.log
关于my.cnf配置,尽量选择/etc/my.cnf 因为它是最先的。配置完后,查看哪些文件和路径是现在没有的,没有的先创建,赋权,赋权,赋权,赋权很总要有好些错都是没有赋权引起的。
例如:给datadir地址赋权,不然会报The server quit without updating PID file /usr/local/mysql/data/mysql.pid的错
chown -R mysql.mysql /usr/local/mysql/data
优先要配置log-error,这样启动报的错也能排查
log-error=/usr/local/mysql/logs/error.log