rpm方式安装mysql8

142 阅读1分钟

官网:选择自己需要的版本 downloads.mysql.com/archives/co…

1.移除mariadb

#查找
rpm -qa|grep mariadb
#移除
rpm -e --nodeps mariadb-libs

2.安装mysql

上传tar包到/opt下,并解压缩mysql离线安装包

tar xf mysql-8.0.30-1.el8.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.30-1.el8.x86_64.rpm
dnf -y install perl 
rpm -ivh mysql-community-server-8.0.30-1.el8.x86_64.rpm

systemctl enable mysqld --now

3.修改密码

# 获取初始密码
temp_password=$(grep 'temporary password' /var/log/mysqld.log | awk '{print $NF}')

#修改密码
mysql --connect-expired-password -uroot -p"$temp_password" <<EOF
ALTER USER 'root'@'localhost' IDENTIFIED BY '要修改的密码,必须符合复杂度';
EOF

#重启服务
systemctl restart mysqld