STATE:
{%- set root_pass = salt['pillar.get']('admin_pass') %}
{%- set root_pass_raw = salt['pillar.get']('admin_pass_raw') %}
{%- set review_pass = salt['pillar.get']('review_pass') %}

root:
  mysql_user.present:
    - host: localhost
  {%- if root_pass is defined %}
    - password_hash: '{{ root_pass }}'
  {%- endif %}
  require:
    - pkg: mysql-python
    - pkg: mariadb-client
    - service.running: mariadb

root-pwd:
  mysql_user.present:
    - name: root
    - connection_host: localhost
    - connection_user: root
    - connection_pass: '{{ root_pass_raw }}'
    - connection_charset: utf8
    - use:
      - mysql_user: root
    - onfail:
      - mysql_user: root

review:
  mysql_user.present:
    - host: localhost
  {%- if review_pass is defined %}
    - password_hash: '{{ review_pass }}'
  {%- endif %}
    - connection_host: localhost
    - connection_user: root
    - connection_pass: root_pass_raw
    - connection_charset: utf8
  require:
    - pkg: mysql-python
    - pkg: mariadb-client
    - service.running: mariadb

    ERRORS:
    ----------
          ID: root
    Function: mysql_user.present
      Result: False
     Comment: MySQL Error 1045: Access denied for user 'root'@'localhost' (using password: NO)
     Started: 15:37:26.827806
    Duration: 11.512 ms
     Changes:
----------
          ID: root-pwd
    Function: mysql_user.present
        Name: root
      Result: False
     Comment: Recursive requisite found
     Changes:
----------
          ID: review
    Function: mysql_user.present
      Result: False
     Comment: MySQL Error 1045: Access denied for user 'root'@'localhost' (using password: YES)
     Started: 15:37:26.840551
    Duration: 5.328 ms
     Changes:
----------