{"id":1363,"date":"2021-10-11T06:15:57","date_gmt":"2021-10-10T21:15:57","guid":{"rendered":"https:\/\/gyms-web.com\/wp\/?p=1363"},"modified":"2021-10-11T06:15:57","modified_gmt":"2021-10-10T21:15:57","slug":"ubuntu-20-04%e3%82%a2%e3%83%83%e3%83%97%e3%83%87%e3%83%bc%e3%83%88%e5%a4%b1%e6%95%97%e3%81%ae%e5%a7%8b%e6%9c%ab","status":"publish","type":"post","link":"https:\/\/gyms-web.com\/wp\/?p=1363","title":{"rendered":"ubuntu 20.04\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u5931\u6557\u306e\u59cb\u672b"},"content":{"rendered":"

apt\u304c\u52d5\u304b\u306a\u304f\u306a\u3063\u3066\u3057\u307e\u3063\u305fvps\u3002
\nVM\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u3068\u3063\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092SQL\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3002
\nmariadb\u3068mysql\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u524a\u9664\u3002
\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306eSQL\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u6d41\u3057\u8fbc\u3093\u3067\u30aa\u30b7\u30de\u30a4\u3002
\n\u306e\u306f\u305a\u3060\u3063\u305f\u3002
\n\u3057\u304b\u3057\u3001rdbms\u306e\u7ba1\u7406db\u304c\u3069\u3093\u306a\u5f79\u5272\u3092\u3057\u3066\u3044\u308b\u304b\u7406\u89e3\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u3002
\ndb\u306e\u7ba1\u7406\u30c4\u30fc\u30eb\u304c\u3001\u30ed\u30fc\u30ab\u30ebpc\u304b\u3089\u63a5\u7d9a\u3067\u304d\u306a\u3044\u3002
\nssh\u30c8\u30f3\u30cd\u30eb\u63a5\u7d9a\u306a\u306e\u3067\u3001db\u304b\u3089\u3059\u308c\u3070\u81ea\u5206\u81ea\u8eab\u306e\u30de\u30b7\u30f3\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3055\u308c\u3066\u3044\u308b\u306e\u3068\u540c\u3058\u3060\u304c\u3001\u305d\u308c\u3066\u3082IP\u6307\u5b9a\u3067\u30dd\u30fc\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u306e\u3067\u3001\u5916\u90e8\u63a5\u7d9a\u3068\u540c\u3058\u306a\u3053\u3068\u306b\u306a\u304b\u306a\u304b\u6c17\u3065\u304b\u306a\u304b\u3063\u305f\u3002
\nroot\u30a2\u30ab\u30a6\u30f3\u30c8\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u306e\u8a2d\u5b9a\u304c\u826f\u304f\u306a\u3044\u3002
\nroot\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u3092\u4fee\u6574\u3057\u3066\u3001\u30c4\u30fc\u30eb\u304c\u63a5\u7d9a\u3067\u304d\u305f\u3002
\n\u3068\u3053\u308d\u304c\u4eca\u5ea6\u306fSQL\u306e\u6d41\u3057\u8fbc\u307f\u3067\u7ba1\u7406DB\u306e\u30c6\u30fc\u30d6\u30eb\u3078\u306e\u3001\u30c7\u30fc\u30bf\u30a4\u30f3\u30dd\u30fc\u30c8\u3067\u30a8\u30e9\u30fc\u3002
\nSQL\u30d5\u30a1\u30a4\u30eb\u306f\u5168\u3066\u306eDB\u3092\u307e\u3068\u3081\u30661\u30d5\u30a1\u30a4\u30eb\u306b\u3057\u3066\u3044\u305f\u306e\u3067\u3001\u30a8\u30e9\u30fc\u3068\u306a\u3063\u305f\u6587\u306e\u5f8c\u304b\u3089\u3092\u5207\u308a\u51fa\u3057\u3066\u5c11\u3057\u305a\u3064\u6d41\u3057\u8fbc\u3080\u3053\u3068\u306b\u3002
\n\u6d41\u3057\u7d42\u308f\u3063\u3066\u3001wordpress modxevolution\u3068\u3082\u306b\u8a18\u4e8b\u304c\u8868\u793a\u3055\u308c\u305f\u306e\u3067\u3001\u624b\u9806\u306fOK\u3068\u5224\u65ad\u3002
\n\u30ea\u30b9\u30c8\u30a2\u7528\u306eSQL\u3092\u4f5c\u308a\u76f4\u3057\u305f\u3044\u306e\u3067\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304b\u3089\u4e00\u65e6\u5fa9\u65e7\u3002
\nMYSQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306eUSER\u30c6\u30fc\u30d6\u30eb\u3068\u3001\u7ba1\u7406\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u307f\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u3001mariadb\u3092\u518d\u30c7\u30d7\u30ed\u30a4\u3002
\nroot\u30e6\u30fc\u30b6\u306e\u6a29\u9650\u3060\u3051\u76f4\u3057\u3066\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7sql\u3092\u6d41\u3057\u3066cms\u3092\u30c1\u30a7\u30c3\u30af\u3002
\n\u554f\u984c\u306a\u3044\u3002
\n\u7d9a\u3044\u3066\u30e1\u30fc\u30eb\u304b\u3089\u306e\u8a18\u4e8b\u306e\u8ffd\u52a0\u3092\u30c1\u30a7\u30c3\u30af\u3002
\n\u3042\u308c\uff1f\u8ffd\u52a0\u3055\u308c\u306a\u3044\u3002
\n\u307e\u305a\u306fWordPress\u306e\u7ba1\u7406\u753b\u9762\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u307f\u308b\u3002
\n\u3067\u304d\u306a\u3044\u3002
\n\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u9055\u3046\u306e\u304b\u3068\u601d\u3044\u3001\u518d\u8a2d\u5b9a\u306e\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u304c\u3001URL\u3092\u8868\u793a\u3057\u3066\u3082\u30c0\u30e1\u3002
\n\u6b21\u306bmodx\u306e\u7ba1\u7406\u753b\u9762\u3002
\n\u3053\u3061\u3089\u306f\u3001php\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308b\u3002
\n\u5185\u5bb9\u306f\u30e1\u30e2\u30ea\u4e0d\u8db3\u3002
\nphp.ini\u3092\u5909\u66f4\u3057\u3066\u30e1\u30e2\u30ea\u30b5\u30a4\u30ba\u3092\u5897\u3084\u3057\u3066\u3082\u30c0\u30e1\u3002
\n\u3055\u3093\u3056\u3093\u8abf\u3079\u3066\u539f\u56e0\u306f\u305d\u308c\u305e\u308c\u306ecms\u306edb\u306e\u30e6\u30fc\u30b6\u30fc\u30a2\u30ab\u30a6\u30f3\u30c8\u66f4\u65b0\u7cfb\u306e\u6a29\u9650\u304c\u7121\u304b\u3063\u305f\u3053\u3068\u3002
\n\u30e6\u30fc\u30b6\u30fc\u30c6\u30fc\u30d6\u30eb\u306f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305fsql\u304b\u3089\u5fa9\u6d3b\u3055\u305b\u305f\u306e\u3067\u3001\u554f\u984c\u306a\u3044\u3068\u601d\u3063\u305f\u306e\u304c\u305d\u3046\u3058\u3083\u306a\u304b\u3063\u305f\u3002
\n\u591a\u5206information schema\u304bperformance schema\u30c6\u30fc\u30d6\u30eb\u3042\u305f\u308a\u306b\u3001\u30e6\u30fc\u30b6\u30fc\u306edb\u306b\u5bfe\u3059\u308b\u6a29\u9650\u60c5\u5831\u304c\u8a18\u9332\u3055\u308c\u3066\u3044\u308b\u306e\u3060\u308d\u3046\u3002
\n\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u304c\u5b8c\u4e86\u3059\u308b\u307e\u3067\u307b\u307c1\u65e5\u304b\u304b\u3063\u3066\u3057\u307e\u3063\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

apt\u304c\u52d5\u304b\u306a\u304f\u306a\u3063\u3066\u3057\u307e\u3063\u305fvps\u3002 VM\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u3068\u3063\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092SQL\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3002 mariadb\u3068mysql\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u524a\u9664\u3002 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306eSQL\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u6d41\u3057\u8fbc\u3093\u3067\u30aa\u30b7\u30de\u30a4\u3002 \u306e … <\/p>\n

“ubuntu 20.04\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u5931\u6557\u306e\u59cb\u672b” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1363","post","type-post","status-publish","format-standard","hentry","category-chat"],"views":785,"_links":{"self":[{"href":"https:\/\/gyms-web.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gyms-web.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gyms-web.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gyms-web.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gyms-web.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1363"}],"version-history":[{"count":0,"href":"https:\/\/gyms-web.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1363\/revisions"}],"wp:attachment":[{"href":"https:\/\/gyms-web.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gyms-web.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gyms-web.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}