How 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!