name: update mysql root password for all root accounts
    sudo: yes
    mysql_user:
      name: root
      host: localhost
      password: "{{ mysql_root_password }}"
      login_user: root
      login_password: "{{ mysql_root_password }}"
      check_implicit_admin: yes
      append_privs: yes
      priv: "*.*:ALL,GRANT"
    with_items:
      - "{{ ansible_hostname }}"
      - 127.0.0.1
      - ::1
      - localhost

- name: mysql preference
    sudo: yes
    mysql_user:
      login_user: root
      login_password: "{{mysql_root_password}}"
      name: webuser
      password: $6$eitlreqk4$gTRkTeesThbY9YIIoXeLCKqBzr20KxBE/y8pKuq4fTMD3oV4zw9jMX0Rk3f3Qbp1aAXeMbTSqYLDJr0DV5wuE0
      host: localhost
      append_privs: yes
      priv: drp.*:ALL,GRANT
      state: present