linux安装mysql8.0填坑日记

• • 问题

从下载安装包到配置都没问题,然而到了启动就直接GG

Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql80/data/localhost.localdomain.pid).
启动就一直报这个错误,然后查不出什么原因,查看日志发现可能是配置有问题,就修改配置,重新启动,还是这个问题.

[mysqld]
basedir=/usr/local/mysql80
datadir=/usr/local/mysql80/data
socket=/tmp/mysql.sock
pid-file=/usr/local/mysql80/data/mariadb.pid
port = 3306
max_connections=400
innodb_file_per_table=1
character_set_server=utf8
# Disabling symbolic-links is recommended to prevent assorted security risks
# symbolic-links=0  注意这里!!!一定要注释掉!!!
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

最后,直接删除data文件夹,重新初始化就可以了

https://blog.csdn.net/liurui50/article/details/105478422/