mysql centos多个server安装

yum文件存放目录
/etc/yum.repos.d/

设置无密码登录
ssh-keygen -t dsa
for i in 11 12 13 14;do ssh-copy-id root@172.25.0.$i;done

安装软件
for i in 11 12 13 14;do ssh root@172.25.0.$i "yum install -y wget vim net-tools";done

复制yum源文件到各个server
for i in 11 12 13 14;scp mysql-5.7.repo root@172.25.0.$i:/etc/yum.repos.d/; done

检查yum中mysql文件
yum list | grep mysql

检查mariadb安装
rpm -qa | grep mariadb
rpm -q mariadb-libs

卸载mariadb
for i in 11 12 13 14;ssh root@172.25.0.$i "rpm -e --nodeps mariadb-libs" ; done

安装mysql
for i in 11 12 13 14;ssh root@172.25.0.$i "yum install -y mysql-community-server" ; done

关闭防火墙
for i in 11 12 13 14;do ssh root@172.25.0.$i "systemctl stop firewalld;setenforce@";done

启动mysql服务
systemctl start mysqld

查找到临时密码
grep password /var/log/mysqld.log

修改密码
mysqladmin -uroot -p'xxxxxx' password 'NewPassword'

登录mysql
mysql -uroot -p'NewPassword'










请使用浏览器的分享功能分享到微信等