How to install mysql server using ansible playbook?

Question

I am trying to install mysql server on centos using ansible playbook. My yml file looks like above.

---
- name: Install MySQL database server
  hosts: test
  become: yes
  become_method: sudo
  gather_facts: true
  tags: [database]
  tasks:
        - name: Update the software package repository
          yum:
                update_cache: yes

        - name: Install MySQL
          package:
                name: "{{ item }}"
                state: latest

          with_items:
              - mysql-server
              - mysql-client
              - python-mysqldb

But it getting error.

failed: [192.168.94.151] (item=mysql-server) => {"changed": false, "item": "mysql-server", "msg": "No package matching 'mysql-server' found available, installed or updated", "rc": 126, "results": ["No package matching 'mysql-server' found available, installed or updated"]}

How can i fix this issue?

To obtain valid package names, SSH into your server and do `yum search mysql`. — adgud, Dec 22 '18 at 12:30

Janith · Answer 1 · 2018-12-24T02:30:15.067

2

I had to download and add the repository and then update.

   - name: Download sources
      get_url:
        url: http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
        dest: /opt/mysql

   - name: Install package
     yum:
       name: /opt/mysql/mysql-community-release-el7-5.noarch.rpm
       state: present


   - name: Install MySQL
     yum: name=mysql-server state=installed

edited Dec 24 '18 at 02:30

answered Dec 24 '18 at 02:18

Janith

223
2
4
8

1

You don't have to `get_url` first. You can just provide the URL directly to `yum`. – Michael Hampton Apr 25 '19 at 01:05

How to install mysql server using ansible playbook?

1 Answers1