2.23. Docker install MySQL

2.23.1. 1. View the available MySQL versions ¶

Access MySQL Mirror Library address: https://hub.docker.com/_/mysql?tab=tags .

You can view other versions of MySQL through Sort by. The default is the latest version. mysql:latest .

` <../wp-content/uploads/2016/06/docker-mysql1.png>` __

You can also find other versions you want in the drop-down list: ` <../wp-content/uploads/2016/06/docker-mysql2.png>`__

In addition, we can use the docker search mysql command to view the available versions:

$ docker search mysql NAME DESCRIPTION STARS OFFICIAL AUTOMATED mysql MySQL is a widely used, open-source relati... 2529 [OK] mysql/mysql-server Optimized MySQL Server Docker images. Crea... 161 [OK] centurylink/mysql Image containing mysql. Optimized to be li... 45 [OK] sameersbn/mysql 36 [OK] google/mysql MySQL server for Google Compute Engine 16 [OK] appcontainers/mysql Centos/Debian Based Customizable MySQL Con... 8 [OK] marvambass/mysql MySQL Server based on Ubuntu 14.04 6 [OK] drupaldocker/mysql MySQL for Drupal 2 [OK] azukiapp/mysql Docker image to run MySQL by Azuki - http:... 2 [OK] ... 

2.23.2. 2. Pull MySQL image ¶

Here we pull the official image of the latest version:

$ docker pull mysql:latest 

` <../wp-content/uploads/2016/06/docker-mysql3.png>` __

2.23.3. 3. View the local image ¶

Use the following command to see if mysql is installed:

$ docker images 

` <../wp-content/uploads/2016/06/docker-mysql6.png>` __

You can see in the figure above that we have installed the latest version (latest) of the mysql image.

2.23.4. 4. Run the container ¶

After the installation is complete, we can run the mysql container using the following command:

$ docker run -itd --name mysql-test -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql 

Parameter description:

• -p 3306:3306 Map port 3306 of CCS to port 3306 of CDH. External hosts can access MySQL services directly through CDH ip:3306.

• MYSQL_ROOT_PASSWORD=123456 Set the password for the MySQL service root user

` <../wp-content/uploads/2016/06/docker-mysql4.png>` __

2.23.5. 5. Installation succeeded ¶

Use the docker ps command to see if the installation is successful:

` <../wp-content/uploads/2016/06/docker-mysql5.png>` __

The MySQL service can be accessed locally through root and password 123456.

` <../wp-content/uploads/2016/06/docker-mysql7.png>` __