---
# # Setup mySQL server
- hosts: artifactory_mysql
  gather_facts: no
  become: yes
  environment:
    USER: artifactory_user
    PASSWORD: password
  tasks:
    - name: Install mysql from file storage
      command: {{ item }}
        with_items:
          - rpm -Uvh /mysql-5.7/5.7.13/mysql-commercial-common-5.7.13-1.1.el7.x86_64.rpm
          - rpm -Uvh /mysql-5.7/5.7.13/mysql-commercial-libs-5.7.13-1.1.el7.x86_64.rpm
          - rpm -Uvh /mysql-5.7/5.7.13/mysql-commercial-client-5.7.13-1.1.el7.x86_64.rpm
          - rpm -Uvh /mysql-5.7/5.7.13/mysql-commercial-server-5.7.13-1.1.el7.x86_64.rpm
    - name: Setup mysql database
      mysql_db: name=$DB_NAME state=present
    - name: Create mysql user
      mysql_user: name=$USER password=$PASSWORD priv=*.*:ALL,GRANT state=present