mysql centos7找不到pid_linux centos7 mysql 启动失败

/var/log/mysql.err1710119:42:53[Note]Plugin'FEDERATED'isdisabled.1710119:42:53InnoDB:TheInnoDBmemoryheapisdisabled1710119:42:53InnoDB:Mutexesandrw_locksuseGCCatomicbuilti...

/var/log/mysql.err

171011 9:42:53 [Note] Plugin 'FEDERATED' is disabled.

171011 9:42:53 InnoDB: The InnoDB memory heap is disabled

171011 9:42:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins

171011 9:42:53 InnoDB: Compressed tables use zlib 1.2.3

171011 9:42:53 InnoDB: Using Linux native AIO

171011 9:42:53 InnoDB: Initializing buffer pool, size = 2.9G

171011 9:42:54 InnoDB: Completed initialization of buffer pool

171011 9:42:54 InnoDB: highest supported file format is Barracuda.

171011 9:42:55 InnoDB: Waiting for the background threads to start

171011 9:42:56 InnoDB: 5.5.57 started; log sequence number 1595675

171011 9:42:56 [ERROR] /usr/sbin/mysqld: unknown option '--risks'

171011 9:42:56 [ERROR] Aborting

171011 9:42:56 InnoDB: Starting shutdown...

171011 9:42:57 InnoDB: Shutdown completed; log sequence number 1595675

171011 9:42:57 [Note] /usr/sbin/mysqld: Shutdown complete

systemctl status mysql.service

[root@localhost test]# systemctl status mysql.service

● mysql.service - LSB: start and stop MySQL

Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)

Active: failed (Result: exit-code) since Wed 2017-10-11 09:42:58 CST; 10min ago

Docs: man:systemd-sysv-generator(8)

Process: 851 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=1/FAILURE)

Oct 11 09:42:51 localhost.localdomain systemd[1]: Starting LSB: start and stop MySQL...

Oct 11 09:42:58 localhost.localdomain mysql[851]: Starting MySQL...... ERROR! The server quit without updating PID file (/var/lib/mysql/mysqld.pid).

Oct 11 09:42:58 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=1

Oct 11 09:42:58 localhost.localdomain systemd[1]: Failed to start LSB: start and stop MySQL.

Oct 11 09:42:58 localhost.localdomain systemd[1]: Unit mysql.service entered failed state.

Oct 11 09:42:58 localhost.localdomain systemd[1]: mysql.service failed.

手动创建PID并指明PID号 后可以运行 运行后pid 文件被自动删除了 然后restart 又是这个问题了 问题扎到了 我my.cnf 里有几行错了 谢谢了 !

展开

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值