Setting up root Password

[bertvv]

Setting up root Password

[bertvv]

I cannot reproduce this error, can you provide some more information? A minimal failing playbook would help.

I set up a Vagrant test environment with v2.0.1 of this role and the following playbook:

# site.yml
---
- hosts: srv001
  become: true
  vars:
    mariadb_root_password: 'secure'
  roles:
    - bertvv.mariadb

In my test setup, this playbook finishes without errors, and mysql -uroot -psecure mysql works as expected.

The error message "Can't find any matching row in the user table" suggests that the root user doesn't exist anymore? Was the playbook applied on a clean installation?

[bertvv]

Since I haven't heard back from you, @Rahulsharma0810, I assume this isn't relevant anymore. I'm going to close this issue. Feel free to report it again if this still causes you problems, if possible with a minimal playbook that reproduces the error.