{"id":3519,"date":"2017-06-15T01:32:23","date_gmt":"2017-06-14T16:32:23","guid":{"rendered":"http:\/\/stuffy.dip.jp\/wordpress\/?p=3519"},"modified":"2017-06-18T20:54:14","modified_gmt":"2017-06-18T11:54:14","slug":"create-database-and-user-on-wordpress","status":"publish","type":"post","link":"https:\/\/www.stuffy.site\/wordpress\/?p=3519","title":{"rendered":"MySQL \u4e92\u63dbMariaDB \u3067WordPress \u306e\u521d\u671f\u8a2d\u5b9a"},"content":{"rendered":"<p>\u524d\u56de\u306e\u7d9a\u304d\u3067\u3001\u4eca\u56de\u306fMySQL \u4e92\u63db\u306eMariaDB \u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210\u3057\u3066\u3044\u304d\u307e\u3059\u3002\u65e9\u901f\u3001<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\"># mysqladmin create 'databasename' -u root -p<\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3001&#8217;databasename&#8217; \u306f\u4e88\u3081\u8003\u3048\u305f\u30aa\u30ea\u30b8\u30ca\u30eb\u306e\u540d\u524d\uff08\u4f8b\uff1awordpress , didital_life, casual \u306a\u3069\uff09\u3067\u4f55\u3067\u3082\u826f\u3044\u3067\u3059\u3002<\/p>\n<p>mariaDB \u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u4e00\u610f\u306e\u30e6\u30fc\u30b6\u30fc\u540d\u3001&#8217;username&#8217;\u306b\u5bfe\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u3066\u3001\u6a29\u9650\u3092\u4e0e\u3048\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\"># mysql -u root -p\r\n# mariaDB [&lt;none&gt;] <span style=\"color: blue;\">GRANT ALL PRIVILEGES ON 'databasename'.* TO 'username'@localhost IDENTIFIED BY 'password';<\/span><\/pre>\n<p>Query OK , 0 rows affected \u3068\u8868\u793a\u3055\u308c\u308c\u3070OK\u3067\u3059\u3002<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\"># mariaDB[&lt;none&gt;] <span style=\"color: blue;\">FLUSH PRIVILEGES;<\/span><\/pre>\n<p>Query OK \u3002exit \u307e\u305f\u306f<span style=\"font-family: arial;\">\\<\/span>q \u3067\u30d7\u30ed\u30f3\u30d7\u30c8\u304b\u3089\u51fa\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3520\" src=\"https:\/\/www.stuffy.site\/wordpress\/wp-content\/uploads\/2017\/06\/2017-06-14-e1497785835387.png\" alt=\"\" width=\"683\" height=\"384\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u524d\u56de\u306e\u30da\u30fc\u30b8\u304b\u3089\u306e\u9077\u79fb\u753b\u9762\u3001wp-admin\/install.php \u306b\u3001WordPress \u306e\u30bf\u30a4\u30c8\u30eb\u3001\u7ba1\u7406\u30e6\u30fc\u30b6\u30fc\u540d\u3001\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u5165\u529b\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u30e1\u30e2\u5e33\u306a\u3069\u306b\u8a18\u9332\u3001[\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb] \u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u5148\u307b\u3069\u30e1\u30e2\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3001\u30ed\u30b0\u30a4\u30f3\u3059\u308c\u3070\u30d6\u30ed\u30b0\u30b5\u30fc\u30d0\u30fc\u306e\u521d\u671f\u8a2d\u5b9a\u3001\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3542\" src=\"https:\/\/www.stuffy.site\/wordpress\/wp-content\/uploads\/2017\/06\/2017-06-15-e1497786291256.png\" alt=\"\" width=\"683\" height=\"384\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u53c2\u8003URL: <a href=\"https:\/\/wpdocs.osdn.jp\/WordPress_%E3%81%AE%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB#Detailed_Instructions\">WordPress \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb &#8211; WordPress Codex \u65e5\u672c\u8a9e\u7248<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u524d\u56de\u306e\u7d9a\u304d\u3067\u3001\u4eca\u56de\u306fMySQL \u4e92\u63db\u306eMariaDB \u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210\u3057\u3066\u3044\u304d\u307e\u3059\u3002\u65e9\u901f\u3001 # mysqladmin create &#8216;databasename&#8217; -u root -p \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3001&#038;#8 &hellip; <a href=\"https:\/\/www.stuffy.site\/wordpress\/?p=3519\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">MySQL \u4e92\u63dbMariaDB \u3067WordPress \u306e\u521d\u671f\u8a2d\u5b9a<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,3,62,33,6,23],"tags":[],"class_list":["post-3519","post","type-post","status-publish","format-standard","hentry","category-apache","category-linux","category-mysql","category-php","category-settings","category-wordpress"],"_links":{"self":[{"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3519"}],"version-history":[{"count":24,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3519\/revisions"}],"predecessor-version":[{"id":3623,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3519\/revisions\/3623"}],"wp:attachment":[{"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}