1. #!/bin/bash
    2. #MySql官方网址：https://www.mysql.com/
    3. #此脚本仅适用于Mysql5.7版本
    4. #version     V3.5.2(曜哥指导修订版)
    5. rpm -qa |grep mysql
    6. if [ $? -eq 0 ];then
    7. echo "MySQL已安装"
    8. else
    9. echo "MySQL未安装，准备开始安装...."
    10. rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-6.noarch.rpm    &>/dev/null    #下载官方Yum仓库
    11. sed -i 's/gpgcheck=1/gpgcheck=0/g' /etc/yum.repos.d/mysql-community.repo                #更改签名机制
    12. yum -y install yum-utils  &>/dev/null                                                              #Yum管理工具
    13. yum-config-manager --enable mysql57-community    &>/dev/null                                       #开启5.7版本
    14. yum-config-manager --disable mysql80-community   &>dev/null                                       #关闭8.0版本
    15. yum -y install mysql  mysql-server &>/dev/null
    16. if [ $? -eq 0 ];then
    17. echo "MySQL安装完成"
    18. read -p "请重置Mysql密码：" mia
    19. tcp=`cat /var/log/mysqld.log | grep  generated |awk '{print $11}'`
    20. mysqladmin -u root -p"$tcp" password "$mia"
    21. cat >> /etc/my.cnf <<eof
    22. log-bin  
    23. server-id=1 
    24. gtid_mode = ON  
    25. enforce_gtid_consistency=1
    26. eof
    27. systemctl restart mysql  &>/dev/null
    28. read -p "请输入IP地址："  num
    29. read -p "请输入用户名："  name
    30. read -p "请输入用户密码：" min
    31. create="grant all on *.* to $name@'$num' identified by'$min'"
    32. msyql -u root -p'$mia' -e "$create"  &> /dev/null
    33. systemctl start mysqld
    34. else
    35. echo "MySQL安装失败,请检查错误"
    36. fi
    37. fi
    38. #以下为从库使用参数，自行修改即可。
    39. #cat >> /etc/my.cnf <<eof
    40. #log-bin
    41. #server-id=2 
    42. #gtid_mode = ON  
    43. #enforce_gtid_consistency=1 
    44. #master-info-repository=TABLE  
    45. #relay-log-info-repository=TABLE
    46. #relay_log_recovery        = on
    47. #systemctl restart mysqld
    48. #change="change master to  MASTER_HOST='$num',MASTER_USER='$name',MASTER_PASSWORD='$min',MASTER_AUTO_POSITION=1,MASTER_LOG_POS=4,MASTER_CONNECT_RETRY=10;" 
    49. #msyql -u root -p'$mi' -e "$change"  &> /dev/null
    50. #mysql -u root -p'$mi' -e "start slave"
    51. #mysql -u root -p'$mi" -e "show slave status\G"