开发者社区> 白及88> 正文

Starting MySQL. ERROR! The server quit without updating PID file

简介: <p><br></p> <p>前台开启:</p> <p><span style="color:#3366ff">[root@t1 x]# <strong>service mysqld start</strong></span></p> <p>Starting MySQL. ERROR! The server quit without updating PID file (/mydat
+关注继续查看


前台开启:

[root@t1 x]# service mysqld start

Starting MySQL. ERROR! The server quit without updating PID file (/mydata/data/t1.pid).


后台告警日志显示:

err文件表示:




160316 02:33:39 mysqld_safe Starting mysqld daemon with databases from /mydata/data
2016-03-16 02:33:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
^G/usr/local/mysql/bin/mysqld: File './master-bin.index' not found (Errcode: 13 - Permission denied)
2016-03-16 02:33:40 12415 [ERROR] Aborting


2016-03-16 02:33:40 12415 [Note] Binlog end
2016-03-16 02:33:40 12415 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete


160316 02:33:40 mysqld_safe mysqld from pid file /mydata/data/t1.pid ended
160316 02:34:05 mysqld_safe Starting mysqld daemon with databases from /mydata/data
2016-03-16 02:34:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
^G/usr/local/mysql/bin/mysqld: File './master-bin.index' not found (Errcode: 13 - Permission denied)
2016-03-16 02:34:05 12850 [ERROR] Aborting


2016-03-16 02:34:05 12850 [Note] Binlog end
2016-03-16 02:34:05 12850 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete


160316 02:34:05 mysqld_safe mysqld from pid file /mydata/data/t1.pid ended
160316 02:38:23 mysqld_safe Starting mysqld daemon with databases from /mydata/data
2016-03-16 02:38:23 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


解决办法 :


[root@t1 x]# ll /mydata/*
total 569380
-rw-r--r-- 1 root  root 482344960 Mar 16 02:32 ibdata1
-rw-r--r-- 1 root  root  50331648 Mar 16 02:32 ib_logfile0
-rw-r--r-- 1 root  root  50331648 Mar 16 02:32 ib_logfile1
drwxr-xr-x 2 root  root      4096 Mar 16 02:32 jishibang
drwxr-xr-x 2 root  root      4096 Mar 16 02:32 mysql
drwxr-xr-x 2 root  root      4096 Mar 16 02:32 performance_schema
-rw-r----- 1 mysql root      1220 Mar 16 02:34 t1.err
drwxr-xr-x 2 root  root      4096 Mar 16 02:32 test
-rw-r--r-- 1 root  root        23 Mar 16 02:32 xtrabackup_binlog_pos_innodb
-rw-r--r-- 1 root  root       662 Mar 16 02:32 xtrabackup_info

[root@t1 x]# chown -R mysql.mysql /mydata/data/

[root@t1 x]# service mysqld start
Starting MySQL. SUCCESS! 


[root@t1 x]# ll /mydata/*
total 569380


参考:

http://nameyjj.blog.51cto.com/788669/632302

http://blog.csdn.net/aidenliu/article/details/6586775

http://blog.csdn.net/u010098331/article/details/50752640

http://blog.csdn.net/u010098331/article/details/50849643

http://blog.csdn.net/u010098331/article/details/50752667

http://blog.csdn.net/u010098331/article/details/50752645



版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
Starting MySQL... ERROR! The server quit without updating PID file (/mydata/data/t1.pid).
<p>测试环境:</p> <p>mysql 5.6.25 (适用5.1.73 5.1.65)</p> <p><br></p> <p>1</p> <p>vim /etc/my.cnf</p> <p>pid-file=/mypid/t1.pid</p> <p><br></p> <p><br></p> <p>今天在备份的时候,我测试把mysql-log.index删除之后报错如下
2881 0
MySQL启动报:[ERROR] The server quit without updating PID file
修改配置后MySQL启动不了,报错: [root@localhost mysql]# service mysql restart Starting MySQL...[ERROR] The server quit without updating PID file (/usr/local/mysql/data/mysqld.pid). 看见这个不要惊慌,先把刚才修改的配置注释掉,看是不是配置有误!大部分是手误造成。
3395 0
Starting MySQL...The server quit without updating PID file [失败]lib/mysql/localhost.localdomain.pid).
重启了一下服务器,启动后就报以下错误了: Starting MySQL...The server quit without updating PID file [失败]lib/mysql/localhost.localdomain.pid). 纠结了很久没找到解决办法,后来突然想到修改了mysql的配置文件“/usr/my.cnf” 之前配置默认编码,在配置文件中添加了“default-character-set=utf8” 把这一句删除了,再启动mysql就好了。
2632 0
+关注
白及88
白及
文章
问答
文章排行榜
最热
最新
相关电子书
更多
Borgaonkar-New-Adventures-In-Spying-3G-And-4G-Users-Locate-Track-And-Monitor
立即下载
MySQL Replication: Latest Developments
立即下载
MongoShake -- Multi Active-Active and Cross-Region Disaster Recoverable MongoDB Service
立即下载