阿里云 centos mysql Please read “Security” section of the manual to find out how to run mysqld as root 解决

  • A+
所属分类:数据库

今天修改了mysql配置,需要重启服务,我先shutdown了mysql,然后启动的时候就起不起来了。

[root@iZuf61y15z8ms9gcgjafoiZ etc]# mysqld start
2018-11-27T09:32:41.791285Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-27T09:32:41.792776Z 0 [Note] mysqld (mysqld 5.7.16) starting as process 16128 ...
2018-11-27T09:32:41.794199Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2018-11-27T09:32:41.794254Z 0 [ERROR] Aborting

2018-11-27T09:32:41.794278Z 0 [Note] Binlog end
2018-11-27T09:32:41.794425Z 0 [Note] mysqld: Shutdown complete

红色字体标出来的错误提示,意思就是说使用root用户启动mysql 是受到安全条例限制的,让你去查看手册的安全相关部分。

怎么解决呢,很简单。使用systemctl 命令来操作。启动,停止,重启,看状态一条龙。

systemctl (start|stop|restart|status) mysqld



  • 我的微信
  • 这是我的微信扫一扫
  • weinxin
  • 我的微信公众号
  • 我的微信公众号扫一扫
  • weinxin

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: