Problem Role Mysql

[marckson junior]

Hi guys,

Im having a problem when i run one playbook with my role to install and create a database inside mysql.

The first time i run the playbook it finishes successfully. 

But when i run again i get an error saying ansible canot connect to my database.

although i can connect the database manually without a problem using my .my.cnf file where is my root password.

This is my role Mysql: 

---
 
- name: Instalacao de Pacotes
  yum:
    name: [ 'mariadb-server', 'python3-PyMySQL' ]
    state: latest
 
- name: Criação da senha de root
  command: openssl rand -base64 14 creates=/root/.my.cnf
  register: mysql_root_pass

- name: Display password
  debug:
   msg: "Password: {{ mysql_root_pass.stdout }}"
  when:
    - mysql_root_pass.changed

- name: Start Mysql
  systemd:
    name: mariadb
    enabled: true
    state: restarted

- name: Alterar a senha de root
  mysql_user:
    name: root
    host: localhost
    password: "{{ mysql_root_pass.stdout }}"
  when:
    - mysql_root_pass.changed

- name: Copiando template .my.cnf
  template: src=.my.cnf dest=/root/.my.cnf owner=root group=root mode='600'
  when:
      - mysql_root_pass.changed
  notify:
    -  Restart MariaDB
- name: Removendo o acesso Anonimo
  mysql_user: name="" host=localhost state=absent

- name: Removendo a base test
  mysql_db: name=test state=absent

- name: Criação da base de dados Wordpress
  mysql_db:
    name: 'wordpress'
    state: present
    login_user: 'root'
    login_password: "{{ mysql_root_pass.stdout }}"
    login_host: 'localhost'      
    login_unix_socket: /var/lib/mysql/mysql.sock

- name: Criação do usuario Wordpress e liberaçao de acessoa  base de dados Wordpress.
  mysql_user:
    name: 'wordpress'
    password: 'wordpress'
    priv: 'wordpress.*:ALL'
    host: '10.0.2.%'
    login_user: 'root'
    login_password: "{{ mysql_root_pass.stdout }}"
    login_host: 'localhost'


As i said, the first time i run, i got no problems:

TASK [mysql : Criação da base de dados Wordpress] ******************************

22:29:49

43

changed: [wordpress.juin.com]

44

44

But the second time, i thin i shoud receive a green "OK" because my database is already created but i get that:

TASK [mysql : Criação da base de dados Wordpress] ******************************

22:32:12

34

fatal: [wordpress.juin.com]: FAILED! => {"changed": false, "msg": "unable to connect to database, check login_user and login_password are correct or /root/.my.cnf has the credentials. Exception message: (1045, \"Access denied for user 'root'@'localhost' (using password: YES)\")"}

...

Can you help me resolve this?

--

Marckson Negreiros Junior