{"id":1747,"date":"2022-05-26T17:53:38","date_gmt":"2022-05-26T09:53:38","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=1747"},"modified":"2022-05-31T08:46:47","modified_gmt":"2022-05-31T00:46:47","slug":"mariadb%e5%bf%98%e8%ae%b0rootlocalhost%e5%af%86%e7%a0%81%e7%9a%84%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=1747","title":{"rendered":"MariaDB\u5fd8\u8bb0root@&#8217;localhost&#8217;\u5bc6\u7801\u7684\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<label for=\"ez-toc-cssicon-toggle-item-6a0e548c61aa4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a0e548c61aa4\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/dba.qishuo.xin\/?p=1747\/#1_%E5%AF%86%E7%A0%81%E9%94%99%E8%AF%AF%E6%97%B6%E7%99%BB%E5%BD%95%E6%8F%90%E7%A4%BA\" >1. \u5bc6\u7801\u9519\u8bef\u65f6\u767b\u5f55\u63d0\u793a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/dba.qishuo.xin\/?p=1747\/#2_%E5%85%88%E5%B0%86MariaDB%E6%9C%8D%E5%8A%A1%E5%85%B3%E9%97%AD\" >2. \u5148\u5c06MariaDB\u670d\u52a1\u5173\u95ed<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/dba.qishuo.xin\/?p=1747\/#3_%E4%BF%AE%E6%94%B9mycnf%E5%90%AF%E5%8A%A8%E6%96%87%E4%BB%B6\" >3. \u4fee\u6539my.cnf\u542f\u52a8\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=1747\/#4_%E9%87%8D%E6%96%B0%E5%90%AF%E5%8A%A8mariadb\" >4. \u91cd\u65b0\u542f\u52a8mariadb<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=1747\/#5_%E4%BD%BF%E7%94%A8_root_%E7%94%A8%E6%88%B7%E7%99%BB%E5%BD%95%E5%88%B0_mysql%E6%AD%A4%E6%97%B6%E5%B7%B2%E7%BB%8F%E4%B8%8D%E5%86%8D%E9%9C%80%E8%A6%81%E5%AF%86%E7%A0%81%E4%BA%86\" >5. \u4f7f\u7528 root \u7528\u6237\u767b\u5f55\u5230 mysql(\u6b64\u65f6\u5df2\u7ecf\u4e0d\u518d\u9700\u8981\u5bc6\u7801\u4e86)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/dba.qishuo.xin\/?p=1747\/#6_%E6%9B%B4%E6%96%B0rootlocalhost%E5%AF%86%E7%A0%81\" >6. \u66f4\u65b0root@&#039;localhost&#039;\u5bc6\u7801<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/dba.qishuo.xin\/?p=1747\/#7_%E9%87%8D%E7%BD%AE%E7%8E%AF%E5%A2%83%E5%B9%B6%E9%87%8D%E5%90%AFmariadb%E6%9C%8D%E5%8A%A1\" >7. \u91cd\u7f6e\u73af\u5883\u5e76\u91cd\u542fmariadb\u670d\u52a1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/dba.qishuo.xin\/?p=1747\/#8_%E6%9C%80%E5%90%8E%E4%BD%BF%E7%94%A8%E9%87%8D%E7%BD%AE%E7%9A%84%E5%AF%86%E7%A0%81%E7%99%BB%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93\" >8. \u6700\u540e\u4f7f\u7528\u91cd\u7f6e\u7684\u5bc6\u7801\u767b\u5f55\u6570\u636e\u5e93<\/a><\/li><\/ul><\/nav><\/div>\n<p>MariaDB\u4e0d\u80fd\u4f7f\u7528\u64cd\u4f5c\u7cfb\u7edf\u5c42\u9762\u7684\u8ba4\u8bc1\uff0c\u60f3\u8bbf\u95ee\u6570\u636e\u5e93\u5fc5\u987b\u8981\u4f7f\u7528\u7528\u6237\u540d\u4e0e\u5bc6\u7801\u767b\u5f55\uff08\u4f46\u662f\u5728\u65b0\u5b89\u88c5\u6570\u636e\u5e93\u540e\uff0c\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528 mariadb \u6216 mysql \u547d\u4ee4\u767b\u5f55\u6570\u636e\u5e93\uff09\u3002<\/p>\n<p>\u91cd\u7f6eMariaDB <code>root@&#039;localhost&#039;<\/code>\u8d26\u6237\u5bc6\u7801\u7684\u524d\u63d0\u5f53\u7136\u662f\u80fd\u591f\u767b\u5f55\u5230linux\u7cfb\u7edf\uff0c\u4e14\u6709\u8db3\u591f\u7684\u64cd\u4f5c\u6743\u9650\u3002\u672c\u6587\u4ee5linux root\u8d26\u6237\u4e3a\u4f8b\uff0c\u91cd\u7f6eMariaDB\u7684<code>root@&#039;localhost&#039;<\/code>\u8d26\u6237\u5bc6\u7801\u3002<\/p>\n<h4><span class=\"ez-toc-section\" id=\"1_%E5%AF%86%E7%A0%81%E9%94%99%E8%AF%AF%E6%97%B6%E7%99%BB%E5%BD%95%E6%8F%90%E7%A4%BA\"><\/span>1. \u5bc6\u7801\u9519\u8bef\u65f6\u767b\u5f55\u63d0\u793a<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code>~]# mysql -uroot -p\nEnter password:\nERROR 1045 (28000): Access denied for user &#039;root&#039;@&#039;localhost&#039; (using password: YES)<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"2_%E5%85%88%E5%B0%86MariaDB%E6%9C%8D%E5%8A%A1%E5%85%B3%E9%97%AD\"><\/span>2. \u5148\u5c06MariaDB\u670d\u52a1\u5173\u95ed<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">~]# systemctl stop mariadb\n~]# systemctl status mariadb\n\u25cf mariadb.service - MariaDB database server\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/mariadb.service; disabled; vendor preset: disabled)\n  Drop-In: \/etc\/systemd\/system\/mariadb.service.d\n           \u2514\u2500migrated-from-my.cnf-settings.conf\n   Active: inactive (dead)<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"3_%E4%BF%AE%E6%94%B9mycnf%E5%90%AF%E5%8A%A8%E6%96%87%E4%BB%B6\"><\/span>3. \u4fee\u6539my.cnf\u542f\u52a8\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u4fee\u6539 \/etc\/my.cnf\uff0c\u5728 [mysqld] \u5c0f\u8282\u4e0b\u6dfb\u52a0\u4e00\u884c\uff1a<\/p>\n<pre><code>skip-grant-tables=1<\/code><\/pre>\n<p><span style='color:red'>\u8fd9\u4e00\u884c\u914d\u7f6e\u8ba9 mysqld \u542f\u52a8\u65f6\u4e0d\u5bf9\u5bc6\u7801\u8fdb\u884c\u9a8c\u8bc1\u3002<\/span><\/p>\n<p>\u6216\u8005\uff1a\u8bbe\u5b9a\u73af\u5883\u53d8\u91cf <code>MYSQLD_OPTS=&quot;--skip-grant-tables&quot;<\/code>\uff0c\u7136\u540e\u91cd\u542fMariaDB\u670d\u52a1\u3002<code>--skip-grant-tables<\/code>\u5c06\u5141\u8bb8MariaDB\u5728\u542f\u52a8\u65f6\u8df3\u8fc7\u6388\u6743\u8868\uff0c\u8fd9\u5c06\u5bfc\u81f4\u5141\u8bb8\u6240\u6709\u7528\u6237\u62e5\u6709\u6743\u9650\u8bbf\u95ee\u6240\u6709\u8868\u6570\u636e\u3002\u56e0\u6b64\u9057\u5931root\u8d26\u6237\u5bc6\u7801\u65f6\uff0c\u91c7\u7528\u8be5\u65b9\u5f0f\u53ef\u4ee5\u8fdb\u5165\u6570\u636e\u5e93\u64cd\u4f5c\u3002<\/p>\n<pre><code class=\"language-shell\">~]# systemctl set-environment MYSQLD_OPTS=&quot;--skip-grant-tables&quot;<\/code><\/pre>\n<p>\u6216\u8005\uff1a\u5728<code>\/usr\/lib\/systemd\/system\/mariadb.service<\/code>\u00a0\u6587\u4ef6\u4e2d\u6dfb\u52a0\u4e00\u884c<\/p>\n<pre><code>ExecStart=\/usr\/bin\/mysqld_safe --basedir=\/usr --skip-grant-tables --skip-networking<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"4_%E9%87%8D%E6%96%B0%E5%90%AF%E5%8A%A8mariadb\"><\/span>4. \u91cd\u65b0\u542f\u52a8mariadb<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">~]# systemctl start mariadb\n~]# systemctl status mariadb<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"5_%E4%BD%BF%E7%94%A8_root_%E7%94%A8%E6%88%B7%E7%99%BB%E5%BD%95%E5%88%B0_mysql%E6%AD%A4%E6%97%B6%E5%B7%B2%E7%BB%8F%E4%B8%8D%E5%86%8D%E9%9C%80%E8%A6%81%E5%AF%86%E7%A0%81%E4%BA%86\"><\/span>5. \u4f7f\u7528 root \u7528\u6237\u767b\u5f55\u5230 mysql(\u6b64\u65f6\u5df2\u7ecf\u4e0d\u518d\u9700\u8981\u5bc6\u7801\u4e86)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">~]#  mysql -uroot -p\n\u56de\u8f66<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"6_%E6%9B%B4%E6%96%B0rootlocalhost%E5%AF%86%E7%A0%81\"><\/span>6. \u66f4\u65b0<code>root@&#039;localhost&#039;<\/code>\u5bc6\u7801<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code>MariaDB [(none)]&gt;\n-- \u4f18\u5148\u6267\u884c\u4e0b\u5217\u8bed\u53e5\uff1a\nFLUSH PRIVILEGES;\n\n-- \u5bf9\u4e8e5.6\u6216\u4ee5\u524d\u7248\u672c\u4f7f\u7528\u5982\u4e0b\u8bed\u53e5\uff1a\nUPDATE mysql.user SET password=PASSWORD(&#039;NewPassword&#039;) WHERE user=&#039;root&#039; AND host = &#039;localhost&#039;;\n\n-- \u5bf9\u4e8e5.7\u6216\u4ee5\u4e0a\u7248\u672c\u4f7f\u7528\u5982\u4e0b\u8bed\u53e5\uff1a\nGRANT ALL PRIVILEGES ON *.* TO root@&#039;localhost&#039; IDENTIFIED BY &#039;NewPassword&#039; WITH GRANT OPTION;\n\nFLUSH PRIVILEGES;<\/code><\/pre>\n<p>\u81f3\u6b64\uff0croot\u8d26\u6237\u5bc6\u7801\u5df2\u7ecf\u91cd\u7f6e\u4e86\uff0c\u4f46\u4e8b\u60c5\u5e76\u672a\u7ed3\u675f\u3002\u524d\u9762\u6211\u4eec\u8bbe\u5b9a\u4e86<code>--skip-grant-tables<\/code>\u5141\u8bb8\u7528\u6237\u8df3\u8fc7\u6388\u6743\u8868\u767b\u5f55\uff0c\u56e0\u6b64\u6211\u4eec\u8fd8\u9700\u8981\u53d6\u6d88\u8be5\u9879\u8bbe\u7f6e\uff0c\u540c\u6837\u5728\u5173\u95edMariaDB\u670d\u52a1\u7684\u72b6\u6001\u4e0b\u64cd\u4f5c\uff0c\u6700\u540e\u91cd\u65b0\u542f\u52a8MariaDB\u670d\u52a1\u3002<\/p>\n<h4><span class=\"ez-toc-section\" id=\"7_%E9%87%8D%E7%BD%AE%E7%8E%AF%E5%A2%83%E5%B9%B6%E9%87%8D%E5%90%AFmariadb%E6%9C%8D%E5%8A%A1\"><\/span>7. \u91cd\u7f6e\u73af\u5883\u5e76\u91cd\u542fmariadb\u670d\u52a1<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u79fb\u9664 <code>\/etc\/my.cnf \u6587\u4ef6\u4e2d\u7684 skip-grant-tables=1<\/code>\uff0c\u5e76\u91cd\u542f\u670d\u52a1\u3002<\/p>\n<pre><code class=\"language-shell\">~]# systemctl stop mariadb\n~]# systemctl unset-environment MYSQLD_OPTS\n~]# systemctl start mariadb<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"8_%E6%9C%80%E5%90%8E%E4%BD%BF%E7%94%A8%E9%87%8D%E7%BD%AE%E7%9A%84%E5%AF%86%E7%A0%81%E7%99%BB%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>8. \u6700\u540e\u4f7f\u7528\u91cd\u7f6e\u7684\u5bc6\u7801\u767b\u5f55\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">~]# mysql -uroot -p\nEnter password:<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB\u4e0d\u80fd\u4f7f\u7528\u64cd\u4f5c\u7cfb\u7edf\u5c42\u9762\u7684\u8ba4\u8bc1\uff0c\u60f3\u8bbf\u95ee\u6570&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,32],"tags":[12,216],"class_list":["post-1747","post","type-post","status-publish","format-standard","hentry","category-mariadbmysql","category-mariadb","tag-mariadb","tag-216"],"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/1747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1747"}],"version-history":[{"count":4,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/1747\/revisions"}],"predecessor-version":[{"id":1751,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/1747\/revisions\/1751"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1747"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}