Tutorial on installing MySQL with Docker and implementing remote connection

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!

You may also be interested in:
  • Docker enables secure TLS remote connection access
  • How to set up vscode remote connection to server docker container
  • Docker deploys mysql remote connection to solve 2003 problems
  • Detailed example of remotely connecting to Docker using TLS encrypted communication
  • Docker deploys mysql to achieve remote connection sample code
  • Detailed explanation of docker daemon remote connection settings
  • Implementation example of Docker remote connection settings

<<:  Causes and solutions for MySQL deadlock

>>:  JavaScript to achieve text expansion and collapse effect

Recommend

How to manage docker through UI

Docker is being used in more and more scenarios. ...

Basic usage knowledge points of mini programs (very comprehensive, recommended!)

Table of contents What to do when registering an ...

Simple implementation of mini-vue rendering

Table of contents Preface Target first step: Step...

CSS injection knowledge summary

Modern browsers no longer allow JavaScript to be ...

In-depth understanding of React Native custom routing management

Table of contents 1. Custom routing 2. Tab naviga...

Detailed explanation of CSS background and border tag examples

1. CSS background tag 1. Set the background color...

Website Color Schemes Choosing the Right Colors for Your Website

Does color influence website visitors? A few year...

Detailed explanation of how to use Vue self-nested tree components

This article shares with you how to use the Vue s...

mysql create database, add users, user authorization practical method

1. Create a MySQL database 1. Create database syn...

How to choose the format when using binlog in MySQL

Table of contents 1. Three modes of binlog 1.Stat...

Analysis of the advantages of path.join() in Node.js

You might be wondering why you should use the pat...

Independent implementation of nginx container configuration file

Create a container [root@server1 ~]# docker run -...

HTML Web Page List Tags Learning Tutorial

HTML web page list tag learning tutorial. In HTML ...

A brief analysis of the difference between FIND_IN_SET() and IN in MySQL

I used the Mysql FIND_IN_SET function in a projec...