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!

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

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

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

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

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

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

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)

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.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Dreamweaver CS6
Visual web development tools

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
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 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
Powerful PHP integrated development environment
