{"id":1922,"date":"2017-03-17T09:28:58","date_gmt":"2017-03-17T01:28:58","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1922"},"modified":"2025-01-08T15:34:36","modified_gmt":"2025-01-08T07:34:36","slug":"%e5%a6%82%e4%bd%95%e5%9c%a8-linux-%e4%b8%ad%e9%87%8d%e7%bd%ae-mysql-%e6%88%96%e8%80%85-mariadb-%e7%9a%84-root-%e5%af%86%e7%a0%81","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/linux\/%e5%a6%82%e4%bd%95%e5%9c%a8-linux-%e4%b8%ad%e9%87%8d%e7%bd%ae-mysql-%e6%88%96%e8%80%85-mariadb-%e7%9a%84-root-%e5%af%86%e7%a0%81\/","title":{"rendered":"\u5982\u4f55\u5728 Linux \u4e2d\u91cd\u7f6e MySQL \u6216\u8005 MariaDB \u7684 root \u5bc6\u7801"},"content":{"rendered":"\n

\u5982\u679c\u4f60\u662f\u7b2c\u4e00\u6b21\u8bbe\u7f6e MySQL \u6216 MariaDB \u6570\u636e\u5e93\uff0c\u4f60\u53ef\u4ee5\u76f4\u63a5\u8fd0\u884c mysql_secure_installation<\/code> \u6765\u5b9e\u73b0\u57fa\u672c\u7684\u5b89\u5168\u8bbe\u7f6e\u3002<\/p>\n\n\n\n

\u5176\u4e2d\u4e00\u9879\u662f\u8bbe\u7f6e\u6570\u636e\u5e93 root \u5e10\u6237\u7684\u5bc6\u7801 – \u4f60\u5fc5\u987b\u4fdd\u6301\u79c1\u5bc6\uff0c\u5e76\u4ec5\u5728\u7edd\u5bf9\u9700\u8981\u65f6\u4f7f\u7528\u3002\u5982\u679c\u4f60\u5fd8\u8bb0\u4e86\u5bc6\u7801\u6216\u9700\u8981\u91cd\u7f6e\u5bc6\u7801\uff08\u4f8b\u5982\uff0c\u5f53\u6570\u636e\u5e93\u7ba1\u7406\u5458\u6362\u4eba\u6216\u88ab\u88c1\u5458\uff01\uff09\uff0c\u8fd9\u7bc7\u6587\u7ae0\u4f1a\u6d3e\u4e0a\u7528\u573a\u3002\u6211\u4eec\u5c06\u89e3\u91ca\u5982\u4f55\u5728 Linux \u4e2d\u91cd\u7f6e\u6216\u6062\u590d MySQL \u6216 MariaDB \u7684 root \u5bc6\u7801\u3002<\/p>\n\n\n\n

 <\/p>\n\n\n\n

\u867d\u7136\u6211\u4eec\u5c06\u5728\u672c\u6587\u4e2d\u4f7f\u7528 MariaDB\uff0c\u4f46\u8fd9\u4e9b\u8bf4\u660e\u540c\u6837\u4e5f\u9002\u7528\u4e8e MySQL\u3002<\/p>\n\n\n\n

\u6062\u590d MySQL \u6216\u8005 MariaDB \u7684 root \u5bc6\u7801<\/h3>\n\n\n\n

\u5f00\u59cb\u4e4b\u524d\uff0c\u5148\u505c\u6b62\u6570\u636e\u5e93\u670d\u52a1\u5e76\u68c0\u67e5\u670d\u52a1\u72b6\u6001\uff0c\u6211\u4eec\u5e94\u8be5\u53ef\u4ee5\u770b\u5230\u5148\u524d\u8bbe\u7f6e\u7684\u73af\u5883\u53d8\u91cf\uff1a<\/p>\n\n\n\n

    \n
  1. -------------<\/span> SystemD<\/span> -------------<\/span> <\/code><\/li>\n\n\n\n
  2. #<\/span> systemctl<\/span> stop mariadb<\/span><\/code><\/li>\n\n\n\n
  3. -------------<\/span> SysVinit<\/span> -------------<\/span><\/code><\/li>\n\n\n\n
  4. # \/etc\/<\/span>init<\/span>.<\/span>d<\/span>\/<\/span>mysqld stop<\/span><\/code><\/li>\n<\/ol>\n\n\n\n

    \u63a5\u4e0b\u6765\uff0c\u7528 --skip-grant-tables<\/code> \u9009\u9879\u542f\u52a8\u670d\u52a1\uff1a<\/p>\n\n\n\n

      \n
    1. -------------<\/span> SystemD<\/span> -------------<\/span> <\/code><\/li>\n\n\n\n
    2. #<\/span> systemctl<\/span> set<\/span>-<\/span>environment MYSQLD_OPTS<\/span>=<\/span>\"--skip-grant-tables\"<\/span><\/code><\/li>\n\n\n\n
    3. #<\/span> systemctl<\/span> start mariadb<\/span><\/code><\/li>\n\n\n\n
    4. #<\/span> systemctl<\/span> status mariadb<\/span><\/code><\/li>\n\n\n\n
    5. -------------<\/span> SysVinit<\/span> -------------<\/span><\/code><\/li>\n\n\n\n
    6. #<\/span> mysqld_safe <\/span>--<\/span>skip<\/span>-<\/span>grant<\/span>-<\/span>tables <\/span>&<\/span><\/code><\/li>\n<\/ol>\n\n\n\n
      \"\"<\/a><\/figure>\n\n\n\n

      <\/p>\n\n\n\n

      \u4f7f\u7528 skip tables \u542f\u52a8 MySQL\/MariaDB<\/em><\/p>\n\n\n\n

      \u8fd9\u53ef\u4ee5\u8ba9\u4f60\u4e0d\u7528 root \u5bc6\u7801\u5c31\u80fd\u8fde\u63a5\u5230\u6570\u636e\u5e93\uff08\u4f60\u4e5f\u8bb8\u9700\u8981\u5207\u6362\u5230\u53e6\u5916\u4e00\u4e2a\u7ec8\u7aef\u4e0a\uff09\uff1a<\/p>\n\n\n\n

        \n
      1. #<\/span> mysql <\/span>-<\/span>u root<\/span><\/code><\/li>\n<\/ol>\n\n\n\n

        \u63a5\u4e0b\u6765\uff0c\u6309\u7167\u4e0b\u9762\u5217\u51fa\u7684\u6b65\u9aa4\u6765\u3002<\/p>\n\n\n\n

          \n
        1. MariaDB<\/span> [(<\/span>none<\/span>)]><\/span> USE mysql<\/span>;<\/span><\/code><\/li>\n\n\n\n
        2. MariaDB<\/span> [(<\/span>none<\/span>)]><\/span> UPDATE user SET password<\/span>=<\/span>PASSWORD<\/span>(<\/span>'YourNewPasswordHere'<\/span>)<\/span> WHERE <\/span>User<\/span>=<\/span>'root'<\/span> AND <\/span>Host<\/span> =<\/span> 'localhost'<\/span>;<\/span><\/code><\/li>\n\n\n\n
        3. MariaDB<\/span> [(<\/span>none<\/span>)]><\/span> FLUSH PRIVILEGES<\/span>;<\/span><\/code><\/li>\n<\/ol>\n\n\n\n

          \u6700\u540e\uff0c\u505c\u6b62\u670d\u52a1\uff0c\u53d6\u6d88\u73af\u5883\u53d8\u91cf\u8bbe\u7f6e\u5e76\u518d\u6b21\u542f\u52a8\u670d\u52a1\uff1a<\/p>\n\n\n\n

            \n
          1. -------------<\/span> SystemD<\/span> -------------<\/span> <\/code><\/li>\n\n\n\n
          2. #<\/span> systemctl<\/span> stop mariadb<\/span><\/code><\/li>\n\n\n\n
          3. #<\/span> systemctl<\/span> unset<\/span>-<\/span>environment MYSQLD_OPTS<\/span><\/code><\/li>\n\n\n\n
          4. #<\/span> systemctl<\/span> start mariadb<\/span><\/code><\/li>\n\n\n\n
          5. -------------<\/span> SysVinit<\/span> -------------<\/span><\/code><\/li>\n\n\n\n
          6. # \/etc\/<\/span>init<\/span>.<\/span>d<\/span>\/<\/span>mysql stop<\/span><\/code><\/li>\n\n\n\n
          7. # \/etc\/<\/span>init<\/span>.<\/span>d<\/span>\/<\/span>mysql start<\/span><\/code><\/li>\n<\/ol>\n\n\n\n

            \u8fd9\u53ef\u4ee5\u8ba9\u5148\u524d\u7684\u6539\u53d8\u751f\u6548\uff0c\u5141\u8bb8\u4f60\u4f7f\u7528\u65b0\u7684\u5bc6\u7801\u8fde\u63a5\u5230\u6570\u636e\u5e93\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

            \u5982\u679c\u4f60\u662f\u7b2c\u4e00\u6b21\u8bbe\u7f6e MySQL \u6216 MariaDB \u6570\u636e\u5e93\uff0c\u4f60\u53ef\u4ee5\u76f4\u63a5\u8fd0\u884c mysql_secure_inst … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[49],"tags":[38,45],"class_list":["post-1922","post","type-post","status-publish","format-standard","hentry","category-linux","tag-linux","tag-mysql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=1922"}],"version-history":[{"count":3,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1922\/revisions"}],"predecessor-version":[{"id":9164,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1922\/revisions\/9164"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=1922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=1922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=1922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}