Code Monkey home page Code Monkey logo

ansible-mysql's Introduction

MySQL Cloud Installer

Introduction

English | 简体中文

MySQL Cloud Installer, developed by Websoft9, is an automatic installation program of MySQL based on Ansible and shell. It helps user install MySQL and pre-configure required items automatically and users only need to run a command on Linux. It simplifies the complicated installation and initialization process.

System Requirement

System Requirement to install this repository are as following：

Conditions Details Notes
Operating System CentOS7.x, Ubuntu20.04, Amazon Linux2 Optional
Public Cloud AWS, Azure, Alibaba Cloud, HUAWEI ClOUD, Tencent Cloud Optional
Private Cloud KVM, VMware, VirtualBox, OpenStack Optional
Server Configuration vCPU no less than 1 core, Memory no less than 1 GIB, Storage no less than 20 GB, Swap no less than 2GB Bandwidth no less than 100M

To learn more information, please view Installation & Configuration.

Ecosystem

Core components of this repository: MySQL, phpMyAdmin on Docker

Learn more about Parameters.

Installation

You can install it by thi Cloud Installer solution all in one. In addition, you can deploy image published on major Cloud Platform by Websoft9.

All-in-one Installer

Run the automatic installation script with root authority to start the installation. If necessary, users need to make interactive choices, and then wait patiently until the installation is successful.

$ sudo su -
$ wget -N https://raw.githubusercontent.com/Websoft9/ansible-linux/main/scripts/install.sh; bash install.sh -r mysql

If the network is broken or blocked, SSH will be interrupted and the installation will fail. Please reinstall.

Image on Cloud

Follow our MySQL image for installation on major Cloud Platform.

Documentation

Administrator Guide

License

LGPL-3.0, Additional Terms: It is not allowed to publish free or paid image based on this repository in any Cloud platform's Marketplace.

Copyright (c) 2016-present, Websoft9

This program provided by Websoft9 contains a series of software with separate copyright notices and license terms. Your use of the source code for the software included is subject to the terms and conditions of its own license.

FAQ

How to install and view the latest release?

This repository install way is Package isntallation, you can view the version from Official URL.
We will check Release version regularly. Update and test this project to ensure that users can successfully install the required version of MySQL.

Can I run this repository on Ansible Tower?

Yes.

Although the results of the deploy by image are consistent with the results of deploy by script, what is the difference between the two deployment methods?

Suggest you read the document Deploy by Image vs Deploy by Script.

ansible-mysql's People

Contributors

chendelin1982 avatar helin2020 avatar hliblack avatar hnczhjh avatar laozhou0731 avatar mozlk avatar qiaofeng1227 avatar zengxc-1996 avatar

Stargazers

avatar avatar avatar avatar

Watchers

avatar avatar

Forkers

iroach i7dell goldbase

ansible-mysql's Issues

Select MySQL5.6 but MySQL5.7 installed

Select 5.6, install 5.7 , I don't know why

Please choose the number for MySQL version [ 1/2/3/4]

 1: MySQL5.5(only for CentOS7.x, AmazonLinux)
 2: MySQL5.6(only for CentOS7.x, AmazonLinux, Ubuntu16.04, Container)
 3: MySQL5.7(Support all)
 4: MySQL8.0(Support all)
 [3]: 2



RUNNING HANDLER [role_end : end_check_versions] ******************************************************************************
ok: [40.122.55.149] => {
    "end_check_versions.stdout_lines": [
        "Docker version 20.10.6, build 370c289",
        "mysql  Ver 14.14 Distrib 5.7.33, for Linux (x86_64) using  EditLine wrapper",
        "Docker version 20.10.6, build 370c289",
        "phpmyadmin version: \"version\": \"5.1.0\","
    ]
}

Some image of the documentation are not en version

Language

  • Chinese
  • English

Content error

Some image of the documentation are not en version

Content optimization

Provide us with content optimization, e.g easy to read, simplify the steps, step by step, precise expression.

  • URL:
  • Description:

New content

Describe important content what do you think is important in this documentation.

What content do you want to add?

(describe here)

Steps for the content

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. Modify file '....'

Install mysql 5.7 on aliyun ubuntu20 and mysql 5.6 on azure ubuntu 20 error

Describe the bug

A clear and concise description of what the bug is.

