在centos7下安装docker并安装MySQL并且Navicat连接

在centos7下安装docker并安装MySQL并且Navicat连接

一、在centos7下安装docker

1、查看系统中是否安装docker

[root@bogon /]# docker version
bash: docker: command not found...

出现此提示，系统中没有安装docker

2、查看自己的版本是否合适，Docker 要求 CentOS 系统的内核版本高于 3.10

[root@bogon /]# uname -a
Linux bogon 3.10.0-957.el7.x86_64 #1 SMP Thu Nov 8 23:39:32 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

3、更新yum

[root@bogon /]# yum update

等待yum更新完成，中途会提示输入，打‘y’就好

4、安装docker

[root@bogon /]# yum install -y docker

-y 不用再点y确定

5、查看docker版本

[root@bogon /]# docker --version
Docker version 1.13.1, build 7d71120/1.13.1

6、启动docker并设置开机自启动

[root@bogon /]# systemctl start docker
[root@bogon /]# systemctl enable docker
Created symlink from /etc/systemd/system/multi-user.target.wants/docker.service to /usr/lib/systemd/system/docker.service.

7、查看docker状态

[root@bogon /]# systemctl status docker
● docker.service - Docker Application Container Engine
   Loaded: loaded (/usr/lib/systemd/system/docker.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2022-08-12 01:57:17 PDT; 26s ago
     Docs: http://docs.docker.com
 Main PID: 96840 (dockerd-current)
   CGroup: /system.slice/docker.service
           ├─96840 /usr/bin/dockerd-current --add-runtime docker-runc=/usr/libexec/docker/docker-runc-current --default-runtime=docker-runc --exec-opt native.cgroupdriver=systemd --userlan...
           └─96845 /usr/bin/docker-containerd-current -l unix:///var/run/docker/libcontainerd/docker-containerd.sock --metrics-interval=0 --start-timeout 2m --state-dir /var/run/docker/lib...

Aug 12 01:57:15 bogon dockerd-current[96840]: time="2022-08-12T01:57:15.591215662-07:00" level=info msg="libcontainerd: new containerd process, pid: 96845"
Aug 12 01:57:16 bogon dockerd-current[96840]: time="2022-08-12T01:57:16.720901154-07:00" level=info msg="Graph migration to content-addressability took 0.00 seconds"
Aug 12 01:57:16 bogon dockerd-current[96840]: time="2022-08-12T01:57:16.723358095-07:00" level=info msg="Loading containers: start."
Aug 12 01:57:16 bogon dockerd-current[96840]: time="2022-08-12T01:57:16.951130926-07:00" level=info msg="Firewalld running: true"
Aug 12 01:57:17 bogon dockerd-current[96840]: time="2022-08-12T01:57:17.363956386-07:00" level=info msg="Default bridge (docker0) is assigned with an IP address 172.17.0.0/16. ... IP address"
Aug 12 01:57:17 bogon dockerd-current[96840]: time="2022-08-12T01:57:17.670125994-07:00" level=info msg="Loading containers: done."
Aug 12 01:57:17 bogon dockerd-current[96840]: time="2022-08-12T01:57:17.722824046-07:00" level=info msg="Daemon has completed initialization"
Aug 12 01:57:17 bogon dockerd-current[96840]: time="2022-08-12T01:57:17.722903961-07:00" level=info msg="Docker daemon" commit="7d71120/1.13.1" graphdriver=overlay2 version=1.13.1
Aug 12 01:57:17 bogon systemd[1]: Started Docker Application Container Engine.
Aug 12 01:57:17 bogon dockerd-current[96840]: time="2022-08-12T01:57:17.728969198-07:00" level=info msg="API listen on /var/run/docker.sock"
Hint: Some lines were ellipsized, use -l to show in full.

二、在docker中拉入mysql镜像

1、建立拉取路径并进入

[root@bogon /]# mkdir /home/cobra/mysql
[root@bogon /]# cd /home/cobra/mysql/

2、拉取镜像

[root@bogon /]# docker pull mysql:8.0

3、在mysql目录下创建日志文件夹log

[root@bogon mysql]# mkdir log

4、启动mysql

[root@bogon mysql]# docker run -itd --name mysql -p 3306:3306 \
> --privileged=true \
> -e MYSQL_ROOT_PASSWORD=123456 mysql:8.0 \
> --character-set-server=utf8mb4;

端口号3306，账号root，密码123456
5、查看mysql是否已经启动

[root@bogon mysql]# docker ps -a
CONTAINER ID        IMAGE               COMMAND                  CREATED              STATUS              PORTS                               NAMES
44a98a3e4a04        mysql:8.0           "docker-entrypoint..."   About a minute ago   Up About a minute   0.0.0.0:3306->3306/tcp, 33060/tcp   mysql

用Navicat连接数据库

由于mysql8.0采用加密技术Navicat无法解析，所以修改如下
1、进入mysql镜像

[root@bogon mysql]# docker exec -it mysql bash
bash-4.4# 

bash-4.4# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.30 MySQL Community Server - GPL

Copyright (c) 2000, 2022, 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.

mysql>

2、修改参数
use mysql

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

修改加密方式

mysql> alter user 'root'@'%' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.03 sec)

刷新配置环境

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

3、用Navicat进行连接

（第一次编写，大家多多包涵）