{"id":1038,"date":"2016-07-11T11:18:40","date_gmt":"2016-07-11T02:18:40","guid":{"rendered":"https:\/\/www.choco.org.uk\/chocodb\/?p=1038"},"modified":"2016-07-14T10:35:57","modified_gmt":"2016-07-14T01:35:57","slug":"mysql%e3%82%92%e5%85%a5%e3%82%8c%e3%82%88%e3%81%86","status":"publish","type":"post","link":"https:\/\/www.choco.org.uk\/chocodb\/?p=1038","title":{"rendered":"ZIP\u5f62\u5f0f\u306eMySQL\u3092\u5165\u308c\u3088\u3046"},"content":{"rendered":"

Windows\u306bMySQL\u3092MSI\u3067\u306a\u304f\u3001ZIP\u304b\u3089\u5165\u308c\u307e\u3059\u3002
\n\u6700\u65b0\u7248\u304c\u51fa\u305f\u6642\u306b\u3001\u30a2\u30f3\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u306e\u304c\u9762\u5012\u306a\u306e\u3068\u30ec\u30b8\u30b9\u30c8\u30ea\u306b\u8db3\u8de1\u304c\u6b8b\u308b\u306e\u304c\u5acc\u306a\u306e\u3067\u3059\u3002<\/p>\n

\u3010\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3011
\n\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u30da\u30fc\u30b8\u3068\u3057\u3066\u306f\u3001\u672c\u5bb6\u3092\u63a8\u5968\u3057\u307e\u3059\u3002
\nhttp:\/\/dev.mysql.com\/downloads\/mysql\/<\/p>\n

\u3053\u3053\u3067ZIP\u30a2\u30fc\u30ab\u30a4\u30d6\u7248\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n

\"mysql01\"
\n\u3053\u3053\u3067\u53e4\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u9078\u629e\u3057\u305f\u3051\u308c\u3070\u3001\u53f3\u5074\u306e\u30ea\u30f3\u30af\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002
\n\u3010Looking for previous GA versions?\u3011<\/p>\n

\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305fZIP\u30d5\u30a1\u30a4\u30eb\u3092\u9069\u5f53\u306a\u5834\u6240\u306b\u89e3\u51cd\u3057\u305f\u3089\u3001\u81ea\u5206\u304c\u7f6e\u304d\u305f\u3044\u5834\u6240\u306b\u30b3\u30d4\u30fc\u3057\u3066\u304f\u3060\u3055\u3044\u3002
\n\u79c1\u306f\u300cc:\\mysql\u300d\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3057\u305f\u3002<\/p>\n

\u3010\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3011
\n\u89e3\u51cd\u3057\u305f\u4e2d\u306b\u300cmy-default.ini\u300d\u304c\u3042\u308b\u306e\u3067\u3001\u305d\u308c\u3092\u7de8\u96c6\u3057\u307e\u3059\u3002<\/p>\n

\u7de8\u96c6\u3057\u305f\u3089\u3001\u305d\u308c\u3092\u300cmy.ini\u300d\u306b\u30ea\u30cd\u30fc\u30e0\u3057\u3066\u3001\u300cbin\u300d\u30d5\u30a9\u30eb\u30c0\u5185\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002
\n\u79c1\u306e\u5834\u5408\u306f\u300cc:\\mysl\\bin\\my.ini\u300d\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n

\u3053\u3053\u3067\u9593\u9055\u3046\u306e\u306f\u3001Windows\u30d5\u30a9\u30eb\u30c0\u914d\u4e0b\u3068\u304b\u3001Windows\\system32\u30d5\u30a9\u30eb\u30c0\u5185\u306b\u30b3\u30d4\u30fc\u3057\u3066\u3057\u307e\u3046\u30b1\u30fc\u30b9\u3067\u3059\u3002
\n\u5fc5\u305a\u3001mysql\u3092\u5165\u308c\u305f\u30d5\u30a9\u30eb\u30c0\u5185\u306b\u30b3\u30d4\u30fc\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n

\u3010\u300cmy.ini\u300d\u306e\u4fee\u6b63\u5185\u5bb9\u3011
\n[mysqld]
\ncharacter-set-server = utf8
\ncollation-server = utf8_general_ci
\nexplicit_defaults_for_timestamp = TRUE<\/p>\n

[mysql]
\ndefault-character-set = utf8<\/p>\n

\u3010\u74b0\u5883\u5909\u6570\u3078\u306e\u767b\u9332\u3011
\n\u30de\u30a4\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u304b\u3089\u74b0\u5883\u5909\u6570\u300cpath\u300d\u5185\u306b\u4ee5\u4e0b\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002
\nC:\\mysql\\bin<\/p>\n

\u3010\u8d77\u52d5\u3011
\n\u8d77\u52d5\u3067\u3059\u304c\u3001\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u306b\u306a\u308a\u307e\u3059\u3002
\nc:\\mysql\\bin>mysqld –standalone –console<\/p>\n

\u4e0a\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5165\u529b\u3057\u3066\u3001Enter\u30ad\u30fc\u3092\u62bc\u3059\u3068\u3044\u308d\u3044\u308d\u306a\u60c5\u5831\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u304c\u3001\u6700\u5f8c\u306e\u65b9\u3067\u300cshutdows\u300d\u3068\u304b\u8868\u793a\u3055\u308c\u3066\u3044\u306a\u3051\u308c\u3070\u307b\u307c\u6210\u529f\u3067\u3059\u3002<\/p>\n

\u305d\u306e\u5f8c\u3001\u56f3\u306e\u3088\u3046\u306a\u753b\u9762\u304c\u51fa\u308c\u3070\u5b8c\u74a7\u3067\u3059\u3002
\n\"mysql02\"<\/p>\n

\u3010\u7d42\u4e86\u3011
\n\u7d42\u4e86\u6642\u306f\u5225window\uff08\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\uff09\u3092\u958b\u3044\u3066\u3001\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5165\u529b\u3057\u307e\u3059\u3002
\nmysqladmin shutdown -u root -p<\/p>\n

\u5b9f\u969b\u554f\u984c\u3068\u3057\u3066Apache\u3068\u4e21\u65b9\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u753b\u9762\u3092\u8868\u793a\u3057\u3066\u304a\u304f\u306e\u306f\u3001\u898b\u6804\u3048\u304c\u3088\u304f\u7121\u3044\u306e\u3067\u30b5\u30fc\u30d3\u30b9\u306b\u767b\u9332\u3057\u3066\u3057\u307e\u3046\u306e\u304c\u73fe\u5b9f\u89e3\u3060\u3068\u601d\u3044\u307e\u3059\u3002
\n\u305d\u308c\u3067\u30b5\u30fc\u30d3\u30b9\u3092\u624b\u52d5\u3067\u8a2d\u5b9a\u3057\u3066\u3001\u4f7f\u3044\u305f\u3044\u6642\u306b\u8d77\u52d5\u3055\u305b\u308b\u3067\u3059\u306d\u3002<\/p>\n

\u3010\u30b5\u30fc\u30d3\u30b9\u3078\u306e\u767b\u9332\u65b9\u6cd5\u3011
\n<<\u6ce8\u610f\uff01>>\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u5fc5\u305a\u7ba1\u7406\u8005\u3068\u3057\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002
\n\u2605Windows\u306e\u30b5\u30fc\u30d3\u30b9\u306b\u767b\u9332\uff08\uff0d\uff0dinstall\uff09\u30cf\u30a4\u30d5\u30f3\u4e8c\u3064\u3067\u3059\u3002
\nC:\\> “C:\\mysql\\bin\\mysqld” –install<\/p>\n

\u2605Windows\u306e\u30b5\u30fc\u30d3\u30b9\u304b\u3089\u524a\u9664\uff08\uff0d\uff0drevome\uff09\u30cf\u30a4\u30d5\u30f3\u4e8c\u3064\u3067\u3059\u3002
\nc:\\mysql\\bin>mysqld –remove MySQL<\/p>\n","protected":false},"excerpt":{"rendered":"

\u5b9f\u884c\u30d5\u30a1\u30a4\u30eb\u5f62\u5f0f\uff08*.msi\uff09\u3067\u306a\u304f\u3001\uff08*.zip\uff09\u5f62\u5f0f\u3067Windows\u306bmysql\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[11,39],"tags":[65,51,66],"class_list":["post-1038","post","type-post","status-publish","format-standard","hentry","category-mysql","category-server","tag-mysql","tag-windows","tag-zip"],"_links":{"self":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts\/1038","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1038"}],"version-history":[{"count":12,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts\/1038\/revisions"}],"predecessor-version":[{"id":1055,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=\/wp\/v2\/posts\/1038\/revisions\/1055"}],"wp:attachment":[{"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.choco.org.uk\/chocodb\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}