{"id":7057,"date":"2019-10-31T15:20:27","date_gmt":"2019-10-31T06:20:27","guid":{"rendered":"http:\/\/hayama-cloudservertest.com\/?p=7057"},"modified":"2019-10-31T15:38:09","modified_gmt":"2019-10-31T06:38:09","slug":"wp%e3%81%aedb%e3%81%ae%e3%80%81%e6%8e%a5%e7%b6%9a%e3%82%a8%e3%83%a9%e3%83%bc%e4%bf%ae%e6%ad%a3%e5%a0%b1%e5%91%8a","status":"publish","type":"post","link":"http:\/\/hayama-cloudservertest.com\/?p=7057","title":{"rendered":"WP\u306eDB\u306e\u3001\u63a5\u7d9a\u30a8\u30e9\u30fc\u4fee\u6b63\u5831\u544a"},"content":{"rendered":"\n<p>\u4eca\u307e\u3067\u3001Wordpress\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8a2d\u5b9a\u3059\u308b\u969b\u306b\u3001Localhost\u304c\u4f7f\u3048\u305a\u6bce\u56de\u30db\u30b9\u30c8\u540d\u3092\u6307\u5b9a\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u4fee\u6b63\u3057\u3088\u3046\u3068localhost\u306e\u8a2d\u5b9a\u3092\u3044\u3058\u3063\u305f\u308a\u306a\u3093\u3060\u308a\u3068\u3057\u3066\u8ff7\u8d70\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u304c\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>\u5b9f\u306fmysql\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u63a5\u7d9a\u5143\u30e6\u30fc\u30b6\u30fc\u3092\u201d%\u201d\u3059\u306a\u308f\u3061\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u306b\u3057\u3066\u3044\u305f\u305f\u3081\u3001\u63a5\u7d9a\u3067\u304d\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u304c\u767a\u899a\u3057\u307e\u3057\u305f\uff01<\/p>\n\n\n\n<p>\u3082\u3068\u3082\u3068\u3001DB\u306b\u5bfe\u3057\u3066\u8a2d\u5b9a\u3092\u4ee5\u4e0b\u306e\u69cb\u6587\u3067\u884c\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><em>grant all on DBname.* to DBuser@\"%\" identified by 'DBpassword';<\/em><\/pre>\n\n\n\n<p>\u3053\u308c\u306b\u4ee5\u4e0b\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3067\u3001DB\u63a5\u7d9a\u5143\u3092Localhost\u3067\u901a\u7528\u3059\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u306e\u3067\u3059\uff01<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><em>grant all on DBname.* to DBuser@\"localhost\" identified by 'DBpassword';<\/em><\/pre>\n\n\n\n<p>\u3053\u308c\u306f\u8a73\u3057\u304f\u306f\u4e0b\u306eHP\u306b\u66f8\u304b\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u5185\u306blocalhost\u304c\u542b\u307e\u308c\u3066\u3044\u306a\u3044\u305f\u3081\u3060\u3063\u305f\u3089\u3057\u3044\u306e\u3067\u3059\u3002<br>\u3082\u3068\u3082\u3068\u3053\u306eWordpress\u306e\u7d44\u307f\u65b9\u306f\u3001DB\u30b5\u30fc\u30d0\u3092Web\u7528\u3068\u306f\u5225\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u5206\u3051\u3066\u3001\u30b5\u30fc\u30d02\u672c\u4f53\u5236\u3067HP\u3092\u904b\u7528\u3059\u308b\u524d\u63d0\u3067\u4f5c\u6210\u3057\u3066\u3044\u305f\u305f\u3081\u3001\u3053\u306e\u3088\u3046\u306a\u3053\u3068\u306b\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u3068\u3044\u3046\u3053\u3068\u3067\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb\u89e3\u6c7a\u3057\u305f\u306e\u3067\u3001WP\u306e\u5c0e\u5165\u304c\u3053\u308c\u304b\u3089\u306f\u5c11\u3057\u697d\u306b\u306a\u308a\u305d\u3046\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u4ee5\u4e0a\uff01\u672c\u65e5\u306e\u5831\u544a\u3067\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u53c2\u8003\uff1a<a href=\"https:\/\/b.l0g.jp\/mysql\/user-at-localhost\/\">https:\/\/b.l0g.jp\/mysql\/user-at-localhost\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u307e\u3067\u3001Wordpress\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8a2d\u5b9a\u3059\u308b\u969b\u306b\u3001Localhost\u304c\u4f7f\u3048\u305a\u6bce\u56de\u30db\u30b9\u30c8\u540d\u3092\u6307\u5b9a\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u4fee\u6b63\u3057\u3088\u3046\u3068localhost\u306e\u8a2d\u5b9a\u3092\u3044\u3058\u3063\u305f\u308a\u306a\u3093\u3060\u308a\u3068\u3057\u3066\u8ff7\u8d70\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u304c\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=\/wp\/v2\/posts\/7057"}],"collection":[{"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7057"}],"version-history":[{"count":2,"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=\/wp\/v2\/posts\/7057\/revisions"}],"predecessor-version":[{"id":7059,"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=\/wp\/v2\/posts\/7057\/revisions\/7059"}],"wp:attachment":[{"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7057"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/hayama-cloudservertest.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}