How to connect Navicat to the docker database on the server

Start the mysql container in docekr

Use command:

docker run -p 3306:3306 --name mysql01 -e MYSQL_ROOT_PASSWORD=xxx -d mysql:5.7

-p 3306:3306 means mapping port 3306 in docker to port 3306 on the host. –name mysql01 means the container is named mysql01
-e MYSQL_ROOT_PASSWORD=xxx Set the password of mysql, which will be used later
-d mysql:5.7 Use mysql image

Results after successful operation

Open the server port 3306 for access

Configure inbound rules in the security group to allow remote access to port 3306.

Navcat Visits

The connection name is the server IP address. The password is the password used to enable the Docker container configuration above. Click OK to connect.

This is the end of this article about Navicat connecting to the docker database on the server side. For more information about Navicat connecting to the docker database, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!