Conforme o colega do forum apontou, não funciona assim:
- name: 'Cria o banco do MySQL'
mysql_db:
name: wordpress_db
login_user: root
state: present
Funciona se for assim:
- name: Create mysql database - wordpress_db
mysql_db:
name: wordpress_db
state: present
become: yes