刚安装好的MySQL,执行/usr/sbin/mysqld --initialize-insecure --user=mysql时报错,内容如下:
2017-02-19T07:52:53.807647Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
2017-02-19T07:52:53.809065Z 0 [ERROR] –initialize specified but the data directory has files in it. Aborting.
2017-02-19T07:52:53.809095Z 0 [ERROR] Aborting
原因:mysql中的data目录已经有数据了,解决方案:
datadir=/var/lib/mysql, 这个是data保存目录,进入/var/lib/mysql后,查看到确实有数据:进入/var/lib文件执行 mv mysql mysql.bak