Ansible Wordpress Error

[Sameera Wijerathna]

I want to setup WordPress[enter image description here][1] using Ansible environment. When i run following YAML files, it gives following error

Connection refused

Error establishing a database connection

**wordpressweb.yaml**

```

- hosts: wordpressweb

  remote_user: ubuntu

  become: yes

  become_user: root

  become_method: sudo

  tasks:

   - name: apache must be installed

     apt:

       name: apache2

       state: latest

       update_cache: yes

   - name: php must be installed

     apt:

       name: libapache2-mod-php

       state: latest

       update_cache: yes

   - name: mysql mod must be installed

     apt:

       name: php-mysql

       state: latest

       update_cache: yes

   - name: apache must be running

     service:

       enabled: yes

       name: apache2

       state: started

   - name: apache must be restarted

     service:

       enabled: yes

       name: apache2

       state: restarted

   - name: Make sure that there is no index.html

     file:

       path: /var/www/html/index.html

       state: absent

   - name: Download wordpress files and extract them to /var/www/html

     unarchive:

       dest: /var/www/html

       remote_src: yes

       src: https://wordpress.org/latest.tar.gz

   - name: Copy wp-config.php with correct credentials to /var/www/html

     copy:

       dest: /var/www/html/wordpress/wp-config.php

       src: /home/ansible/.ansible/wp-config.php

```

**wordpressdb.yaml**

```

- hosts: wordpressdb

  remote_user: ubuntu

  become: yes

  become_user: root

  become_method: sudo

  tasks:

    - name: Make sure that mysql is installed

      apt:

        name: mysql-server

        update_cache: yes

        state: latest

    - name: Make sure that Mysql is up and running , also enabled at boot

      service:

        name: mysql

        enabled: yes

        state: started

    - name: Make sure that Pymysql installed

      apt:

        name:

          - python3-pymysql

        update_cache: yes

        state: latest

    - name: Make sure that database wpdb exsists

      mysql_db:

         name: wpdb

         state: present

         login_unix_socket: /var/run/mysqld/mysqld.sock

    - name: Make sure that database user wpuser exists and he has permissions to the wpdb database

      mysql_user:

         name: wpuser

         password: DEVOPS12345

         priv: wpdb.*:ALL

         login_unix_socket: /var/run/mysqld/mysqld.sock

    - name: Make sure that database user wpuser exists and he has permissions to the wpdb database

      mysql_user:

         name: wpuser

         password: DEVOPS12345

         priv: wpdb.*:ALL

         host_all: yes

         login_unix_socket: /var/run/mysqld/mysqld.sock

```