Docker10-实战-快速搭建wordpress

admin

<h1 id="docker10-实战-快速搭建wordpress" style="margin: 10px 0px; padding: 0px; list-style-type: none; list-style-image: none; font-size: 28px; line-height: 1&#46;5; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"><span style="font-size: 14px;">安装成功！</span><span style="font-family: Arial; font-size: 14px;">&#65279;</span></h1><p style="margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"></p><div class="toc" style="color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"><div class="toc-container-header">目录</div><ul style="margin: 0px 0px 0px 30px; padding: 0px; list-style: none;"><li style="margin: 0px; padding: 0px; list-style-type: disc; list-style-image: none;"><a href="https://www&#46;cnblogs&#46;com/itzixueba/p/13945628&#46;html#docker10-实战-快速搭建wordpress" style="text-decoration-line: none; color: rgb(51, 153, 255);">Docker10-实战-快速搭建wordpress</a><ul style="margin: 0px 0px 0px 30px; padding: 0px; list-style: none;"><li style="margin: 0px; padding: 0px; list-style-type: circle; list-style-image: none;"><a href="https://www&#46;cnblogs&#46;com/itzixueba/p/13945628&#46;html#wordpress介绍" style="text-decoration-line: none; color: rgb(51, 153, 255);">wordpress介绍</a></li><li style="margin: 0px; padding: 0px; list-style-type: circle; list-style-image: none;"><a href="https://www&#46;cnblogs&#46;com/itzixueba/p/13945628&#46;html#传统方式搭建wordpress运行环境的弊端" style="text-decoration-line: none; color: rgb(51, 153, 255);">传统方式搭建wordpress运行环境的弊端</a></li><li style="margin: 0px; padding: 0px; list-style-type: circle; list-style-image: none;"><a href="https://www&#46;cnblogs&#46;com/itzixueba/p/13945628&#46;html#使用docker快速构建wordpress" style="text-decoration-line: none; color: rgb(51, 153, 255);">使用Docker快速构建wordpress</a></li></ul></li></ul></div><p style="margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"></p><h2 id="wordpress介绍" style="margin: 10px 0px; padding: 0px; list-style-type: none; list-style-image: none; font-size: 21px; line-height: 1&#46;5; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">wordpress介绍</h2><p style="margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">wordpress是使用PHP语言开发的博客平台，用户可以在支持PHP和MySQL数据库的服务器上架设属于自己的网站。</p><h2 id="传统方式搭建wordpress运行环境的弊端" style="margin: 10px 0px; padding: 0px; list-style-type: none; list-style-image: none; font-size: 21px; line-height: 1&#46;5; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">传统方式搭建wordpress运行环境的弊端</h2><p style="margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">需要安装大量的软件和配置，如Apache或nginx，PHP，集成Apache和PHP运行环境，安装MySQL</p><h2 id="使用docker快速构建wordpress" style="margin: 10px 0px; padding: 0px; list-style-type: none; list-style-image: none; font-size: 21px; line-height: 1&#46;5; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">使用Docker快速构建wordpress</h2><ol style="margin: 0px 0px 0px 20px; padding: 0px 0px 0px 40px; list-style: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"><li style="margin: 0px; padding: 0px; list-style-type: decimal; list-style-image: none;">下载wordpress镜像</li></ol><pre style="overflow: auto; margin-top: 0px; margin-bottom: 0px; padding: 0px; list-style-type: none; list-style-image: none; font-family: &quot;Courier New&quot;, Courier, monospace; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);"><code class="hljs ruby" style="font-family: &quot;Courier New&quot;, sans-serif; background: rgb(245, 245, 245); color: black; display: block; border: 1px solid rgb(204, 204, 204); padding: 5px; border-radius: 3px; overflow-x: auto; line-height: 1&#46;5; margin: 0px;">root@ubuntu<span class="hljs-symbol" style="color: rgb(0, 176, 232);">:/home/guanfuchang</span><span class="hljs-comment" style="color: rgb(0, 128, 0);"># docker pull wordpress</span>
</code></pre><ol style="margin: 0px 0px 0px 20px; padding: 0px 0px 0px 40px; list-style: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"><li style="margin: 0px; padding: 0px; list-style-type: decimal; list-style-image: none;">下载mysql镜像</li></ol><pre style="overflow: auto; margin-top: 0px; margin-bottom: 0px; padding: 0px; list-style-type: none; list-style-image: none; font-family: &quot;Courier New&quot;, Courier, monospace; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);"><code class="hljs ruby" style="font-family: &quot;Courier New&quot;, sans-serif; background: rgb(245, 245, 245); color: black; display: block; border: 1px solid rgb(204, 204, 204); padding: 5px; border-radius: 3px; overflow-x: auto; line-height: 1&#46;5; margin: 0px;">root@ubuntu<span class="hljs-symbol" style="color: rgb(0, 176, 232);">:/home/guanfuchang</span><span class="hljs-comment" style="color: rgb(0, 128, 0);"># docker pull mysql:5&#46;5</span>
</code></pre><p style="margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">3&#46;安装运行mysql容器</p><pre style="overflow: auto; margin-top: 0px; margin-bottom: 0px; padding: 0px; list-style-type: none; list-style-image: none; font-family: &quot;Courier New&quot;, Courier, monospace; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);"><code class="hljs apache" style="font-family: &quot;Courier New&quot;, sans-serif; background: rgb(245, 245, 245); color: black; display: block; border: 1px solid rgb(204, 204, 204); padding: 5px; border-radius: 3px; overflow-x: auto; line-height: 1&#46;5; margin: 0px;"><span class="hljs-attribute" style="color: rgb(163, 21, 21);">docker</span> run --name mysql -v /data/mysql-data:/var/lib/mysql -p <span class="hljs-number">3306</span>:<span class="hljs-number">3306</span> -e MYSQL_ROOT_PASSWORD=root  -d mysql:<span class="hljs-number">5</span>&#46;<span class="hljs-number">5</span>
</code></pre><ol style="margin: 0px 0px 0px 20px; padding: 0px 0px 0px 40px; list-style: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"><li style="margin: 0px; padding: 0px; list-style-type: decimal; list-style-image: none;">安装运行wordpress容器</li></ol><pre style="overflow: auto; margin-top: 0px; margin-bottom: 0px; padding: 0px; list-style-type: none; list-style-image: none; font-family: &quot;Courier New&quot;, Courier, monospace; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255);"><code class="hljs ruby" style="font-family: &quot;Courier New&quot;, sans-serif; background: rgb(245, 245, 245); color: black; display: block; border: 1px solid rgb(204, 204, 204); padding: 5px; border-radius: 3px; overflow-x: auto; line-height: 1&#46;5; margin: 0px;">root@ubuntu<span class="hljs-symbol" style="color: rgb(0, 176, 232);">:/home/guanfuchang</span><span class="hljs-comment" style="color: rgb(0, 128, 0);"># docker run -itd --name wordpress -e WORDPRESS_DB_HOST=mysql -e WORDPRESS_DB_PASSORD=root -p 8080:80 --link mysql:mysql -d wordpress</span>
</code></pre><p style="margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">访问主机的8080端口，如：<a href="http://192&#46;168&#46;147&#46;128:8080/" target="_blank" style="text-decoration-line: none; color: rgb(51, 153, 255);">http://192&#46;168&#46;147&#46;128:8080</a></p><p style="margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: rgb(68, 68, 68); font-family: Tahoma, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"><img src="https://gitee&#46;com/zykit/images/raw/master/img/604717-20190508135115344-959485884&#46;png" alt="img" loading="lazy" style="border-width: initial; border-style: none; max-width: 100%; margin-top: 10px; margin-bottom: 10px; height: auto;" /></p>

