安装docker并使用docker安装mysql
<h2 id="安装docker">安装Docker</h2><p>1、 Docker 教程地址：https://www.runoob.com/docker/centos-docker.install.html</p>
<p>2、安装docker</p>
<p><code>命令：</code><strong>yum install docker-io</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117101741451-1569310487.png"></p>
<p>3、启动docker</p>
<p><code>命令：</code><strong>service docker start</strong></p>
<p>4、查看docker是否启动成功</p>
<p><code>命令：</code><strong>ps -ef|grep docker</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117101828525-1093983928.png"></p>
<h2 id="使用docker安装mysql">使用docker安装mysql</h2>
<p>1、查询mysql</p>
<p><code>命令：</code><strong>docker search mysql</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117101856198-2062475079.png"></p>
<p>2、安装mysql</p>
<p><code>命令：</code><strong>docker pull mysql</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117101907475-1388871070.png"></p>
<p>3、查看镜像</p>
<p><code>命令：</code><strong>docker images</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117101920800-1067185475.png"></p>
<p>4、在opt下创建文件夹</p>
<p><code>命令：</code><strong>cd /opt/</strong></p>
<p><code>命令：</code><strong>mkdir mysql_docker</strong></p>
<p><code>命令：</code><strong>cd mysql_docker/</strong></p>
<p><code>命令：</code><strong>echo $PWD</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117101933202-1072982636.png"></p>
<p>5、启动mysql容器，在var/lib/docker/containers/下查看容器</p>
<p><code>命令：</code><strong>docker run --name mysqlserver -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d -i -p 3306:3306 mysql:latest</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117101951542-1388225438.png"></p>
<p><code>命令：</code><strong>cd /var/lib/docker/containers/</strong></p>
<p>6、查看mysql进程</p>
<p><code>命令：</code><strong>docker ps -a</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117102003235-1426406656.png"></p>
<p>7、进入mysql容器，并登陆mysql</p>
<p><code>命令：</code><strong>docker exec -it mysqlserver bash</strong></p>
<p><code>命令：</code><strong>mysql -uroot -p</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117102011980-2122252374.png"></p>
<p>8、开启远程访问权限</p>
<p><code>命令：</code><strong>use mysql;</strong></p>
<p><code>命令：</code><strong>select host,user from user;</strong></p>
<p><code>命令：</code><strong>ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';</strong></p>
<p><code>命令：</code><strong>flush privileges;</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117102022439-1012036839.png"></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117102030619-917697046.png"></p>
<p>镜像里面 root用户已经有远程连接权限在里面，所以不需要去设置，只是模式不一样才导致无法连接，把root用户的密码改成 mysql_native_password 模式，即可远程连接</p>
<h2 id="查看docker日志">查看docker日志</h2>
<p><code>命令：</code><strong>docker logs -f --tail 10 a4dac74d48f7</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117102048856-1273275706.png"></p>
<h2 id="常用命令">常用命令</h2>
<ul>
<li>查看进程</li>
</ul>
<p><code>命令：</code><strong>docker ps -a</strong></p>
<ul>
<li>关闭docker中mysql容器</li>
</ul>
<p><code>命令：</code><strong>docker stop mysqlserver</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117102059917-479100535.png"></p>
<ul>
<li>重启docker中mysql重启</li>
</ul>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117102109562-1174307222.png"></p>
<ul>
<li>重启docker</li>
</ul>
<p><code>命令：</code><strong>systemctl restart docker</strong></p>
<ul>
<li>关闭docker</li>
</ul>
<p><code>命令：</code><strong>systemctl stop docker</strong></p>
<p><img src="https://img2018.cnblogs.com/blog/997646/202001/997646-20200117102119312-1224236083.png"></p><br><br>
来源：https://www.cnblogs.com/jiefu/p/12204555.html
頁:
[1]