Deployment method

  • subscription image from MarketPlace of Cloud
  • All-in-one Installer
  • ansible-playbook cli
  • mcloud
  • create instance from private image

Bug source

  • Bugs from installation
  • Bugs from first use
  • Other (You should describe it)

System Environment

Application Version

e.g v4.5

OS

  • Ubuntu18.x
  • Ubuntu20.x
  • CentOS7.x
  • CentOS8.x
  • AmazonLinux2
  • OracleLinux7.8
  • OracleLinux8.2
  • Other (You should describe it)

Cloud PlatForm

  • Azure
  • Aws
  • 阿里云
  • 腾讯云
  • 华为云
  • AlibabaCloud
  • HUWEICloud
  • Other (You should describe it)

Bug reproduce

Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Bug reports

Bug Context

Bug context includes bug error, error logs and service status, it is very important for resolving issue

# bug error
(paste here) 

# service status 
(paste here) 

# error logs
(paste here)

Bug Screenshot

paste screenshot here

Your suggestion

The reason of Bug

You can describe the reason if you have found it

Your solution for Bug

You can describe your solution here

Additional context

You can add any other context about the problem here.

Mysql5.5 get mysql configure failed

Describe the bug

A clear and concise description of what the bug is.

Deployment method

  • subscription image from MarketPlace of Cloud
  • All-in-one Installer
  • ansible-playbook cli
  • mcloud
  • create instance from private image

Bug source

  • Bugs from installation
  • Bugs from first use
  • Other (You should describe it)

System Environment

Application Version

e.g v4.5

OS

  • Ubuntu18.x
  • Ubuntu20.x
  • CentOS7.x
  • CentOS8.x
  • AmazonLinux2
  • OracleLinux7.8
  • OracleLinux8.2
  • Other (You should describe it)

Cloud PlatForm

  • Azure
  • Aws
  • 阿里云
  • 腾讯云
  • 华为云
  • AlibabaCloud
  • HUWEICloud
  • Other (You should describe it)

Bug reproduce

Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Bug reports

Bug Context

Bug context includes bug error, error logs and service status, it is very important for resolving issue

# bug error
(paste here) 

# service status 
(paste here) 

# error logs
(paste here)

Bug Screenshot

paste screenshot here

Your suggestion

The reason of Bug

You can describe the reason if you have found it

Your solution for Bug

You can describe your solution here

Additional context

$R{0(93_54~2JU8V 9`D}H6

mysql 8.0 Random password is not valid?

Describe the bug

A clear and concise description of what the bug is.

Deployment method

  • subscription image from MarketPlace of Cloud
  • All-in-one Installer
  • ansible-playbook cli
  • mcloud
  • create instance from private image

Bug source

  • Bugs from installation
  • Bugs from first use
  • Other (You should describe it)

System Environment

Application Version

e.g v4.5

OS

  • Ubuntu18.x
  • Ubuntu20.x
  • CentOS7.x
  • CentOS8.x
  • AmazonLinux2
  • OracleLinux7.8
  • OracleLinux8.2
  • Other (You should describe it)

Cloud PlatForm

  • Azure
  • Aws
  • 阿里云
  • 腾讯云
  • 华为云
  • AlibabaCloud
  • HUWEICloud
  • Other (You should describe it)

Bug reproduce

Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Bug reports

Bug Context

Bug context includes bug error, error logs and service status, it is very important for resolving issue

# bug error


# service status 
normal


# error logs
journalctl -u init-apps
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: [46B blob data]
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: error: 'Can't connect to MySQL server on '::1:3306' (111)'
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: Check that mysqld is running on ::1 and that the port is 3306.
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: You can check this by doing 'telnet ::1 3306'
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: [52B blob data]
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: error: 'Can't connect to MySQL server on '127.0.0.1:3306' (111)'
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: Check that mysqld is running on 127.0.0.1 and that the port is 3306.
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: You can check this by doing 'telnet 127.0.0.1 3306'
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: [52B blob data]
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Apr 29 07:02:47 ip-172-31-42-186 bash[850]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Bug Screenshot

image

Your suggestion

The reason of Bug

You can describe the reason if you have found it

Your solution for Bug

Mysqld was not started before decryption.
image
image

Additional context

You can add any other context about the problem here.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.