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

最新推荐文章于 2024-07-04 16:14:05 发布

原创最新推荐文章于 2024-07-04 16:14:05 发布 · 3.8k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mysql报错

开发经验专栏收录该内容

52 篇文章

订阅专栏

本文记录了一次MySQL服务启动失败的问题及解决过程。错误提示包括文件未找到和权限问题，通过调整目录权限最终成功启动MySQL服务。

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