前言
1 检查docker是否运行
2 检索mysql镜像
3 下载mysql镜像
下载好后,可以检查是否已经下载成功:
4 使用docker启动mysql数据库容器
5 查看是否启动mysql数据库成功
6 设置mysql数据库的远程链接
进入mysql容器:
登陆mysql数据库:
授权:
重新授权表:
退出mysql:
退出容器
7 Navicat远程链接
---------------------------------------------------------------------------------------------------------------------------------
1 检查docker是否运行
systemctl status docker
Z ~]# systemctl status docker
● docker.service - Docker Application Container Engine
Loaded: loaded (/usr/lib/systemd/system/docker.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2023-02-23 10:48:05 CST; 23h ago
Docs: https://docs.docker.com
Main PID: 735685 (dockerd)
Tasks: 19
Memory: 119.3M
CGroup: /system.slice/docker.service
├─735685 /usr/bin/dockerd -H fd:// --containerd=/run/containerd/containerd.sock
├─752356 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 8081 -container-ip 172.17.0.2 -container-port 8080
└─752360 /usr/bin/docker-proxy -proto tcp -host-ip :: -host-port 8081 -container-ip 172.17.0.2 -container-port 8080
.......................
若没有运行则启动docker:
systemctl start docker
2 检索mysql镜像
docker search mysql
k17gc10Z ~]# docker search mysql
NAME DESCRIPTION STARS OFFICIAL AUTOMATED
mysql MySQL is a widely used, open-source relation… 13847 [OK]
mariadb MariaDB Server is a high performing open sou… 5281 [OK]
percona Percona Server is a fork of the MySQL relati… 599 [OK]
phpmyadmin phpMyAdmin - A web interface for MySQL and M… 744 [OK]
circleci/mysql MySQL is a widely used, open-source relation… 28
bitnami/mysql Bitnami MySQL Docker Image 80 [OK]
bitnami/mysqld-exporter 4
ubuntu/mysql MySQL open source fast, stable, multi-thread… 41
cimg/mysql 0
rapidfort/mysql RapidFort optimized, hardened image for MySQL 14
google/mysql MySQL server for Google Compute Engine 23 [OK]
ibmcom/mysql-s390x Docker image for mysql-s390x 2
rapidfort/mysql8-ib RapidFort optimized, hardened image for MySQ… 0
hashicorp/mysql-portworx-demo 0
newrelic/mysql-plugin New Relic Plugin for monitoring MySQL databa… 1 [OK]
rapidfort/mysql-official RapidFort optimized, hardened image for MySQ… 0
databack/mysql-backup Back up mysql databases to... anywhere! 81
linuxserver/mysql A Mysql container, brought to you by LinuxSe… 38
mirantis/mysql 0
docksal/mysql MySQL service images for Docksal - https://d… 0
vitess/mysqlctld vitess/mysqlctld 1 [OK]
linuxserver/mysql-workbench 48
eclipse/mysql Mysql 5.7, curl, rsync 0 [OK]
drud/mysql 0
silintl/mysql-backup-restore Simple docker image to perform mysql backups… 0 [OK]
NAME:镜像名
DESCRIPTION:说明
STARS:热度
OFFICIAL:是否官方
AUTOMATED:是否自动
3 下载mysql镜像
docker pull mysql:5.7
1k17gc10Z ~]# docker pull mysql:5.7
5.7: Pulling from library/mysql
e048d0a38742: Pull complete
c7847c8a41cb: Pull complete
351a550f260d: Pull complete
8ce196d9d34f: Pull complete
17febb6f2030: Pull complete
d4e426841fb4: Pull complete
fda41038b9f8: Pull complete
f47aac56b41b: Pull complete
a4a90c369737: Pull complete
97091252395b: Pull complete
84fac29d61e9: Pull complete
Digest: sha256:8cf035b14977b26f4a47d98e85949a7dd35e641f88fc24aa4b466b36beecf9d6
Status: Downloaded newer image for mysql:5.7
docker.io/library/mysql:5.7
下载好后,可以检查是否已经下载成功:
docker images
17gc10Z ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
jenkins/jenkins lts f16216f97fcb 2 weeks ago 467MB
mysql 5.7 be16cf2d832a 3 weeks ago 455MB
hello-world latest feb5d9fea6a5 17 months ago 13.3k
REPOSITORY:镜像名
TAG:标签,latest表示为最新的
IMAGE ID:镜像id
CREATED:创建时间
SIZE:大小
上图中表示mysql镜像文件已经下载成功
4 使用docker启动mysql数据库容器
docker run --name mysql -e MYSQL_ROOT_PASSWORD=root -p 3306:3306 -d mysql:5.7
k17gc10Z ~]# docker run --name mysql -e MYSQL_ROOT_PASSWORD=root -p 3306:3306 -d mysql:5.7
68b7dc6f81b01f3c209a66b519633d1a6e8849bb99036fff951dddde83bd3472
-v :指明挂在卷
–restart:自动重启
–name:给容器命名
-e:设置账号密码
-p: 指明宿主机端口:docker内部端口
-d:指明用什么镜像的id启动
c5244d16078bb224ce77c3e6446ab6466a95d5fe801b2269d4c00b0eb0d65319:启动的mysql容器的id
5 查看是否启动mysql数据库成功
docker ps -l
7gc10Z ~]# docker ps -l
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
68b7dc6f81b0 mysql:5.7 "docker-entrypoint.s…" 39 seconds ago Up 38 seconds 0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp mysql
CONTAINER ID:容器id
IMAGES:镜像id
CREATED:创建时间
STATUS:状态
NAME:容器名
到此可知,mysql容器创建成功
6 设置mysql数据库的远程链接
进入mysql容器:
docker exec -it mysql bash
7gc10Z ~]# docker exec -it mysql bash
登陆mysql数据库:
mysql -u root -p"root"
bash-4.2# mysql -u root -p"root"
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.41 MySQL Community Server (GPL)
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
授权:
GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)
重新授权表:
FLUSH PRIVILEGES;
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
退出mysql:
mysql> exit
Bye
退出容器
bash-4.2# exit
exit
7 Navicat远程链接
原文链接:https://blog.csdn.net/qq_44850489/article/details/129195922