---

- name: install mysql-server
  sudo: yes
  apt: pkg=mysql-server state=installed

- name: install python-mysqldb
  sudo: yes
  apt: pkg=python-mysqldb state=installed

- name: Override mysql conf
  sudo: yes
  copy: src=my.cnf dest=/etc/mysql/my.cnf
  notify: Restart mysql

- name: Start the MySQL service
  service: name=mysql state=started

# 'localhost' needs to be the last item for idempotency, see
# http://ansible.cc/docs/modules.html#mysql-user
- name: update mysql root password for all root accounts
  mysql_user: name=root host={{item}} password={{mysql_root}}
  with_items:
    - {{ansible_hostname}}
    - 127.0.0.1
    - ::1
    - localhost

- name: copy .my.cnf file with root password credentials
  sudo: yes
  template: src=my.cnf dest=/home/deploy/.my.cnf owner=deploy mode=0600

- name: delete anonymous MySQL server user for {{server_hostname}}
  mysql_user: user="" host="{{server_hostname}}" state="absent"

- name: delete anonymous MySQL server user for localhost
  mysql_user: user="" state="absent"

- name: remove the MySQL test database
  mysql_db: db=test state=absent