mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid1 ended

来源：互联网发布：网络韩语翻译兼职编辑：程序博客网时间：2024/05/29 21:33

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

0 0