Docker-使用 Docker 安装运行 mysql

1
2
3
4
5
6

$ docker pull mysql
# 查看
$ docker image ls
REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
mysql               latest              0c27e8e5fcfa        6 hours ago         546MB
hello-world         latest              bf756fb1ae65        3 months ago        13.3kB

1

$ docker run -p 3306:3306 --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag

1
2
3
4
5

run                 运行一个docker容器
--name           	后面这个是生成的容器的名字some-mysql
-p 3306:3306  		表示这个容器中使用3306（第二个）映射到本机的端口号也为3306（第一个） 
-e MYSQL_ROOT_PASSWORD=123456  初始化root用户的密码
-d                   表示使用守护进程运行，即服务挂在后台

1
2
3
4

# 查看当前容器运行状态
$ docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                 NAMES
94e4725784bb        mysql:8.0           "docker-entrypoint.s…"   5 seconds ago       Up 4 seconds        3306/tcp, 33060/tcp   chitchat

1

$ docker exec -it chitchat bash

1

$ docker logs chitchat

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

root@94e4725784bb:/# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.19 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

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>

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

package tes

import (
	"database/sql"
	"fmt"

	_ "github.com/go-sql-driver/mysql"
)

func query() {
	//"用户名:密码@[连接方式](主机名:端口号)/数据库名"
	db, _ := sql.Open("mysql", "root:****@(127.0.0.1:3306)/chitchat") // 设置连接数据库的参数
	defer db.Close()                                                  //关闭数据库
	err := db.Ping()                                                  //连接数据库
	if err == nil {
		fmt.Println("数据库连接成功")
		return
	}
}

1
2
3
4
5
6

$ docker exec -it chitchat bash                                                                                         root@cd6182d13e68:/# exit
exit

$ docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                               NAMES
cd6182d13e68        mysql               "docker-entrypoint.s…"   11 hours ago        Up 8 minutes        0.0.0.0:3306->3306/tcp, 33060/tcp   chitchat

1

$ docker attach chitchat

1

$ docker start chitchat