How to install mysql server using ansible playbook? Unicorn Meta Zoo #1: Why another...

Does Feeblemind produce an ongoing magical effect that can be dispelled?

Book with legacy programming code on a space ship that the main character hacks to escape

Identify story/novel: Tribe on colonized planet, not aware of this. "Taboo," altitude sickness, robot guardian (60s? Young Adult?)

Error: Syntax error. Missing ')' for CASE Statement

Why did Israel vote against lifting the American embargo on Cuba?

"Whatever a Russian does, they end up making the Kalashnikov gun"? Are there any similar proverbs in English?

My bank got bought out, am I now going to have to start filing tax returns in a different state?

std::is_constructible on incomplete types

How do I check if a string is entirely made of the same substring?

"Rubric" as meaning "signature" or "personal mark" -- is this accepted usage?

Does the set of sets which are elements of every set exist?

I preordered a game on my Xbox while on the home screen of my friend's account. Which of us owns the game?

Does Mathematica have an implementation of the Poisson Binomial Distribution?

How would this chord from "Rocket Man" be analyzed?

With indentation set to `0em`, when using a line break, there is still an indentation of a size of a space

What's the difference between using dependency injection with a container and using a service locator?

What if Force was not Mass times Acceleration?

Is there any hidden 'W' sound after 'comment' in : Comment est-elle?

What *exactly* is electrical current, voltage, and resistance?

Is Diceware more secure than a long passphrase?

Password Generator in batch

What is the ongoing value of the Kanban board to the developers as opposed to management

How would I use different systems of magic when they are capable of the same effects?

Could moose/elk survive in the Amazon forest?



How to install mysql server using ansible playbook?



Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar Manara
Come Celebrate our 10 Year Anniversary!Can't install MySQLenable mysql 5.5 for phpHow do i install OpenEMM on CentOS 5.9How to install Python packages to (Homebrew) Ansible's site-packages folderAnsible playbook running ad-hoc commandAnsible can't git clone from enterprise git serverAnsible playbook IssueAnsible throwing errors while installing packages via apt and yumAnsible - manage installed apps and send output via email - variables are filling wrongUsing Ansible, how can I take actions on each file in a specific location?





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















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?










share|improve this question














bumped to the homepage by Community 5 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
















  • Use the correct package names.

    – Michael Hampton
    Dec 21 '18 at 4:08











  • Is this wrong? - mysql-server - mysql-client

    – Janith
    Dec 21 '18 at 4:39













  • Yes, they are wrong.

    – Michael Hampton
    Dec 21 '18 at 14:58











  • To obtain valid package names, SSH into your server and do yum search mysql.

    – adgud
    Dec 22 '18 at 12:30


















0















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?










share|improve this question














bumped to the homepage by Community 5 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
















  • Use the correct package names.

    – Michael Hampton
    Dec 21 '18 at 4:08











  • Is this wrong? - mysql-server - mysql-client

    – Janith
    Dec 21 '18 at 4:39













  • Yes, they are wrong.

    – Michael Hampton
    Dec 21 '18 at 14:58











  • To obtain valid package names, SSH into your server and do yum search mysql.

    – adgud
    Dec 22 '18 at 12:30














0












0








0








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?










share|improve this 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?







mysql ansible ansible-playbook






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Dec 21 '18 at 3:22









JanithJanith

83




83





bumped to the homepage by Community 5 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







bumped to the homepage by Community 5 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.















  • Use the correct package names.

    – Michael Hampton
    Dec 21 '18 at 4:08











  • Is this wrong? - mysql-server - mysql-client

    – Janith
    Dec 21 '18 at 4:39













  • Yes, they are wrong.

    – Michael Hampton
    Dec 21 '18 at 14:58











  • To obtain valid package names, SSH into your server and do yum search mysql.

    – adgud
    Dec 22 '18 at 12:30



















  • Use the correct package names.

    – Michael Hampton
    Dec 21 '18 at 4:08











  • Is this wrong? - mysql-server - mysql-client

    – Janith
    Dec 21 '18 at 4:39













  • Yes, they are wrong.

    – Michael Hampton
    Dec 21 '18 at 14:58











  • To obtain valid package names, SSH into your server and do yum search mysql.

    – adgud
    Dec 22 '18 at 12:30

















Use the correct package names.

– Michael Hampton
Dec 21 '18 at 4:08





Use the correct package names.

– Michael Hampton
Dec 21 '18 at 4:08













Is this wrong? - mysql-server - mysql-client

– Janith
Dec 21 '18 at 4:39







Is this wrong? - mysql-server - mysql-client

– Janith
Dec 21 '18 at 4:39















Yes, they are wrong.

– Michael Hampton
Dec 21 '18 at 14:58





Yes, they are wrong.

– Michael Hampton
Dec 21 '18 at 14:58













To obtain valid package names, SSH into your server and do yum search mysql.

– adgud
Dec 22 '18 at 12:30





To obtain valid package names, SSH into your server and do yum search mysql.

– adgud
Dec 22 '18 at 12:30










1 Answer
1






active

oldest

votes


















0














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





share|improve this answer


























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "2"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f946219%2fhow-to-install-mysql-server-using-ansible-playbook%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    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





    share|improve this answer






























      0














      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





      share|improve this answer




























        0












        0








        0







        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





        share|improve this answer















        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






        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Dec 24 '18 at 2:30

























        answered Dec 24 '18 at 2:18









        JanithJanith

        83




        83






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Server Fault!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f946219%2fhow-to-install-mysql-server-using-ansible-playbook%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            117736 Шеррод Примітки | Див. також | Посилання | Навігаційне...

            As a Security Precaution, the user account has been locked The Next CEO of Stack OverflowMS...

            Маріан Котлеба Зміст Життєпис | Політичні погляди |...