websoft9archive / ansible-mysql Goto Github PK

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

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.

Additional context

You can add any other context about the problem here.

Language

• Chinese
• English

Content error

Some image of the documentation are not en version

• URL: https://support.websoft9.com/docs/mysql/solution-password.html#modify-password
• Description: The .gif image of PART Use phpMyAdmin(Recommend)
• Screenshot:
  

• URL: https://support.websoft9.com/docs/mysql/solution-remote.html#enable-the-tcp-3306-port
• Description: The image of PART Enable the TCP:3306 port
• Screenshot:
  

• URL: https://support.websoft9.com/docs/mysql/solution-navicat.html
• Screenshot:
  

• URL: https://support.websoft9.com/docs/mysql/admin-services.html#windows
• Screenshot:
  

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 '....'

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

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.

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\","
    ]
}

PHPmyadmin cannot be opened on port 9090，mysql 8