Tutorial on installing MySQL with Docker and implementing remote connection

Pull the image

docker pull mysql

View the completed image

docker images

Create and start a MySQL container through the image

docker run --name mysql_dev -e MYSQL_ROOT_PASSWORD=123456 -p 3333:3306 -d mysql

–name: Name the newly created container, here named mysql_dev
-e: Configuration information, here configure the login password of the mysql root user
-p: port mapping, here map the host port 3333 to the container mysql_dev port 3306
-d: Output the complete ID of the container after successfully starting the container\The last mysql refers to the mysql image name

At this point, use navicat for mysql to connect to mysql and find an error:
Client does not support authentication protocol requested by server. . .
Solve it at the bottom ^ _ ^

View all installed containers

docker ps -a

View the started container

docker ps

Stop/start services in the container

docker stop mysql_dev
docker start mysql_dev

Entering the container

docker exec -it mysql_dev bash

View the IP address of the service in the container

docker exec -it mysql_dev cat /etc/hosts

The new version of MySQL reports an error when authorizing a user: near 'IDENTIFIED BY 'password' with grant option' at line 1

1 Question:

When using the grant permission list on the database to 'user name'@' access host' identified by 'password'; the error "......near 'identified by 'password'' at line 1" will appear

2 reasons:

Because the new version of MySQL has separated the way to create accounts and grant permissions

3 Solutions:

Create an account: create user 'user name'@'access host' identified by 'password';
Grant permissions: grant permission list on database to 'user name'@'access host'; (add with grant option at the end when modifying permissions)

4 Specific operations:

# Add user CREATE USER 'mysql_dev' IDENTIFIED BY '123456';
# Grant permissions GRANT ALL PRIVILEGES ON *.* TO 'mysql_dev'@'%';
# Modify encryption rules ALTER USER 'mysql_dev'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
# Update the user's password ALTER USER 'mysql_dev'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
# Update configuration information FLUSH PRIVILEGES;

The above is the details of the tutorial on how to install MySQL with Docker and realize remote connection. For more information about installing MySQL with Docker and realizing remote connection, please pay attention to other related articles on 123WORDPRESS.COM!