车走水寿 發表於 2019-7-24 00:33:00

CentOS 安装Docker 并部署配置MySql

<p><strong><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLTElMjIlMkMlMjJpc1ZvaWQlMjIlM0FmYWxzZSUyQyUyMmRhdGElMjIlM0ElN0IlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMiVFNSU4RCVCOCVFOCVCRCVCRCVFNCVCOSU4QiVFNSU4OSU4RERvY2tlciUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTVEJTdE">先安装Docker</span></strong></p>
<p><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLTElMjIlMkMlMjJpc1ZvaWQlMjIlM0FmYWxzZSUyQyUyMmRhdGElMjIlM0ElN0IlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMiVFNSU4RCVCOCVFOCVCRCVCRCVFNCVCOSU4QiVFNSU4OSU4RERvY2tlciUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTVEJTdE">卸载之前Docker</span></p>
<div class="reset-3c756112--pageContainer-b8151bcc">
<div class="reset-3c756112--pageBody-a91db4ac">
<div class="reset-3c756112--container-960c7c26" data-editioncontainer="true">
<div data-slate-editor="true" data-key="4" data-gramm="false">
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="ff9265fe98c74507ac6e65bad961ab6d"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">如果本地之前安装过Docker，需要先卸载，如果没有安装过，可以跳过这一步：</span>&nbsp;</p>
</div>
</div>
<div class="codeBlock-18b09018">
<div data-key="c25fb72e206046adb4777dbaed887fe2">
<div class="codeLine-3035e01e" data-key="cd93707b16c740cd8ca696ecd8ccfde2">
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)"> 1</span> $ sudu <span style="color: rgba(0, 0, 255, 1)">yum</span><span style="color: rgba(0, 0, 0, 1)"> remove docker \
</span><span style="color: rgba(0, 128, 128, 1)"> 2</span> docker-<span style="color: rgba(0, 0, 0, 1)">client \
</span><span style="color: rgba(0, 128, 128, 1)"> 3</span> docker-client-<span style="color: rgba(0, 0, 0, 1)">latest \
</span><span style="color: rgba(0, 128, 128, 1)"> 4</span> docker-<span style="color: rgba(0, 0, 0, 1)">common \
</span><span style="color: rgba(0, 128, 128, 1)"> 5</span> docker-<span style="color: rgba(0, 0, 0, 1)">latest \
</span><span style="color: rgba(0, 128, 128, 1)"> 6</span> docker-latest-<span style="color: rgba(0, 0, 0, 1)">logrotate \
</span><span style="color: rgba(0, 128, 128, 1)"> 7</span> docker-<span style="color: rgba(0, 0, 0, 1)">logrotate \
</span><span style="color: rgba(0, 128, 128, 1)"> 8</span> docker-<span style="color: rgba(0, 0, 0, 1)">selinux \
</span><span style="color: rgba(0, 128, 128, 1)"> 9</span> docker-engine-<span style="color: rgba(0, 0, 0, 1)">selinux \
</span><span style="color: rgba(0, 128, 128, 1)">10</span> docker-engine</pre>
</div>
‌</div>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<div class="blockHeadingContent-756c9114"><span class="text-4505230f--HeadingH700-04e1a2a3--textContentFamily-49a318e1">使用Repository安装</span></div>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<ul class="list-20526648" data-key="3aaa367da783491d9b6f1b3bf219bc3d">
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="012fab5088b9497ba414bb63834dcfa1">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="ca2756efde7041f3a6cf8f683ae27d31"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">安装之前需要安装 yum-utils提供的yum-config-manager</span></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">1</span> $ <span style="color: rgba(0, 0, 255, 1)">sudo</span> <span style="color: rgba(0, 0, 255, 1)">yum</span> <span style="color: rgba(0, 0, 255, 1)">install</span> -y <span style="color: rgba(0, 0, 255, 1)">yum</span>-<span style="color: rgba(0, 0, 0, 1)">utils \
</span><span style="color: rgba(0, 128, 128, 1)">2</span> device-mapper-persistent-<span style="color: rgba(0, 0, 0, 1)">data \
</span><span style="color: rgba(0, 128, 128, 1)">3</span> lvm2</pre>
</div>
</div>
</li>
</ul>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<ul class="list-20526648" data-key="544a7fddb2194aedb7515c068edad54a">
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="5088c6d02f204beba866e014c018e13a">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="17f7ab2e891a4bef98b81b9228f74c5d"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">安装yum-config-manager</span></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">1</span> $ <span style="color: rgba(0, 0, 255, 1)">sudo</span> <span style="color: rgba(0, 0, 255, 1)">yum</span>-config-<span style="color: rgba(0, 0, 0, 1)">manager \
</span><span style="color: rgba(0, 128, 128, 1)">2</span> --add-<span style="color: rgba(0, 0, 0, 1)">repo \
</span><span style="color: rgba(0, 128, 128, 1)">3</span> https:<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">download.docker.com/linux/centos/docker-ce.repo</span>‌</pre>
</div>
</div>
</li>
</ul>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<div class="blockHeadingContent-756c9114"><span class="text-4505230f--HeadingH700-04e1a2a3--textContentFamily-49a318e1">安装Docker CE</span></div>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<ul class="list-20526648" data-key="e9fdb6e00d314590a92b8b10473a4df6">
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="a716eab2bba64990b466446fa7998f03">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="74f95cebfa004ecd95d5458913af8448"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="802775c140ef4fe5b5aebc08b5e6419d"><span data-offset-key="802775c140ef4fe5b5aebc08b5e6419d:0">安装最新版&nbsp;&nbsp;<span class="cnblogs_code">$ <span style="color: rgba(0, 0, 255, 1)">yum</span> <span style="color: rgba(0, 0, 255, 1)">install</span> docker-ce</span>&nbsp;</span></span></span></p>
</div>
</li>
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="9f20f06ca0b64844836fe467c303c0ae">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="a2856998598043468ea8ac97b35c9938"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">安装指定版本</span></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">1</span> $ <span style="color: rgba(0, 0, 255, 1)">yum</span> list docker-ce --showduplicates | <span style="color: rgba(0, 0, 255, 1)">sort</span> -<span style="color: rgba(0, 0, 0, 1)">r
</span><span style="color: rgba(0, 128, 128, 1)">2</span> docker-ce.x86_64 <span style="color: rgba(128, 0, 128, 1)">18.09</span>.<span style="color: rgba(128, 0, 128, 1)">0</span>.ce-<span style="color: rgba(128, 0, 128, 1)">1</span>.el7.centos docker-ce-<span style="color: rgba(0, 0, 0, 1)">stable
</span><span style="color: rgba(0, 128, 128, 1)">3</span> --<span style="color: rgba(0, 0, 0, 1)"> 然后选择列表中指定版本
</span><span style="color: rgba(0, 128, 128, 1)">4</span> $ <span style="color: rgba(0, 0, 255, 1)">sudo</span> <span style="color: rgba(0, 0, 255, 1)">yum</span> <span style="color: rgba(0, 0, 255, 1)">install</span> docker-ce-&lt;VERSION STRING&gt;</pre>
</div>
</div>
</li>
</ul>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="9aa683b660cf42f1ab5dbc057e2867d7"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">如无特殊要求安装最新版即可</span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--commentsAreaHighlight-e689c7a4">‌</div>
<div class="reset-3c756112--contentWrapper-56f27afc">
<div class="blockHeadingContent-756c9114"><span class="text-4505230f--HeadingH700-04e1a2a3--textContentFamily-49a318e1">配置DockerHub 镜像拉取地址</span></div>
</div>
</div>
<div class="codeBlock-18b09018">
<div class="codeHeader-e3625762--codeHeaderFloating-7f73cde3">&nbsp;
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">1</span> <span style="color: rgba(0, 0, 255, 1)">sudo</span> <span style="color: rgba(0, 0, 255, 1)">mkdir</span> -p /etc/<span style="color: rgba(0, 0, 0, 1)">docker
</span><span style="color: rgba(0, 128, 128, 1)">2</span> <span style="color: rgba(0, 0, 255, 1)">sudo</span> <span style="color: rgba(0, 0, 255, 1)">tee</span> /etc/docker/daemon.json &lt;&lt;-<span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">EOF</span><span style="color: rgba(128, 0, 0, 1)">'</span>
<span style="color: rgba(0, 128, 128, 1)">3</span> <span style="color: rgba(0, 0, 0, 1)">{
</span><span style="color: rgba(0, 128, 128, 1)">4</span> <span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(128, 0, 0, 1)">registry-mirrors</span><span style="color: rgba(128, 0, 0, 1)">"</span>: [<span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(128, 0, 0, 1)">&lt;your accelerate address&gt;</span><span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(0, 0, 0, 1)">]
</span><span style="color: rgba(0, 128, 128, 1)">5</span> <span style="color: rgba(0, 0, 0, 1)">}
</span><span style="color: rgba(0, 128, 128, 1)">6</span> <span style="color: rgba(0, 0, 0, 1)">EOF
</span><span style="color: rgba(0, 128, 128, 1)">7</span> <span style="color: rgba(0, 0, 255, 1)">sudo</span> systemctl daemon-<span style="color: rgba(0, 0, 0, 1)">reload
</span><span style="color: rgba(0, 128, 128, 1)">8</span> <span style="color: rgba(0, 0, 255, 1)">sudo</span> systemctl restart docker</pre>
</div>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="aef546e4bc694de784f68890961c661e"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="4d5fd7ab31ab4a5e816254f94bb00e69"><span data-offset-key="4d5fd7ab31ab4a5e816254f94bb00e69:0"><span class="bold-3c254bd9" data-slate-leaf="true">注意：文中的加速器地址<span data-offset-key="4d5fd7ab31ab4a5e816254f94bb00e69:1"><code class="code-81e98f88--codeBold-3c254bd9" data-slate-leaf="true"><span class="bold-3c254bd9" data-slate-leaf="true">&lt;your accelerate address&gt;</span></code><span data-offset-key="4d5fd7ab31ab4a5e816254f94bb00e69:2"><span class="bold-3c254bd9" data-slate-leaf="true">，请到<span data-key="e11645fee8b4418fb0753ef958089f3d"><span data-offset-key="e11645fee8b4418fb0753ef958089f3d:0"><span class="bold-3c254bd9" data-slate-leaf="true">容器镜像服务控制台</span></span></span><span data-key="75dd17295f3841af852f2e8384a99888"><span data-offset-key="75dd17295f3841af852f2e8384a99888:0"><span class="bold-3c254bd9" data-slate-leaf="true">查看<span data-offset-key="75dd17295f3841af852f2e8384a99888:1">。</span></span></span></span></span></span></span></span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--commentsAreaHighlight-e689c7a4">‌</div>
<div class="reset-3c756112--contentWrapper-56f27afc">
<div class="blockHeadingContent-756c9114"><strong><span class="text-4505230f--HeadingH700-04e1a2a3--textContentFamily-49a318e1">安装MySQL</span></strong></div>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<ul class="list-20526648" data-key="cab4d7d9d73740fc88fd5de605aa487d">
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="4a86b5a22a594caaa72c26857aede2c8">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="f077c379725b4a719fb59731f5f80a9c"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">启动Docker （上一步配置阿里云镜像地址后已经重启，不需要再启动）</span></p>
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="84946084d9f6423d8b92dc0951eb3fd4"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="3ed3fe74cab04dd6bfa1373f05cb977f"><span data-offset-key="3ed3fe74cab04dd6bfa1373f05cb977f:0">CentOS 7 Docker 启动命令&nbsp;&nbsp;<span class="cnblogs_code"><span style="color: rgba(0, 0, 255, 1)">sudo</span> systemctl restart docker</span>&nbsp;</span></span></span></p>
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="9c8c36221ffc4c25a90961c9e7405824"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="95e1541793d84b3ca98d7a700fddefe5"><span data-offset-key="95e1541793d84b3ca98d7a700fddefe5:0">并检查是否使用了镜像: &nbsp;<span class="cnblogs_code">$ <span style="color: rgba(0, 0, 255, 1)">ps</span> -ef|<span style="color: rgba(0, 0, 255, 1)">grep</span> docker</span>&nbsp;<span data-offset-key="95e1541793d84b3ca98d7a700fddefe5:1"><code class="code-81e98f88" data-slate-leaf="true">&nbsp;</code><span data-offset-key="95e1541793d84b3ca98d7a700fddefe5:2">如果后面显示<span data-offset-key="95e1541793d84b3ca98d7a700fddefe5:3"><code class="code-81e98f88" data-slate-leaf="true">registry-mirros</code><span data-offset-key="95e1541793d84b3ca98d7a700fddefe5:4">则成功</span></span></span></span></span></span></span></p>
</div>
</li>
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="d03aacd009b4432fabfab11574e61e48">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="20ba1c7bae4549299f234a241301e8e4"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">安装MySQL(最新版本) </span></p>
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="a2f256ae2a814fa289c4ba2322fa60d2"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="5daa8cf810ba481a98a47a1e7ce66b1c"><span data-offset-key="5daa8cf810ba481a98a47a1e7ce66b1c:0">查看本地镜像：&nbsp;<span class="cnblogs_code">$ <span style="color: rgba(0, 0, 255, 1)">sudo</span> docker images </span>&nbsp;<span data-offset-key="5daa8cf810ba481a98a47a1e7ce66b1c:1"><span data-offset-key="5daa8cf810ba481a98a47a1e7ce66b1c:2">本地没有镜像，则 &nbsp;<span class="cnblogs_code">$ <span style="color: rgba(0, 0, 255, 1)">sudo</span> docker search mysql</span>&nbsp;<span data-offset-key="5daa8cf810ba481a98a47a1e7ce66b1c:3"><span data-offset-key="5daa8cf810ba481a98a47a1e7ce66b1c:4">&nbsp;选择STARS最多的&nbsp;&nbsp;<span class="cnblogs_code">$ <span style="color: rgba(0, 0, 255, 1)">sudo</span> docker pull mysql</span>&nbsp;</span></span></span></span></span></span></span></p>
</div>
</li>
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="948c0574e8264f66adaa48dab53a0817">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="0d4d56a573444bbd9f6c74650e6cca7e"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">安装MySQL(指定版本) </span></p>
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="0f1a99a4273d4c539504746516fc708e">&nbsp;<span class="cnblogs_code">$ <span style="color: rgba(0, 0, 255, 1)">sudo</span> docker pull mysql:<span style="color: rgba(128, 0, 128, 1)">5.7</span></span>&nbsp;</p>
</div>
</li>
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="38defbd6f54749afaafcde0abb28c7d9">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="01cac8b6deb2420c93e0083ae2a0e3a7"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">启动MySQL</span></p>
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="01cac8b6deb2420c93e0083ae2a0e3a7"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">&nbsp;<span class="cnblogs_code">$ <span style="color: rgba(0, 0, 255, 1)">sudo</span> docker run -p <span style="color: rgba(128, 0, 128, 1)">12345</span>:<span style="color: rgba(128, 0, 128, 1)">3306</span> --name mysql -v /root/mysql/conf:/etc/mysql/conf.d -v /root/mysql/logs:/logs -v /root/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=<span style="color: rgba(128, 0, 128, 1)">123456</span> -d mysql:<span style="color: rgba(128, 0, 128, 1)">5.7</span></span>&nbsp; </span></p>
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="745ef501db1b4c8383c47685ba615d25">参数讲解：</p>
<ul class="list-20526648--inList-acdf7afa" data-key="e6df52285e7249daa00ced16c204f755">
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="24c71955d80243e38dcddf2cc9687596">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="68d381d1676245508d7f08ea45b4440e"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">-p是将docker中mysql端口号3306映射成为12345端口,也可以选择不映射，使用默认的3306 </span></p>
</div>
</li>
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="71123c8673ed40c2a9645244d9c8ac4e">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="97a336cca2b943fe98e06cf3e71a7c53"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">--name mysql: 运行服务的取名 </span></p>
</div>
</li>
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="ffa58a7157e141169381903868b642c0">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="ee9cb064c26f44f59d7c498c126afdcc"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">-v是将主机目录下的文件挂载到容器中路径下(/scy是我本人用户) </span></p>
</div>
</li>
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="c3c2100f940c443fbcf68f9e2e285774">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="b19e4d0792b0490ba055c2184027e00b"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">-e MYSQL_ROOT_PASSWORD:初始化root用户密码 </span></p>
</div>
</li>
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="b0ababa42149469ab95bbd0dbc97710d">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="0163cb2d864b4cbfa96aa3964b98673d"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">-d mysql:5.7 : 后台运行mysql5.7</span></p>
</div>
</li>
</ul>
</div>
</li>
<li>
<div class="reset-3c756112--listItemContent-756c9114" data-key="0bff5f4be6af4dac935ab93d71980266">
<p class="blockParagraph-544a408c--noMargin-acdf7afa" data-key="0169d36dde3248f8aad19cfdad811274"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">至此，安装运行就结束了。</span></p>
</div>
</li>
</ul>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--commentsAreaHighlight-e689c7a4">‌</div>
<div class="reset-3c756112--contentWrapper-56f27afc">
<div class="blockHeadingContent-756c9114"><strong><span class="text-4505230f--HeadingH700-04e1a2a3--textContentFamily-49a318e1">配置MySQL中文编码</span></strong></div>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--commentsAreaHighlight-e689c7a4">‌</div>
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="307f9611403a45ae9d686a9d6d8291c3"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="dfb500dbd2094d55938efd17c5371886"><span data-offset-key="dfb500dbd2094d55938efd17c5371886:0"><span class="bold-3c254bd9" data-slate-leaf="true">进入容器</span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="bbf625c0b63d4b9d9e66968366ef6cf3">&nbsp;<span class="cnblogs_code">docker exec -it mysql /bin/bash</span>&nbsp;</p>
<p class="blockParagraph-544a408c" data-key="bbf625c0b63d4b9d9e66968366ef6cf3"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="def8669a5ada467aa54f859f5a4fbe51"><span data-offset-key="def8669a5ada467aa54f859f5a4fbe51:0"><span data-offset-key="def8669a5ada467aa54f859f5a4fbe51:1">mysql指定的–name</span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="b8115fd0421a454f8b0c3f0b0b73d598"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="c8e4cadb3f724af18c962fe38dd4128c"><span data-offset-key="c8e4cadb3f724af18c962fe38dd4128c:0"><span class="bold-3c254bd9" data-slate-leaf="true">进入mysql</span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="e25f5717968545e5a820d4d093d044fa">&nbsp;<span class="cnblogs_code">root@e34aba02c0c3:/# mysql -u root -p</span>&nbsp;</p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="d1a1c53b6f78406886ad160d72484658"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="df1c996bad9a4210ba380e01e7d2c3d8"><span data-offset-key="df1c996bad9a4210ba380e01e7d2c3d8:0"><span class="bold-3c254bd9" data-slate-leaf="true">查看数据库字符集</span></span></span></span></p>
</div>
</div>
<div class="codeBlock-18b09018">
<div data-key="b069691140ec4f9eb1ffcba6e57d62f2">
<div class="codeLine-3035e01e" data-key="d63e44c110034650ab9a7687a9e50125">
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)"> 1</span> mysql&gt; SHOW VARIABLES LIKE <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">characterset%</span><span style="color: rgba(128, 0, 0, 1)">'</span>; --<span style="color: rgba(0, 0, 0, 1)">默认是瑞典latin1
</span><span style="color: rgba(0, 128, 128, 1)"> 2</span> mysql&gt; SHOW VARIABLES LIKE <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">collation_%</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 128, 128, 1)"> 3</span> +----------------------+--------------------+
<span style="color: rgba(0, 128, 128, 1)"> 4</span> | Variable_name | Value |
<span style="color: rgba(0, 128, 128, 1)"> 5</span> +----------------------+--------------------+
<span style="color: rgba(0, 128, 128, 1)"> 6</span> | collation_connection | latin1_swedish_ci |
<span style="color: rgba(0, 128, 128, 1)"> 7</span> | collation_database | utf8mb4_0900_ai_ci |
<span style="color: rgba(0, 128, 128, 1)"> 8</span> | collation_server | utf8mb4_0900_ai_ci |
<span style="color: rgba(0, 128, 128, 1)"> 9</span> +----------------------+--------------------+
<span style="color: rgba(0, 128, 128, 1)">10</span> <span style="color: rgba(128, 0, 128, 1)">3</span> rows <span style="color: rgba(0, 0, 255, 1)">in</span> set (<span style="color: rgba(128, 0, 128, 1)">0.00</span> sec)</pre>
</div>
</div>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="75c33b332dc4436db77d29dc62a623a8"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">connection 就是我们通过客户端连接的时候指定的编码。 外部访问数据乱码的问题就出在这个connection连接层上</span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="1b8679410603462c8e148e8441d5fd64"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="3db1bf1ecc4b4dcaa2da4f18b88709c2"><span data-offset-key="3db1bf1ecc4b4dcaa2da4f18b88709c2:0"><span class="bold-3c254bd9" data-slate-leaf="true">修改为utf-8</span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="ecfc16a9660044f3b8680ec7a5f72b22">&nbsp;<span class="cnblogs_code">SET NAMES <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">utf8</span><span style="color: rgba(128, 0, 0, 1)">'</span>;</span>&nbsp;</p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="8a8c280dcedd4118b81911e85d2a1ab4"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="d1e02c2779be4718b9e4dcd500b5a3a8"><span data-offset-key="d1e02c2779be4718b9e4dcd500b5a3a8:0"><span class="bold-3c254bd9" data-slate-leaf="true">修改配置文件</span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="39a4f9946865471eac662576e7a3c9cc"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="2d80cfc29f5f47bfbf0cc5915e34e42c"><span data-offset-key="2d80cfc29f5f47bfbf0cc5915e34e42c:0">mysql 服务器配置文件 <span data-offset-key="2d80cfc29f5f47bfbf0cc5915e34e42c:1"><code class="code-81e98f88" data-slate-leaf="true">/etc/mysql/mysql.conf.d/mysqld.cnf</code></span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="6b7db5afc0214fbab6c297a44ea0196e"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">修改过程中需要安装vi 或者 vim，然而docker镜像内镜像源没有速度，所以更新速度慢</span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="0bbc91194dd647b68d9b2924de5bb3be"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="422822fc430f4a2f95c6abefb9aae74e"><span data-offset-key="422822fc430f4a2f95c6abefb9aae74e:0">可以通过&nbsp;<span class="cnblogs_code">docker <span style="color: rgba(0, 0, 255, 1)">cp</span> d606:/etc/mysql/mysql.conf.d/mysqld.cnf /root/mysql/mysqld.cnf </span>&nbsp;<span data-offset-key="422822fc430f4a2f95c6abefb9aae74e:1"><span data-offset-key="422822fc430f4a2f95c6abefb9aae74e:2">命令将文件拷贝出来修改后同样拷贝回去的方式修改</span></span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="f5c28ecf9eae46869a896c5fbd27d4ed"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="0b668e0a87fa436d8d5ef985fe7dfe81"><span data-offset-key="0b668e0a87fa436d8d5ef985fe7dfe81:0"> 标签下添加 <span data-offset-key="0b668e0a87fa436d8d5ef985fe7dfe81:1"><code class="code-81e98f88" data-slate-leaf="true">character_set_server = utf8</code></span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="6ab7e9392a254942bd06e54cbf701d8f"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="b33a91e1678e4e95a1ad7f6cb10d55a8"><span data-offset-key="b33a91e1678e4e95a1ad7f6cb10d55a8:0"> 标签下添加 <span data-offset-key="b33a91e1678e4e95a1ad7f6cb10d55a8:1"><code class="code-81e98f88" data-slate-leaf="true">default-character-set=utf8</code></span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="0cf4fb4b1d20490aa025180c4880c21c"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="70c8b53c295c429ba07f99272a57e5f3"><span data-offset-key="70c8b53c295c429ba07f99272a57e5f3:0"> 标签下添加 <span data-offset-key="70c8b53c295c429ba07f99272a57e5f3:1"><code class="code-81e98f88" data-slate-leaf="true">default-character-set=utf8</code></span></span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="1e6276ce81714bdfb76957ba0f907da0"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">上面的配置需要紧跟标签，否则无法启动mysql</span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="7d90a3bded9d4ec78ba50e47a44e6c57"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="5b4a4d9496e0437d9b560b753297bccc"><span data-offset-key="5b4a4d9496e0437d9b560b753297bccc:0">配置docker开机自启&nbsp;&nbsp;<span class="cnblogs_code">systemctl enable docker.service</span>&nbsp;</span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="f2413325af3c445eaf171e27264f62bd"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1"><span data-key="60d8796cfa3942569e6e06e30f99c701"><span data-offset-key="60d8796cfa3942569e6e06e30f99c701:0">配置mysql 自动启动&nbsp;&nbsp;<span class="cnblogs_code">docker update --restart=always d606</span>&nbsp;</span></span></span></p>
</div>
</div>
<div class="reset-3c756112--commentsArea-56f27afc">
<div class="reset-3c756112--commentsAreaHighlight-e689c7a4">‌</div>
<div class="reset-3c756112--contentWrapper-56f27afc">
<p class="blockParagraph-544a408c" data-key="b431d3b389d64ad6817812ba81c701ce"><span class="text-4505230f--TextH400-3033861f--textContentFamily-49a318e1">至此 通过docker部署并配置MySQL完成</span></p>
</div>
</div>
<p class="blockParagraph-544a408c" data-key="b6ca38c4e8f04e65886d7d217b9f31cc">&nbsp;</p>
</div>
</div>
</div>
</div><br><br>
来源：https://www.cnblogs.com/tanq/p/11235356.html
頁: [1]
查看完整版本: CentOS 安装Docker 并部署配置MySql