mysql安装遇到的错误
2020-12-22T08:51:50.834990Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 27380
2020-12-22T08:51:50.869916Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-12-22T08:51:50.870114Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-12-22T08:51:50.870142Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-12-22T08:51:50.870892Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.
解决办法如下:
在 /etc/my.cnf查看 datadir=/var/lib/mysql指定的目录
使用 rm -rf /var/lib/mysql 删除该目录
初始化
命令:
mysqld --initialize --console
目录授权
命令:
chown -R mysql:mysql /var/lib/mysql/
启动mysql服务
命令:
systemctl start mysqld
命令:
systemctl status mysqld
重新启动mysql服务启动成功