Poop

---
- name: install a database
  hosts: test1
  become: true
  become_user: root
  gather_facts: true
  tasks:
    - name: install pip
      apt: pkg=python-pip state=present

    - name: install libmysqlclient
      apt: pkg=libmysqlclient-dev state=present

    - name: install python mysql
      pip: name=MySQL-python state=present

    - name: create database
      mysql_user: user=polytechnic password=pass priv=*.*:ALL state=present

    - name: create database
      mysql_db: db=poly state=present

    - name: create a table
      command: mysql -u polytechnic -ppass -e 'CREATE TABLE reg (name varchar(30), email varchar(30));' poly