docker启动Mysql

cs202@cs202-devbox:~$ sudo docker run -d mysql
7698fdd7a2d05d38cf19c60cc9e35c1117fc551ae5e319144947154f4f353d23
cs202@cs202-devbox:~$ sudo docker ps
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS               NAMES
257646e19a08        ubuntu              "/bin/bash"         26 minutes ago      Up 13 minutes                           desperate_ardinghelli
cs202@cs202-devbox:~$ sudo docker ps -a
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS                      PORTS               NAMES
7698fdd7a2d0        mysql               "/entrypoint.sh mysql"   18 seconds ago      Exited (1) 17 seconds ago                       desperate_swanson
151a8113ba67        mysql               "/entrypoint.sh mysql"   5 minutes ago       Exited (1) 5 minutes ago                        hopeful_williams
257646e19a08        ubuntu              "/bin/bash"              27 minutes ago      Up 13 minutes                                   desperate_ardinghelli
发现并没有成功启动,查看日志:
cs202@cs202-devbox:~$ sudo docker logs desperate_swanson
error: 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


于是设置MYSQL_ROOT_PASSWORD:
sudo docker run  -e MYSQL_ROOT_PASSWORD=wwwwww --name mysql -d mysql
总算启动成功了:
^Ccs202@cs202-devbox:~sudo docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS               NAMES
b50461bd8135        mysql               "/entrypoint.sh mysql"   4 minutes ago       Up 4 minutes        3306/tcp            mysql
257646e19a08        ubuntu              "/bin/bash"              37 minutes ago      Up 23 minutes                           desperate_ardinghelli
cs202@cs202-devbox:~$ 
后台打印出大片日志:
cs202@cs202-devbox:~$ sudo docker logs -f mysql
2016-03-12T02:50:26.302319Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-12T02:50:26.375013Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-12T02:50:26.375515Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-12T02:50:26.444508Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-03-12T02:50:26.446893Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-12T02:50:26.447017Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-12T02:50:26.451067Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-12T02:50:26.504451Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 11991512
2016-03-12T02:50:26.505028Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-03-12T02:50:26.508912Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-12T02:50:26.509170Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-12T02:50:26.509310Z 0 [Note] IPv6 is available.
2016-03-12T02:50:26.509366Z 0 [Note]   - '::' resolves to '::';
2016-03-12T02:50:26.509419Z 0 [Note] Server socket created on IP: '::'.
2016-03-12T02:50:26.509154Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-03-12T02:50:26.519321Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-12T02:50:26.519569Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2016-03-12T02:50:26.544083Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160312  2:50:26
2016-03-12T02:50:26.548848Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-03-12T02:50:26.565564Z 0 [Note] Event Scheduler: Loaded 0 events
2016-03-12T02:50:26.566266Z 0 [Note] mysqld: ready for connections.
Version: '5.7.11'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)




如果需要指定端口的话,加-p选项:
docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -d mysql/mysql-server:latest
要在Docker启动MySQL,你可以按照以下步骤进行操作: 1. 首先,确保你已经安装了Docker,并确保Docker服务正在运行。你可以使用以下命令来重启Docker服务: [2] 2. 拉取MySQL Docker镜像。你可以使用以下命令从Docker Hub上拉取MySQL镜像: [1] 3. 创建MySQL容器。你可以使用以下命令来创建一个MySQL容器: ``` docker run --name mysql-container -e MYSQL_ROOT_PASSWORD=your_password -d mysql/mysql-server ``` 在这个命令中,你需要将`your_password`替换成你想要设置的MySQL root用户的密码。这个命令将创建一个名为`mysql-container`的容器,并在后台运行MySQL服务器。 4. 等待一段时间,直到MySQL容器启动完成。你可以使用以下命令来检查容器的状态: ``` docker ps ``` 如果你看到`mysql-container`容器的状态为"Up",则表示MySQL已成功启动。 现在,你已经成功启动MySQL容器,并且可以通过连接到容器来访问MySQL数据库。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [Docker启动Mysql](https://blog.csdn.net/zk673820543/article/details/77765428)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"] - *2* *3* [如何在 Docker 容器中运行 MySQL](https://blog.csdn.net/allway2/article/details/121583352)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值