Erro no restart do MYSQL com Ansible

Estou tomando o erro abaixo ao tentar cria o banco mysql pelo ansible:

fatal: [172.17.177.42]: FAILED! => {"changed": false, "msg": "unable to find /root/.my.cnf. Exception message: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)")"}

my.cnf

[mysqld] user = mysql socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp bind-address = 0.0.0.0 key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/log/mysql/error.log expire_logs_days = 10 max_binlog_size = 100M

[client] port = 3306 socket = /var/run/mysqld/mysqld.sock user = root password = vagrant

[mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0

[mysqldump] quick quote-names max_allowed_packet = 16M

[mysql]

[isamchk] key_buffer = 16M

provisiom.yml

• hosts: database handlers:

  • name: restart mysql service: name: mysql state: restarted become: yes

  tasks:

  • name: 'Instalar pacotes de dependencias do sistema operacional' apt: name: "{{ item }}" state: latest become: yes with_items:

    • mysql-server
    • python3-mysqldb

  • name: Pause de 1 minuto antes de criar o BD Mysql pause: minutes: 1

  • name: 'Criar o banco do Mysql' mysql_db: name: wordpress_db login_user: root state: present become: yes

  • name: 'Configura Mysql para aceitar conexões remotas' copy: src: 'files/my.cnf' dest: '/etc/mysql/my.cnf' become: yes notify:

    • restart mysql

  • name: 'Criar o usuário do MySQL' mysql_user: login_user: root name: wordpress_user password: 12345 priv: 'wordpress_db.*:ALL' state: present host: "{{ item }}" with_items:

    • 'localhost'
    • '127.0.0.1'
    • '172.17.177.40' become: yes

• hosts: wordpress handlers:

  • name: restart apache service: name: apache2 state: restarted become: yes

  tasks:

  • name: Add PHP 7 PPA repository become: true apt_repository: repo: 'ppa:ondrej/php'

  • name: 'Instalar pacotes de dependencias do sistema operacional' apt: name: "{{ item }}" state: latest become: yes with_items:

    • php7.3
    • apache2
    • libapache2-mod-php7.3
    • php7.3-gd
    • libssh2-1
    • php7.3-ssh2
    • php7.3-mcrypt
    • php7.3-mysql

  • name: 'Baixando o pacote de instalação do Wordpress' get_url: url: 'https://wordpress.org/latest.tar.gz' dest: '/tmp/wordpress.tar.gz'

  • name: 'Descompactando o wordpress' ansible.builtin.unarchive: src: '/tmp/wordpress.tar.gz' dest: /var/www/ remote_src: yes become: yes

  • copy: src: '/var/www/wordpress/wp-config-sample.php' dest: '/var/www/wordpress/wp-config.php' remote_src: yes become: yes

  • name: "Configurando o wp-config com as entradas do banco de dados" replace: path: '/var/www/wordpress/wp-config.php' regexp: "{{ item.regex }}" replace: "{{ item.value }}" with_items:

    • { regex: 'database_name_here', value: 'wordpress_db'}
    • { regex: 'username_here', value: 'wordpress_user'}
    • { regex: 'password_here', value: '12345'}
    • { regex: 'localhosdt', value: '172.17.177.42'} become: yes

  • name: 'Configura o Apache para servir o Wordpress' copy: src: 'files/000-default.conf' dest: '/etc/apache2/sites-available/000-default.conf' become: yes notify:

    • restart apache