Docker安装MySQL示例
1.错误尝试~
[root@hadoop101 ~]# docker run --name=mysql5 -d mysql:5.7
0704c4ecd614aef607561ea8b5aa94bb799453ffebca8f7941078d853db7b581
[root@hadoop101 ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
Mysql退出来,发现并没有运行的容器。
2.原因分析:查看mysql容器的日志: docker logs container-id
错位日志:密码项没有指定
[root@hadoop101 ~]# docker logs 0704c4ecd614
2020-05-17 07:57:35+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.30-1debian10 started.
2020-05-17 07:57:36+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2020-05-17 07:57:36+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.30-1debian10 started.
2020-05-17 07:57:36+00:00 [ERROR] [Entrypoint]: Database is uninitialized and password option is not specified
You need to specify one of MYSQL_ROOT_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD and MYSQL_RANDOM_ROOT_PASSWORD
[root@hadoop101 ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
0704c4ecd614 mysql:5.7 "docker-entrypoint.s…" 44 seconds ago Exited (1) 42 seconds ago mysql5
3.查看所有容器的id : docker ps -aq
[root@hadoop101 ~]# docker ps -aq
6da0ae9a729d
b14b78940c54
7d7877091164
a2a5dde0e25f
ffa1878485cd
481a8b97d7a6
14bf86841e7f
1c47f3115d61
0d25c3ec315c
f81a568b92ff
6b9b8a79841d
a8ee730df7bf
5aed62e3d810
(2)删除所有的容器
[root@hadoop101 ~]# docker rm `docker ps -aq`
4.正确的启动方式
查看官方文档:得出答案
命令为:docker run --name mysql5 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
[root@hadoop101 ~]# docker run --name mysql5 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
2a4c85186f8a577718f8dd07a468f436c5c26b932f37878b8db3cb58b94cba0e
[root@hadoop101 ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
2a4c85186f8a mysql:5.7 "docker-entrypoint.s…" 12 seconds ago Up 9 seconds 3306/tcp, 33060/tcp mysql5
5.测试Mysql的连接
进行端口映射:
[root@localhost ~]# docker run -p 3306:3306 --name mysql02 -e MYSQL_ROOT_PASSWORD=123456 -d mysql
几个其他的高级操作
docker run --name mysql03 -v /conf/mysql:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag
把主机的/conf/mysql文件夹挂载到 mysqldocker容器的/etc/mysql/conf.d文件夹里面
改mysql的配置文件就只需要把mysql配置文件放在自定义的文件夹下(/conf/mysql)
docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
指定mysql的一些配置参数