Example of how to create and run multiple MySQL containers in Docker

1. Use the mysql/mysql-server:latest image to quickly start a MySQL instance

docker run --name ilink_user_01 -e MYSQL_ROOT_PASSWORD=123456 0d 0p 3307:3306 mysql/mysql-server:latest 

• ilink_user_01 is the container name, specified by the --name command
• 123456 is the password of the database root. -e specifies the environment MYSQL_ROOT_PASSWORD to 123456. -e (specifies the environment variables in the container)
• -d With the -d parameter, the container will enter the background, and the user cannot see the information in the container or perform operations
• 3307:3306 is the port mapping, which specifies that the local host port 3307 is mapped to the container's port 3306

2. Enter the instance to modify the mysql configuration information

docker exec -it ilink_user_01 bash 

• exec can execute human commands directly inside the container
• The -it parameter is used to save the table input to open, without affecting other applications in the container, the user can easily interact with the container

3. View all users in the MYSQL database

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user; 

4. Modify the root user of mysql to allow login from any ip

update mysql.user set host='%' where user='root';

flush privileges; 

5. Test the connection using navicat

The authentication plugin 'caching_sha2_password' appears because the MySQL image is encrypted using caching_sha2_password, and Navicat does not support the caching_sha2_password encryption method.

6. Solve the authentication plugin 'caching_sha2_password'

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; 

7. Re-use navicat connection

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.