报错如下:
2021-06-29T00:20:57.116660Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-29T00:20:57.121588Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2021-06-29T00:20:57.122043Z 0 [ERROR] Aborting
或者如下:
[root@server1 mysql]# sudo ./support-files/mysql.server start
Starting MySQL.Logging to ‘/data/mysql/server1.err’.
… ERROR! The server quit without updating PID file (/data/mysql/server1.pid).
解决方式:
[root@server1 mysql]# ps -ax | grep mysql
杀死进程
然后rm -fr /data/mysql/*
mysqld --initialize --user=mysql
会生成密码待会要用:
接着:
sudo ./support-files/mysql.server start
mysql_secure_installation
输入刚才生成的密码:
然后让你输入新的密码就代表成功!!
不行的话 ,多试几次,因为本人试了七八次才成功:
顺序为:
先查看进程 杀死
然后删除/data/mysql/*文件
接着mysqld --initialize --user=mysql生成密码
接着
sudo ./support-files/mysql.server start 开启服务
接着:
安全初始化:
mysql_secure_installation