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!

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

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'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.

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 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 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.

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

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


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

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

Hot Article

Hot Tools

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

Atom editor mac version download
The most popular open source editor

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

SublimeText3 English version
Recommended: Win version, supports code prompts!

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.
