centos7安装mysql5.7错误解决

安装教程:https://www.cnblogs.com/jingh...
第四步启动服务
报错

Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.

查看报错日志 /usr/log/mysql.log

Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

解决办法:
查看配置文件:my.cnf
cat /etc/my.cnf
image.png
datadir=/var/lib/mysql
进入到该目录下
删除该目录下的所有文件,(mysql启动的时候会自动生成)
删除后执行初始化操作

mysqld --initialize --datadir=/var/lib/mysql

查看该目录下的文件
image.png
关闭mysql服务

service mysqld stop

启动mysql

systemctl start mysqld.service

启动成功
查看状态

systemctl status mysqld.service

image.png

评论

暂无评论