cant create a DB with Ansible

Asked Oct 20 '20 at 19:08

Active Oct 20 '20 at 19:08

Viewed 369 times

I have installed MariaDB 10.4 on a CentOS 7 box. The box has MariaDB running and it does not have a root password on the DB. It is only allows local logins. I keep getting the error message below. I have tried to add a .my.cnf file and doesn't work. I have ran mysql_secure_installation and set the unix socket to yes and to no and no change. What am I missing?

FAILED! => {"changed": false, "msg": "unable to find /root/.my.cnf. Exception message: (1698, u\"Access denied for user 'root'@'localhost'\")"}

  - name: "Creates a new DB called {{ db }}"
    community.mysql.mysql_db:
      check_implicit_admin: yes
      name: "{{ db }}"
      state: present

asked Oct 20 '20 at 19:08

user2236794

1

What is the context of the `/root/.my.cnf` file, `ls -Z /root/.my.cnf`? Could be a SELinux issue. – tater Oct 21 '20 at 07:29
1

what happens, if you remove the `check_implicit_admin` parameter? – TRW Jan 13 '21 at 14:40

cant create a DB with Ansible

0 Answers0