重做 系统后,先挂载盘
参照
检查系统有没有安装mariadb
#检查mariadb是否安装
yum list installed | grep mariadb
#卸载mariadb
yum remove mariadb-libs
#删除文件
rm -rf /etc/my.cnf
rm -rf $(find / -name mysql)
安装mysql
wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
yum localinstall -y mysql57-community-release-el7-7.noarch.rpm
yum install -y mysql-community-server
最后报错了
Failing package is: mysql-community-client-5.7.40-1.el7.x86_64
GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
#在网上查
#原因:MySQL GPG 密钥已过期导致
#解决办法:执行一下命令,解决
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
#在重新安装
yum install -y mysql-community-server
启动修改密码
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql -u root -p
mysql> SET PASSWORD = PASSWORD('你的密码');
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
mysql> flush privileges;
-- 远程允许访问
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;