- name: instasll MySql
  apt:
   name: mysql-server,python-mysqldb

- name: create second root
  mysql_user:
   name: '{{ mysql_external_root }}'
   password: '{{ mysql_external_root_pass }}'
   priv: '*.*:ALL,GRANT'
   host: '%'
  when: mysql_external_root is defined

- name: Reload privilege tables
  command: 'mysql -ne "{{ item }}"'
  with_items:
    - FLUSH PRIVILEGES

- name: create DB user
  mysql_user:
   login_user: root
   login_password: '{{ mysql_root_pwd }}'
   name: '{{ item }}'
   priv: '{{ item }}.*:ALL,GRANT'
   password: '{{ item }}'
  with_items:
   - '{{mysql_user}}'

- name: create DB
  mysql_db:
   login_user: root
   login_password: '{{ mysql_root_pwd }}'
   name: '{{ item }}'
  with_items:
   - '{{mysql_user}}'

- name: allow remote access
  replace:
   path: /etc/mysql/mariadb.conf.d/50-server.cnf
   regexp: '({{ item }})'
   replace: '#\1'
   backup: yes
  with_items:
   - 'skip-external-locking'
   - 'bind-address'
  when: mysql_external_root is defined