ansible playbook 自动换批量安装myslq 5.7

首先准备 mysql 5.7 的二进制安装包和这个剧本放在同一目录下,然后var 变量里 ,可以自己定义mysql 5.7 的登录密码。
支持系统:centos 7 ,centos 8

---
  - hosts: xiapi
    vars:
     - mysqlpass: Liu123
    tasks: 
     - name: ready install
       yum: name=libaio
     - name: centos8 install ncurses-compat-libs
       yum: name=ncurses-compat-libs
       when: ansible_distribution_major_version == "8"
       tags: yum
     - name: create group
       group: name=mysql gid=306 system=yes
     - name: create user
       user: name=mysql uid=306 group=mysql shell=/sbin/nologin system=yes create_home=no home=/data/mysql
     - name: unarchive
       unarchive: src=mysql-5.7.28-el7-x86_64.tar.gz dest=/usr/local owner=root group=root
     - name: link
       file: src=/usr/local/mysql-5.7.28-el7-x86_64 dest=/usr/local/mysql state=link
     - name: change path
       copy: content='PATH=/usr/local/mysql/bin:$PATH' dest=/etc/profile.d/mysql.sh
     - name: clear dir
       file: path=/data/mysql state=absent
       tags: clear
     - name: touch mysql.txt
       file: path=/root/mysql.txt state=touch
     - name: create database
       shell: chdir=/usr/local/mysql/bin ./mysqld --initialize-insecure --user=mysql --datadir=/data/mysql > /root/mysql.txt
       tags: init
     - name: ready my.cnf
       copy: src=my.cnf dest=/etc/my.cnf
     - name: copy service
       shell: cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
     - name: boot
       shell: chkconfig --add mysqld
     - name: start service
       shell: service mysqld start
     - name: change passwd
       shell: /usr/local/mysql/bin/mysql -D mysql -e "update user set authentication_string=password('{{mysqlpass}}') where user='root';"
       tags: changepasswd
     - name: flush pri
       shell: /usr/local/mysql/bin/mysql -e "flush privileges;"
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值