Home Database Mysql Tutorial How to create a Mysql container using Docker

How to create a Mysql container using Docker

Jun 03, 2023 am 08:03 AM
mysql docker

The steps are as follows

1. Start the docker service

[root@docker ~]# systemctl start docker
Copy after login

2. View the image in docker

[root@docker ~]# docker images
repository  tag   image id  created  size
centos/mysql-57-centos7 latest  2e4ddfafaa6f 6 months ago 445mb
gogs/gogs   latest  2fb3b88053d6 6 months ago 94.2mb
Copy after login

3. Search for the desired The name of the image to be queried

[root@docker ~]# docker search mysql
name             description          stars    official   automated
mysql             mysql is a widely used, open-source relation… 7854    [ok]    
mariadb            mariadb is a community-developed fork of mys… 2604    [ok]    
cloudfoundry/cf-mysql-ci        image used in ci of cf-mysql-release   0 
[root@localhost ~]# docker pull mysql ---------------------默认下载最新版本
[root@localhost ~]# docker pull mysql:5.7--------------------下载指定版本
Copy after login

4. Create and run a mysql container

[root@docker ~]# docker run -di --name=test_mysql -p 3306:3306 -e mysql_root_password=root centos/mysql-57-centos7
d7e5f99b502a904a970026e90227e186107e3b5d0baeaa93491af12cd7317b99
run : 创建并运行
-di : 以守护者模式创建
--name : 给容器取个名字
-p : 端口映射
-e : 初始化mysql用户,并将root密码设置为root
Copy after login

The last filled in is the name of the image. If you do not specify a version, the latest one will be created by default

5. Check the running container

[root@docker ~]# docker ps
container id  image      command     created    status    ports     names
d7e5f99b502a  centos/mysql-57-centos7 "container-entrypoin…" 5 seconds ago  up 4 seconds  0.0.0.0:3306->3306/tcp test_mysql
Copy after login

6. You can use the database tool on your computer to connect to the database in the virtual machine

How to create a Mysql container using Docker

ip is the IP connecting to the virtual machine, account: root, password: root

7. In fact, as long as you can pull an image, the others are similar (such as redis, mogodb, rabbitmq, etc.)

How to create a Mysql container using Docker

The above is the detailed content of How to create a Mysql container using Docker. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to exit the container by docker How to exit the container by docker Apr 15, 2025 pm 12:15 PM

Four ways to exit Docker container: Use Ctrl D in the container terminal Enter exit command in the container terminal Use docker stop <container_name> Command Use docker kill <container_name> command in the host terminal (force exit)

How to copy files in docker to outside How to copy files in docker to outside Apr 15, 2025 pm 12:12 PM

Methods for copying files to external hosts in Docker: Use the docker cp command: Execute docker cp [Options] <Container Path> <Host Path>. Using data volumes: Create a directory on the host, and use the -v parameter to mount the directory into the container when creating the container to achieve bidirectional file synchronization.

How to check the name of the docker container How to check the name of the docker container Apr 15, 2025 pm 12:21 PM

You can query the Docker container name by following the steps: List all containers (docker ps). Filter the container list (using the grep command). Gets the container name (located in the "NAMES" column).

How to restart docker How to restart docker Apr 15, 2025 pm 12:06 PM

How to restart the Docker container: get the container ID (docker ps); stop the container (docker stop <container_id>); start the container (docker start <container_id>); verify that the restart is successful (docker ps). Other methods: Docker Compose (docker-compose restart) or Docker API (see Docker documentation).

MySQL's Role: Databases in Web Applications MySQL's Role: Databases in Web Applications Apr 17, 2025 am 12:23 AM

The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

How to start mysql by docker How to start mysql by docker Apr 15, 2025 pm 12:09 PM

The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database

Laravel Introduction Example Laravel Introduction Example Apr 18, 2025 pm 12:45 PM

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.

How to update the image of docker How to update the image of docker Apr 15, 2025 pm 12:03 PM

The steps to update a Docker image are as follows: Pull the latest image tag New image Delete the old image for a specific tag (optional) Restart the container (if needed)

See all articles