search
HomeOperation and MaintenanceDockerHow to install mysql in docker and set it to be case-insensitive

Docker is a containerization technology that enables rapid deployment, transplantation and packaging of software applications. MySQL is a common relational database in the industry. Installing MySQL in Docker can easily build a local database environment. However, in some cases, MySQL may be case sensitive, causing some problems.

This article will introduce how to install MySQL in Docker and solve the problem of MySQL case sensitivity.

Installing Docker

First you need to install Docker. You can download the version that suits you from the official website and install it. After the installation is complete, you can enter the following command on the command line to verify whether the installation is successful:

docker version

If something similar to the following is displayed, Docker is installed successfully.

Client:
 Version:           18.03.1-ce
 API version:       1.37
 Go version:        go1.9.5
 Git commit:        9ee9f40
 Built:             Thu Apr 26 07:21:22 2018
 OS/Arch:           darwin/amd64
 Experimental:      false

Server:
 Engine:
  Version:          18.03.1-ce
  API version:      1.37 (minimum version 1.12)
  Go version:       go1.9.5
  Git commit:       9ee9f40
  Built:            Thu Apr 26 07:26:38 2018
  OS/Arch:          linux/amd64
  Experimental:     false

Installing MySQL

Before installing MySQL, you need to create a network to connect MySQL and other containers. Enter the following command on the command line to create a network:

docker network create my-network

Then, you can use the following command to pull the MySQL image:

docker pull mysql

After the pull is successful, you can use the following command to start the MySQL container. The -d parameter indicates running in background mode, and the -e parameter indicates setting the password of the MySQL root user.

docker run --name my-mysql -d -e MYSQL_ROOT_PASSWORD=password --network my-network mysql

After the startup is successful, you can use the following command to verify whether the startup is successful:

docker ps

If something similar to the following is displayed, the MySQL container is started successfully.

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS               NAMES
29d316425b95        mysql               "docker-entrypoint.s…"   5 seconds ago       Up 4 seconds        3306/tcp            my-mysql

Solving MySQL case sensitivity

In MySQL, it is case-sensitive by default. This will cause some problems, such as errors when performing JOIN, GROUP BY, ORDER BY and other operations. To solve this problem, the following methods can be used.

1. Modify the MySQL configuration file

Enter the MySQL container, modify the MySQL configuration file /etc/mysql/mysql.conf.d/mysqld.cnf, and add the following content under the [mysqld] node :

lower_case_table_names=1

After saving the configuration file, restart the MySQL container:

docker restart my-mysql

2. Add environment variables

When starting the MySQL container, you can use -e Parameters add lower_case_table_names=1 environment variable.

docker run --name my-mysql -d -e MYSQL_ROOT_PASSWORD=password -e lower_case_table_names=1 --network my-network mysql

Summary

This article introduces the installation of MySQL in Docker and solves the problem of MySQL case sensitivity. During the development process, Docker provides a convenient environment for deploying applications quickly and easily. However, when using Docker, you need to know some knowledge about Docker in order to better manage containers.

The above is the detailed content of How to install mysql in docker and set it to be case-insensitive. For more information, please follow other related articles on the PHP Chinese website!

Statement
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
How to use docker exec to run commands in a Docker containerHow to use docker exec to run commands in a Docker containerMar 05, 2025 pm 03:42 PM

This article explains how to use the docker exec command to run commands within a running Docker container. It covers basic syntax, options (like -it for interactive use and -d for detached mode), shell access, common use cases (debugging, administr

What is docker for? What is docker for?What is docker for? What is docker for?Mar 05, 2025 pm 03:49 PM

This article explains Docker, a containerization platform simplifying application building, shipping, and running. It addresses the "it works on my machine" problem by packaging apps and dependencies into isolated containers, improving con

Is docker an environment or softwareIs docker an environment or softwareMar 05, 2025 pm 03:38 PM

This article explains Docker, contrasting it with virtual machines. Docker uses containerization, sharing the host OS kernel for lightweight, resource-efficient application isolation. Key advantages include speed, portability, ease of deployment, a

How do I deploy applications to a Docker Swarm cluster?How do I deploy applications to a Docker Swarm cluster?Mar 17, 2025 pm 04:20 PM

The article details deploying applications to Docker Swarm, covering preparation, deployment steps, and security measures during the process.

What is docker for? What is docker for?What is docker for? What is docker for?Mar 05, 2025 pm 03:46 PM

Docker simplifies application building, shipping, and running via containerization. It offers consistent development environments, faster cycles, improved collaboration, and streamlined CI/CD, resulting in portable, scalable, and resource-efficient

What is docker for? What is docker for?What is docker for? What is docker for?Mar 05, 2025 pm 03:39 PM

This article explains Docker, a containerization platform simplifying application creation, deployment, and execution. It highlights Docker's benefits: improved efficiency, consistency, resource utilization, and streamlined deployment. Various use

What are Kubernetes pods, deployments, and services?What are Kubernetes pods, deployments, and services?Mar 17, 2025 pm 04:25 PM

The article explains Kubernetes' pods, deployments, and services, detailing their roles in managing containerized applications. It discusses how these components enhance scalability, stability, and communication within applications.(159 characters)

How do I scale applications in Kubernetes?How do I scale applications in Kubernetes?Mar 17, 2025 pm 04:28 PM

The article discusses scaling applications in Kubernetes using manual scaling, HPA, VPA, and Cluster Autoscaler, and provides best practices and tools for monitoring and automating scaling.

See all articles

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

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment