{"id":4407,"date":"2009-01-13T23:58:00","date_gmt":"2009-01-13T14:58:00","guid":{"rendered":"http:\/\/www.inohome.net\/kuma\/blog\/archives\/2009\/01\/post_4407.html"},"modified":"2009-01-13T23:58:00","modified_gmt":"2009-01-13T14:58:00","slug":"%e3%80%90%e6%8a%80%e3%80%91sql%e3%81%aa%e3%82%93%e3%81%a6%e5%ab%8c%e3%81%84%e3%81%a0%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.inohome.net\/kuma\/blog\/archives\/2009\/01\/post_4407.html","title":{"rendered":"\u3010\u6280\u3011SQL\u306a\u3093\u3066\u5acc\u3044\u3060\u3002"},"content":{"rendered":"<p>\u6628\u65e5\u3069\u3046\u3084\u3063\u3066\u3082sql\u30d5\u30a1\u30a4\u30eb\u3092\u98df\u3063\u3066\u304f\u308c\u306a\u304b\u3063\u305f<br \/>MySQL\u304c\u7d20\u76f4\u306b\u52d5\u3044\u305f\u3002\u539f\u56e0\u5168\u304f\u4e0d\u660e\u3002<br \/>\u5909\u306a\u30e6\u30fc\u30b6\u30fc\u3092drop\u3057\u305f\u306e\u304c\u3088\u304b\u3063\u305f\u306e\u304bPRIVILEGES\u3092all\u3067\u53d6\u5f97\u3057\u3066\u3044\u308b\u30e6\u30fc\u30b6\u30fc\u3067\u6d41\u305b\u306a\u304b\u3063\u305fsql\u3092\u7c21\u5358\u306b\u53d7\u7406\u3057\u3066\u304f\u308c\u305f\u3002<\/p>\n<p>CREATE DATABASE \u3054\u306b\u3087 DEFAULT CHARACTER SET utf8;<br \/>GRANT ALL PRIVILEGES ON \u3054\u306b\u3087.* TO \u307b\u3078@localhost IDENTIFIED BY &#8216;\u306a\u305e&#8217;;<br \/>FLUSH PRIVILEGES;<\/p>\n<p>\u3053\u306e\u4e09\u884c\u3092root\u3067\u98df\u3063\u3066\u304f\u308c\u308b\u4ee5\u5916\u306f\u4e00\u5207\u30c0\u30e1\u3067\u3057\u305f\u306d\u3002<br \/>\u5909\u306a\u3068\u304d\u306fdrop user\u3067\u3059\u306a\u3002<\/p>\n<p>\u30b7\u30b9\u30c6\u30e0\u8981\u4ef6\u306f<br \/>Web\u30b5\u30fc\u30d0 Apache2<br \/>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0 MySQL 5.0.22\u4ee5\u964d<br \/>\u30e1\u30fc\u30eb\u30b5\u30fc\u30d0\u3000Postfix 2.3.x\u4ee5\u964d<br \/>\u8a8d\u8a3c\u30b5\u30fc\u30d0 Cyrus SASL2 saslauthd<br \/>(\u4f7f\u7528\u3059\u308bPostfix\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u5bfe\u5fdc\u3059\u308b\u3082\u306e\uff09<\/p>\n<p>PHP 5.1.x\u4ee5\u964d<br \/>  \u4ee5\u4e0b\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u3082\u5fc5\u8981\u3067\u3059\u3002<br \/>  mbstring<br \/>  mysql<br \/>  ldap<br \/>  gd<br \/>  Smarty<br \/>  PEAR<\/p>\n<p>  PEAR \u306f\u4ee5\u4e0b\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u304c\u5fc5\u8981\u3067\u3059\u3002<br \/>   DB<br \/>   HTML_QuickForm<\/p>\n<p>\u3046\u30fc\u3093\u30b0\u30ed\u3059\u304e\u3002<\/p>\n<p>\u307b\u3068\u3093\u3069\u306fyum\u3067\u5165\u3063\u305f\u3093\u3067\u3059\u304c\u306d\u3002<br \/>Smarty\u304c\u3044\u307e\u3044\u3061\u3088\u304f\u308f\u304b\u3089\u306a\u3044\u3002<\/p>\n<p>\u30a2\u30d7\u30ea\u306fRHEL\u306erpm\u306e\u30c7\u30d5\u30a9\u30d1\u30b9\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u305d\u3046\u3067<br \/>remi repo.\u304b\u3089wget\u3057\u3066\u304d\u307e\u3057\u305f\u304cMissing Dependency\u306e\u5c71\u3067\u3046\u3093\u3056\u308a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6628\u65e5\u3069\u3046\u3084\u3063\u3066\u3082sql\u30d5\u30a1\u30a4\u30eb\u3092\u98df\u3063\u3066\u304f\u308c\u306a\u304b\u3063\u305fMySQL\u304c\u7d20\u76f4\u306b\u52d5\u3044\u305f\u3002\u539f\u56e0\u5168\u304f\u4e0d\u660e\u3002\u5909\u306a\u30e6\u30fc\u30b6\u30fc\u3092drop\u3057\u305f\u306e\u304c\u3088\u304b\u3063\u305f\u306e\u304bPRIVILEGES\u3092all\u3067\u53d6\u5f97\u3057\u3066\u3044\u308b\u30e6\u30fc\u30b6\u30fc\u3067\u6d41\u305b\u306a\u304b\u3063\u305fsql\u3092\u7c21\u5358\u306b\u53d7\u7406\u3057\u3066\u304f &hellip; <a href=\"https:\/\/www.inohome.net\/kuma\/blog\/archives\/2009\/01\/post_4407.html\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;\u3010\u6280\u3011SQL\u306a\u3093\u3066\u5acc\u3044\u3060\u3002&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,1],"tags":[],"class_list":["post-4407","post","type-post","status-publish","format-standard","hentry","category-from-mixi","category-uncategorized"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inohome.net\/kuma\/wp-json\/wp\/v2\/posts\/4407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inohome.net\/kuma\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inohome.net\/kuma\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inohome.net\/kuma\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inohome.net\/kuma\/wp-json\/wp\/v2\/comments?post=4407"}],"version-history":[{"count":0,"href":"https:\/\/www.inohome.net\/kuma\/wp-json\/wp\/v2\/posts\/4407\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inohome.net\/kuma\/wp-json\/wp\/v2\/media?parent=4407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inohome.net\/kuma\/wp-json\/wp\/v2\/categories?post=4407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inohome.net\/kuma\/wp-json\/wp\/v2\/tags?post=4407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}