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
Running Docker on Linux: Installation and ConfigurationRunning Docker on Linux: Installation and ConfigurationApr 26, 2025 am 12:12 AM

Installing and configuring Docker on Linux requires ensuring that the system is 64-bit and kernel version 3.10 and above, use the command "sudoapt-getupdate" and install it with the command "sudoapt-getupdate" and verify it with "sudoapt-getupdate" and. Docker uses the namespace and control groups of the Linux kernel to achieve container isolation and resource limitation. The image is a read-only template, and the container can be modified. Examples of usage include running an Nginx server and creating images with custom Dockerfiles. common

Why Use Docker? Benefits and Advantages ExplainedWhy Use Docker? Benefits and Advantages ExplainedApr 25, 2025 am 12:05 AM

The reason for using Docker is that it provides an efficient, portable and consistent environment to package, distribute, and run applications. 1) Docker is a containerized platform that allows developers to package applications and their dependencies into lightweight, portable containers. 2) It is based on Linux container technology and joint file system to ensure fast startup and efficient operation. 3) Docker supports multi-stage construction, optimizes image size and deployment speed. 4) Using Docker can simplify development and deployment processes, improve efficiency and ensure consistency across environments.

Docker in Action: Real-World Examples and Use CasesDocker in Action: Real-World Examples and Use CasesApr 24, 2025 am 12:10 AM

Docker's application scenarios in actual projects include simplifying deployment, managing multi-container applications and performance optimization. 1.Docker simplifies application deployment, such as using Dockerfile to deploy Node.js applications. 2. DockerCompose manages multi-container applications, such as web and database services in microservice architecture. 3. Performance optimization uses multi-stage construction to reduce the image size and monitor the container status through health checks.

Docker vs. Kubernetes: Use Cases and ScenariosDocker vs. Kubernetes: Use Cases and ScenariosApr 23, 2025 am 12:11 AM

Select Docker in a small project or development environment, and Kubernetes in a large project or production environment. 1.Docker is suitable for rapid iteration and testing, 2. Kubernetes provides powerful container orchestration capabilities, suitable for managing and expanding large applications.

Docker on Linux: Containerization for Linux SystemsDocker on Linux: Containerization for Linux SystemsApr 22, 2025 am 12:03 AM

Docker is important on Linux because Linux is its native platform that provides rich tools and community support. 1. Install Docker: Use sudoapt-getupdate and sudoapt-getinstalldocker-cedocker-ce-clicotainerd.io. 2. Create and manage containers: Use dockerrun commands, such as dockerrun-d--namemynginx-p80:80nginx. 3. Write Dockerfile: Optimize the image size and use multi-stage construction. 4. Optimization and debugging: Use dockerlogs and dockerex

Docker: The Containerization Tool, Kubernetes: The OrchestratorDocker: The Containerization Tool, Kubernetes: The OrchestratorApr 21, 2025 am 12:01 AM

Docker is a containerization tool, and Kubernetes is a container orchestration tool. 1. Docker packages applications and their dependencies into containers that can run in any Docker-enabled environment. 2. Kubernetes manages these containers, implementing automated deployment, scaling and management, and making applications run efficiently.

Docker's Purpose: Simplifying Application DeploymentDocker's Purpose: Simplifying Application DeploymentApr 20, 2025 am 12:09 AM

The purpose of Docker is to simplify application deployment and ensure that applications run consistently in different environments through containerization technology. 1) Docker solves the environmental differences problem by packaging applications and dependencies into containers. 2) Create images using Dockerfile to ensure that the application runs consistently anywhere. 3) Docker's working principle is based on images and containers, and uses the namespace and control groups of the Linux kernel to achieve isolation and resource management. 4) The basic usage includes pulling and running images from DockerHub, and the advanced usage involves managing multi-container applications using DockerCompose. 5) Common errors such as image building failure and container failure to start, you can debug through logs and network configuration. 6) Performance optimization construction

Linux and Docker: Docker on Different Linux DistributionsLinux and Docker: Docker on Different Linux DistributionsApr 19, 2025 am 12:10 AM

The methods of installing and using Docker on Ubuntu, CentOS, and Debian are different. 1) Ubuntu: Use the apt package manager, the command is sudoapt-getupdate&&sudoapt-getinstalldocker.io. 2) CentOS: Use the yum package manager and you need to add the Docker repository. The command is sudoyumininstall-yyum-utils&&sudoyum-config-manager--add-repohttps://download.docker.com/lin

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

Video Face Swap

Video Face Swap

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

Hot Tools

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

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.