执行mysqld --initialize后报错

报错内容:

SRE实战 互联网时代守护先锋,助力企业售后服务体系运筹帷幄!一键直达领取阿里云限量特价优惠。

019-04-24 18:07:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-04-24 18:07:59 0 [Note] mysqld (mysqld 5.6.43) starting as process 16404 ...
2019-04-24 18:07:59 16404 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2019-04-24 18:07:59 16404 [ERROR] Aborting

2019-04-24 18:07:59 16404 [Note] Binlog end
2019-04-24 18:07:59 16404 [Note] mysqld: Shutdown complete

 

解决办法:

使用vi /etc/my.cnf ,加上两行:

explicit_defaults_for_timestamp=true

user=mysql                          (指定mysql用户来启动mysql服务)

 

扫码关注我们
微信号:SRE实战
拒绝背锅 运筹帷幄