How to install mysql in docker

I recently deployed Django and didn't want to install MySQL manually, so I tried to use Docker. I summarized the installation experience. These prerequisites are after installing Docker:

1. View the mysql image;

 docker search mysql 

2. If there is an image, pull the latest image directly

docker pull mysqlv:latest

3. Start the mysql image

```shell
docker run –name w-mysql -e MYSQL_ROOT_PASSWORD=123456 -p 3306:3306 -d mysql:latest

–name: Name the newly created container, here named w-mysql

-e: Configuration information, here configure the login password of the mysql root user
-p: port mapping, which means that port 3306 is used in this container. The second port mapped to the local machine is also 3306.
-d: Output the full ID of the container after successfully starting the container

4. Log in to mysql

```shell
docker exec -it w-mysql mysql -uroot -p 

5. Create a user who can connect remotely

create user 'tantan404' identified with mysql_native_password by '123456';
grant all privileges on *.* to 'tantan404';

6. Try to connect using Navicat

7. Possible Errors

This error may be reported when connecting because the encryption rule of the new version of MySQL is not supported. The encryption rule in versions before MySQL 8 is mysql_native_password, and after MySQL 8, the encryption rule is caching_sha2_password. There are two ways to solve the problem. One is to upgrade the navicat driver, and the other is to restore the encryption rule of the MySQL user login password to mysql_native_password. I used the second method:
The operation is as follows:

ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #Modify the encryption rule, 'password' is your password ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; #Update the user's password, 'password' is your password FLUSH PRIVILEGES; #Refresh permissions

8. End

Simple mysql installation based on docker, make a record

The above is the details of how to install MySQL in docker. For more information about installing MySQL in docker, please pay attention to other related articles on 123WORDPRESS.COM!