Docker connects to the host Mysql operation

Today, the company project needs to configure docker. After successfully installing it on Windows, I found that I could not connect to the local mysql.

I keep reporting permission issues or wrong addresses.

Finally found

1: The address is according to the following ipv4

2: To open the localhost permission on the host Mysql, the command is as follows

mysql -u root -pvmwaremysql>use mysql;

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

mysql>select host, user from user;

Okay, that’s it.

Additional knowledge: The Docker database container cannot be accessed locally, but can be accessed remotely

Preface

In the past, when I used idea to connect to the docker database on the Alibaba Cloud server, I used the server IP and port number. Later, I felt that the open port number of the security group was not safe, and wanted to use localhost, but found that I could not connect.

I thought I could only use the server IP and not localhost, but then I suddenly discovered that each Docker container has its own IP.

1. Enter the container

docker exec -it 8f00a625f3fb bash

2. Check IP

cat /etc/hosts

You can see that my IP is 172.18.0.2

3. Modify the link address

It worked after that.

The above docker connection host Mysql operation is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.