my.conf文件片段如下:
[mysqld1]
socket = /tmp/mysql.sock1
port = 3307
pid-file = /var/run/mysqld/mysqld.pid1
datadir = /var/lib/mysql1
user = mysql
log=/data/log/mysql/mysql1.log
log-slow-queries=/data/log/mysql/mysql_slowquery1.log
long_query_time=1
log-error=/data/log/mysql/mysql_error1.log
查看 mysql_error1.log 内容如下:
150227 16:35:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql1
150227 16:35:41 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
150227 16:35:41 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
150227 16:35:41 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
150227 16:35:41 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
/usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
150227 16:35:41 [ERROR] Aborting
150227 16:35:41 [Note] /usr/libexec/mysqld: Shutdown complete
150227 16:35:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid1 ended
这个说明是权限问题,之后 执行
# cd /var/lib/mysql
# chown mysql.mysql -R *
# service mysqld start