centos 一键安装mysql8.0和备份工具xtrabackup
原创
©著作权归作者所有:来自51CTO博客作者liuyunshengsir的原创作品,请联系作者获取转载授权,否则将追究法律责任
脚本
#!/usr/bin/env bash
rm -f /etc/my.cnf
rm -rf /etc/my.cnf.d
rm -rf mysql
yum install -y epel-release
yum install -y wget
wget https://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum install -y mysql-community-server-8.0.25
systemctl enable mysqld.service
cat /var/log/mysqld.log | grep password
yum -y install mysql-community-libs-compat.x86_64
yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm
yum install -y percona-xtrabackup-80.x86_64
systemctl start mysqld.service
修改密码
获取初始密码登录mysql
[root@lys-mysql-test001 ~]# cat /var/log/mysqld.log | grep password
2022-04-14T06:49:57.151045Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ed>1Rfx?
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'AAbb1122!!';