华为云centos 7 安装mysql

重做 系统后,先挂载盘 参照 CentOS 如何挂载硬盘 - 幻月无名 - 博客园 检查系统有没有安装mariadb #检查mariadb是否安装yu

重做 系统后,先挂载盘

参照

CentOS 如何挂载硬盘 - 幻月无名 - 博客园

检查系统有没有安装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.rpmyum localinstall -y mysql57-community-release-el7-7.noarch.rpmyum 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.servicegrep 'temporary password' /var/log/mysqld.logmysql -u root -pmysql> 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;