{"id":8011,"date":"2018-10-30T04:00:14","date_gmt":"2018-10-29T20:00:14","guid":{"rendered":"https:\/\/4563.org\/?p=8011"},"modified":"2018-10-30T04:00:14","modified_gmt":"2018-10-29T20:00:14","slug":"%e5%ae%9d%e5%a1%94mysql%e6%97%a0%e6%b3%95%e5%90%af%e5%8a%a8%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=8011","title":{"rendered":"\u5b9d\u5854MySQL\u65e0\u6cd5\u542f\u52a8\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"
\n
\"\"<\/div>\n<\/header>\n
\u89e3\u51b3\u5b9d\u5854MySQL\u65e0\u6cd5\u6b63\u5e38\u542f\u52a8\u3002<\/p>\n
\n

\u73af\u5883<\/h4>\n
    \n
  • \u5e73\u5b89\u4e91\uff1b<\/li>\n
  • ubuntu14.04\uff1b<\/li>\n
  • \u5b9d\u58545.9\uff1b<\/li>\n
  • MySQL5.1 \u6216\u8005 5.5\u3002<\/li>\n<\/ul>\n
    \n

    \u62a5\u9519\u4fe1\u606f<\/h4>\n
    181025<\/span> 22<\/span>:<\/span>09<\/span>:<\/span>45<\/span> [<\/span>Note<\/span>]<\/span> Plugin<\/span> 'FEDERATED'<\/span> is<\/span> disabled<\/span>.<\/span>\r\n\/<\/span>www<\/span>\/<\/span>server<\/span>\/<\/span>mysql<\/span>\/<\/span>bin<\/span>\/<\/span>mysqld<\/span>:<\/span> Table<\/span> 'mysql.plugin'<\/span> doesn<\/span>'t exist\r\n181025 22:09:45 [ERROR] Can'<\/span>t open the mysql<\/span>.<\/span>plugin table<\/span>.<\/span> Please<\/span> run mysql_upgrade to create it<\/span>.<\/span>\r\n181025<\/span> 22<\/span>:<\/span>09<\/span>:<\/span>45<\/span> InnoDB<\/span>:<\/span> The<\/span> InnoDB<\/span> memory heap <\/span>is<\/span> disabled\r\n<\/span>181025<\/span> 22<\/span>:<\/span>09<\/span>:<\/span>45<\/span> InnoDB<\/span>:<\/span> Mutexes<\/span> and<\/span> rw_locks <\/span>use<\/span> GCC atomic builtins\r\n<\/span>181025<\/span> 22<\/span>:<\/span>09<\/span>:<\/span>45<\/span> InnoDB<\/span>:<\/span> Compressed<\/span> tables <\/span>use<\/span> zlib <\/span>1.2<\/span>.<\/span>8<\/span>\r\n181025<\/span> 22<\/span>:<\/span>09<\/span>:<\/span>45<\/span> InnoDB<\/span>:<\/span> Initializing<\/span> buffer pool<\/span>,<\/span> size <\/span>=<\/span> 128.0M<\/span>\r\n181025<\/span> 22<\/span>:<\/span>09<\/span>:<\/span>45<\/span> InnoDB<\/span>:<\/span> Completed<\/span> initialization of buffer pool\r\n<\/span>181025<\/span> 22<\/span>:<\/span>09<\/span>:<\/span>45<\/span>  InnoDB<\/span>:<\/span> Operating<\/span> system error number <\/span>13<\/span> in<\/span> a file operation<\/span>.<\/span>\r\nInnoDB<\/span>:<\/span> The<\/span> error means mysqld does <\/span>not<\/span> have the access rights to\r\n<\/span>InnoDB<\/span>:<\/span> the directory<\/span>.<\/span>\r\nInnoDB<\/span>:<\/span> File<\/span> name <\/span>\/<\/span>www<\/span>\/<\/span>server<\/span>\/<\/span>data<\/span>\/<\/span>ibdata1\r\n<\/span>InnoDB<\/span>:<\/span> File<\/span> operation call<\/span>:<\/span> 'create'<\/span>.<\/span>\r\nInnoDB<\/span>:<\/span> Cannot<\/span> continue<\/span> operation<\/span>.<\/span><\/code><\/pre>\n
    \n
    \u6545\u969c\u539f\u56e0<\/h4>\n
      \n
    • \u5e73\u5b89\u4e91\u7684ubuntu\u7cfb\u7edf\u6743\u9650\u95ee\u9898\uff0c\u5bfc\u81f4\u5b9d\u5854\u65e0\u6cd5\u8bbf\u95ee \/www\/server\/data<\/code>\u3002<\/li>\n
    • \u8fdb\u800c\u5bfc\u81f4MySQL\u65e0\u6cd5\u521d\u59cb\u5316\u3002<\/li>\n<\/ul>\n
      \n
      \u89e3\u51b3\u65b9\u6848<\/h4>\n
        \n
      • \u5728\u6839\u76ee\u5f55\u521b\u5efamysqldata<\/code>\u6587\u4ef6\u5939\uff0c\u6743\u9650755\uff0c\u6240\u6709\u8005MySQL<\/code>\uff1b<\/li>\n
      • \u6253\u5f00MySQL\u63a7\u5236\u9762\u677f\u2192\u914d\u7f6e\u4fee\u6539\u2192\u4fee\u6539\u6240\u6709\/www\/server\/data<\/code>\u4e3a\/mysqldata<\/code>\uff1b<\/li>\n
      • \u5728ssh\u4e2d\u6267\u884c\u521d\u59cb\u5316\u6570\u636e\u5e93<\/li>\n<\/ul>\n
        \/www\/<\/span>server<\/span>\/<\/span>mysql<\/span>\/<\/span>scripts<\/span>\/<\/span>mysql_install_db <\/span>--<\/span>user<\/span>=<\/span>mysql <\/span>--<\/span>basedir<\/span>=<\/span>\/www\/<\/span>server<\/span>\/<\/span>mysql <\/span>--<\/span>datadir<\/span>=\/<\/span>mysqldata<\/span><\/code><\/pre>\n
          \n
        • \u6267\u884c\u6210\u529f\u540e\u4fee\u590d\u5b8c\u6210\u3002\u91cd\u542f\u4e00\u4e0bMySQL\u5373\u53ef\u6253\u5f00\u3002<\/li>\n<\/ul>\n
          \n
          \u5907\u6ce8<\/h4>\n
          \u6b64\u6559\u7a0b\u540c\u6837\u9002\u5408\u5176\u4ed6\u4e91\u51fa\u73b0\u6b64\u9519\u8bef\u4ee3\u7801\u3002<\/p>\n
          \n
          \u9884\u544a<\/h4>\n
          \u63a5\u4e0b\u6765\u8981\u4fee\u590d\u5e73\u5b89\u4e91\u65e0\u6cd5\u8fd0\u884c\u5b9d\u5854\u7684PHP<\/code>\u3002<\/p>\n<\/article>\n","protected":false},"excerpt":{"rendered":"
          \u89e3\u51b3\u5b9d\u5854MySQL\u65e0\u6cd5\u6b63\u5e38\u542f\u52a8\u3002 …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/8011"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8011"}],"version-history":[{"count":1,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/8011\/revisions"}],"predecessor-version":[{"id":8012,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/8011\/revisions\/8012"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8011"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}