RDS 배포 및 구성-yml 파일

---
-- name: mysql5.7 install
   hosts: db
   tasks:
    - name: repository config
      shell: 'yum install -y http://dev.mysql.com/get/mysql57-communuty-release-el7-11.noarch.rpm'
      ignore_errors: yes
    - name: mysql5.7 server install
      yum:
       name: mysql-community-server
       disable_gpq_check: true
       state: present
    - name: mysql5.7 client
      yum:
       name: mysql-commuity-client
       disable_gpg_check treu
       state: present
    - name: mysql5.7 server start
      systemd:
       name: mysqld
       state: started
    - name: install MySQL
      yum:
       name:
         - python3-pip
         - MySQL-python
    - name: Start the Mysql service
      systemd:
        name: mysqld
        state: started
        enabled: true
    - name: Change mysql root password and keep track in
      shell: |
        password_match=`awk '/A temporary password is generated for/ {a=$0} END{ print a }' /var/log/mysqld.log | awk '{print $(NF)}'`
        echo $password_match
        mysql -uroot -p$password_match --connect-expired-password -e "ALTER USER 'root'@'localhost' IDENTIFIED BY 'It12345@; flush privileges;"
        echo "[client]"
        user=root
        password=It12345@ > /root/.my.cnf
        mysql -uroot -p$password -e "grant all privileges on *.* to 'root'@'%' IDENTIFIED BY 'It12345@'; flush privileges;"
    - name: create database
      mysql_db:
        name: wp
        state: present
        login_user: root
        login_password: 'It12345@'
    - name: port open
      firewalld:
        port : 3306/tcp
        immediate: yes
        permanent: yes