{"id":5353,"date":"2018-04-25T20:12:27","date_gmt":"2018-04-25T11:12:27","guid":{"rendered":"http:\/\/www.spiritofnature.jp\/wptiger\/?p=5353"},"modified":"2018-04-27T20:41:06","modified_gmt":"2018-04-27T11:41:06","slug":"mariadbmysql%e3%82%92%e4%bb%96%e3%81%ae%e3%83%9e%e3%82%b7%e3%83%b3%e3%81%8b%e3%82%89%e3%82%a2%e3%82%af%e3%82%bb%e3%82%b9%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"http:\/\/hireido.blogsite.org\/wptiger\/archives\/5353","title":{"rendered":"mariadb(mysql)\u3092\u4ed6\u306e\u30de\u30b7\u30f3\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b"},"content":{"rendered":"<p>\u52d5\u4f5c\u304c\u9045\u304f\u306a\u308b\u304b\u3082\u3057\u308c\u306a\u3044\u304c\uff0cwordpress\u306e\u672c\u4f53\u304c\u52d5\u304f\u30de\u30b7\u30f3\u3068mariaDB\u306e\u30de\u30b7\u30f3\u3092\u5206\u3051\u3066\u307f\u305f\uff0e\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306fmariaDB\u306flocalhost\u304b\u3089\u3057\u304b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u3044\u306e\u3067\uff0c\/etc\/mysql\/mariadb.conf.d\/50-server.cnf\u3092\u7de8\u96c6\u3057\u3066<\/p>\n<pre>bind-address = 127.0.0.1<\/pre>\n<p>\u3092<\/p>\n<pre>bind-address = 0.0.0.0<\/pre>\n<p>\u306b\u5909\u3048\u308b\uff0e\u6b21\u306bmariadb\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>mysql&gt; grant all privileges on wpDB\u540d.* to wpuser\u540d@&#8221;%&#8221; identified by &#8216;\u30d1\u30b9\u30ef\u30fc\u30c9&#8217; with grant option;<\/p>\n<p>\u3053\u308c\u3067\u4ed6\u306e\u30db\u30b9\u30c8\u304b\u3089mariaDB\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u308b\uff0e<\/p>\n<p>\u3068\uff0c\u3084\u3063\u3066\u307f\u305f\u3082\u306e\u306ewordpress\u3068mariaDB\u3092\u540c\u3058\u30de\u30b7\u30f3\u306b\u7f6e\u3044\u3066\u3044\u305f\u3068\u304d\u3088\u308a\uff0c\u304b\u306a\u308a\u9045\u304f\u306a\u3063\u305f\uff0ewordpress\u3068mariaDB\u9593\u306e\u901a\u4fe1\u304c\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u3068\u306a\u3063\u3066\u3044\u308b\u3088\u3046\u3060\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u52d5\u4f5c\u304c\u9045\u304f\u306a\u308b\u304b\u3082\u3057\u308c\u306a\u3044\u304c\uff0cwordpress\u306e\u672c\u4f53\u304c\u52d5\u304f\u30de\u30b7\u30f3\u3068mariaDB\u306e\u30de\u30b7\u30f3\u3092\u5206\u3051\u3066\u307f\u305f\uff0e\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306fmariaDB\u306flocalhost\u304b\u3089\u3057\u304b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u3044\u306e\u3067\uff0c\/etc\/mysql\/mariadb.conf.d\/50-server.cnf\u3092\u7de8\u96c6\u3057\u3066 bind [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[80,4,81,9],"tags":[45,79],"_links":{"self":[{"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/posts\/5353"}],"collection":[{"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/comments?post=5353"}],"version-history":[{"count":4,"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/posts\/5353\/revisions"}],"predecessor-version":[{"id":5361,"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/posts\/5353\/revisions\/5361"}],"wp:attachment":[{"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/media?parent=5353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/categories?post=5353"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/hireido.blogsite.org\/wptiger\/wp-json\/wp\/v2\/tags?post=5353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}