- name: set root password
  mysql_user:
    check_implicit_admin: "yes"
    login_user: "root"
    login_password: "{{ mysql_root_password }}"
    name: "root"
    host: "{{ item }}"
    password: "{{ mysql_root_password }}"
  with_items:
    - "{{ ansible_hostname }}"
    - "127.0.0.1"
    - "::1"
    - "localhost"

changed: [ansible3.local] => (item=bifrost1)
failed: [ansible3.local] (item=127.0.0.1) => {"failed": true, "item": "127.0.0.1", "msg": "(1396, "Operation CREATE USER failed for 'root'@'127.0.0.1'")"}
failed: [ansible3.local] (item=::1) => {"failed": true, "item": "::1", "msg": "(1396, "Operation CREATE USER failed for 'root'@'::1'")"}
failed: [ansible3.local] (item=localhost) => {"failed": true, "item": "localhost", "msg": "(1396, "Operation CREATE USER failed for 'root'@'localhost'")"}