How to modify the root password of mysql in docker

How to modify the root password of mysql in docker

The first step is to create a mysql container

docker exec -it container ID /bin/bash

Step 2: Connect to MySQL

mysql -uroot -p

After entering the password, log in to the MySQL terminal

Step 3: Change password

SET PASSWORD FOR 'root' = PASSWORD('set password');

Step 4: Restart

Restart the mysql container

docker restart container id

Supplement: Docker starts the MySQL container to start the initialization default password problem -e MYSQL_ROOT_PASSWORD

docker run -p 3308:3308 --name=mysql -e MYSQL_ROOT_PASSWORD=123456 mysql:5.6
Initializing database
[root@localhost mugutu]# docker run -p 3308:3308 --name=mysql -e MYSQL_ROOT_PASSWORD=123456 mysql:5.6
Initializing database
2018-12-02 13:42:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-12-02 13:42:53 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2018-12-02 13:42:53 0 [Note] /usr/sbin/mysqld (mysqld 5.6.41) started as process 32 ...

The above is my personal experience. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM. If there are any mistakes or incomplete considerations, please feel free to correct me.

You may also be interested in:
  • How to obtain a permanent free SSL certificate from Let''s Encrypt in Docker
  • Docker solution for logging in without root privileges
  • How to change the root password in a container using Docker
  • How to obtain root permissions in a docker container
  • docker cp copy files and enter the container
  • Docker uses root to enter the container
  • Solution to the Docker container not having permission to write to the host directory
  • How to add a certificate to docker

<<:  Scoring rules of YSlow, a webpage scoring plugin developed by Yahoo

>>:  Use of filter() array filter in JS

Recommend

Three common uses of openlayers6 map overlay (popup window marker text)

Table of contents 1. Write in front 2. Overlay to...

XHTML tags that are easily confused by the location of the use

<br />We have always emphasized semantics in...

CSS to achieve horizontal lines on both sides of the middle text

1. The vertical-align property achieves the follo...

js to realize a simple disc clock

This article shares the specific code of js to im...

Detailed explanation of the basic usage of the auxiliary function mapGetters in vuex

mapGetters Helper Function mapGetters helper func...

React State state and life cycle implementation method

1. Methods for implementing components:組件名稱首字母必須大...

How to modify the ssh port number in Centos8 environment

Table of contents Preface start Preface The defau...

Get / delete method to pass array parameters in Vue

When the front-end and back-end interact, sometim...

Detailed explanation of CSS float property

1. What is floating? Floating, as the name sugges...

JS canvas realizes the functions of drawing board and signature board

This article shares the specific code of JS canva...

How to install JDK8 on Windows

1. Download: http://www.oracle.com/technetwork/ja...

jQuery combined with CSS to achieve the return to top function

CSS Operations CSS $("").css(name|pro|[...

Interpretation of CocosCreator source code: engine startup and main loop

Table of contents Preface preparation Go! text St...

In-depth understanding of JavaScript callback functions

Table of contents Preface Quick Review: JavaScrip...

HTML head tag meta to achieve refresh redirection

Copy code The code is as follows: <html> &l...