admin

<div>解决MYSQL：ERROR 1045 (28000): ACCESS DENIED FOR USER \'ROOT\'@\'LOCALHOST\' (USING PASSWORD: NO/YES)</div><div><br /></div><div><br /></div><div><br /></div><div> </div><div> <span style=\"background-color: rgb(244, 244, 244); color: rgb(79, 79, 79); font-family: -apple-system, &quot;SF UI Text&quot;, Arial, &quotingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif, SimHei, SimSun; font-size: 16px; text-align: justify;\">找到my&#46;cnf文件，在</span><span style=\"font-family: inherit; font-size: inherit; text-align: justify; box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: 700; font-stretch: inherit; line-height: inherit; vertical-align: baseline; color: rgb(60, 59, 59);\">[mysqld]下添加skip-grant-tables，然后保存，并重启MySQL容器;</span></div><p style=\"box-sizing: border-box; margin-bottom: 16px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: 26px; font-family: -apple-system, &quot;SF UI Text&quot;, Arial, &quotingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif, SimHei, SimSun; vertical-align: baseline; color: rgb(79, 79, 79); text-align: justify; background-color: rgb(244, 244, 244);\"><br /></p><p style=\"box-sizing: border-box; margin-bottom: 16px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: 26px; font-family: -apple-system, &quot;SF UI Text&quot;, Arial, &quotingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif, SimHei, SimSun; vertical-align: baseline; color: rgb(79, 79, 79); text-align: justify; background-color: rgb(244, 244, 244);\"><br /></p><p style=\"box-sizing: border-box; margin-bottom: 16px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: 26px; font-family: -apple-system, &quot;SF UI Text&quot;, Arial, &quotingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif, SimHei, SimSun; vertical-align: baseline; color: rgb(79, 79, 79); text-align: justify; background-color: rgb(244, 244, 244);\">最后，使用命令</p><p style=\"box-sizing: border-box; margin-bottom: 16px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: 26px; font-family: -apple-system, &quot;SF UI Text&quot;, Arial, &quotingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif, SimHei, SimSun; vertical-align: baseline; color: rgb(79, 79, 79); text-align: justify; background-color: rgb(244, 244, 244);\"><span style=\"color: rgb(0, 0, 0); font-family: &quot;Courier New&quot;, sans-serif; font-size: 26px; text-align: start; white-space: pre; background-color: rgb(252, 250, 238);\">docker exec -it mysql /bin/bash</span></p><p style=\"box-sizing: border-box; margin-bottom: 16px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: 26px; font-family: -apple-system, &quot;SF UI Text&quot;, Arial, &quotingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif, SimHei, SimSun; vertical-align: baseline; color: rgb(79, 79, 79); text-align: justify; background-color: rgb(244, 244, 244);\">mysql -u root -p不需要密码也可以登录mysql</p><p style=\"box-sizing: border-box; margin-bottom: 16px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: 26px; font-family: -apple-system, &quot;SF UI Text&quot;, Arial, &quotingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif, SimHei, SimSun; vertical-align: baseline; color: rgb(79, 79, 79); text-align: justify; background-color: rgb(244, 244, 244);\">修改mysql方法：</p><pre class=\"has\" style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 24px; padding: 8px; border-width: 0px; border-style: initial; border-color: initial; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 22px; font-family: Consolas, Inconsolata, Courier, monospace; vertical-align: baseline; background-color: rgba(160, 160, 160, 0&#46;075); overflow: auto hidden; position: relative; white-space: pre-wrap; overflow-wrap: break-word;\"><code class=\"hljs sql\" style=\"box-sizing: border-box; margin: 0px 0&#46;25em; padding: 8px; border: 1px solid rgba(160, 160, 160, 0&#46;3); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 22px; font-family: Consolas, Inconsolata, Courier, monospace, &quot;pingfang sc&quot;, &quot;microsoft yahei&quot;, sans-serif; vertical-align: baseline; background: rgb(40, 44, 52); display: block; overflow-x: auto; color: rgb(171, 178, 191); border-radius: 4px; white-space: pre; overflow-wrap: normal;\"></code><ol class=\"hljs-ln\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; list-style-position: initial; list-style-image: initial; border-collapse: collapse; overflow: hidden;\"><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"1\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">mysql -u root -p</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"2\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">不用输入密码，直接回车</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"3\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">输入<span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">use</span> mysql</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"4\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">修改root的密码</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"5\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\"><span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">update</span> <span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">user</span> <span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">set</span> authentication_string=<span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">password</span>(<span class=\"hljs-string\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(152, 195, 121);\">\'新密码\'</span>) <span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">where</span> <span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">user</span>=<span class=\"hljs-string\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(152, 195, 121);\">\'root\'</span>;</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"6\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\"><span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">flush</span> <span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">privileges</span>;</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"7\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">退出：quit</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"8\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">再次重启mysql：1、net <span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">stop</span> mysql     <span class=\"hljs-number\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(209, 154, 102);\">2</span>、net <span class=\"hljs-keyword\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; color: rgb(198, 120, 221);\">start</span> mysql</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"9\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">测试是否成功就是是否登陆成功咯。</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"10\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">mysql -u root -p&lt;新密码&gt;</div></div></li><li style=\"box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 0&#46;25em; border: 0px; font: inherit; vertical-align: baseline; list-style-type: none; height: 22px;\"><div class=\"hljs-ln-numbers\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border-width: 0px 1px 0px 0px; border-top-style: initial; border-right-style: solid; border-bottom-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(197, 197, 197); border-bottom-color: initial; border-left-color: initial; border-image: initial; font: inherit; vertical-align: baseline; float: left; height: 22px; width: 24px;\"><div class=\"hljs-ln-line hljs-ln-n\" data-line-number=\"11\" style=\"box-sizing: border-box; margin: 0px; padding: 0px 8px 0px 0px; border: 0px; font: inherit; vertical-align: baseline; text-align: right;\"></div></div><div class=\"hljs-ln-code\" style=\"box-sizing: border-box; margin: 0px 0px 0px 8px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline; float: left; height: 22px;\"><div class=\"hljs-ln-line\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">完成！</div></div></li></ol></pre><div> </div><div><br /></div>

admin

参考网页



https://www.freesion.com/article/2333291261/

https://blog.csdn.net/weixin_30654583/article/details/97548118

https://www.cnblogs.com/jackpan-blog/p/13772776.html

dpxqs

谢谢分享了

goodnet163

谢谢分享

bdlxg

谢谢楼主分享