{"id":2456,"date":"2012-09-04T16:19:43","date_gmt":"2012-09-04T07:19:43","guid":{"rendered":"http:\/\/mike.md.tsukuba.ac.jp\/terui\/blog\/?p=2456"},"modified":"2021-12-27T09:30:29","modified_gmt":"2021-12-27T00:30:29","slug":"mike%e3%81%a1%e3%82%83%e3%82%93%e3%81%ae%e6%9b%b4%e6%96%b0osx10-8%e3%82%b5%e3%83%bc%e3%83%90-%e3%81%9d%e3%81%ae%ef%bc%91%ef%bc%91%e3%83%bcmysql","status":"publish","type":"post","link":"https:\/\/nbsigh2.com\/?p=2456","title":{"rendered":"OSX10.8\u30b5\u30fc\u30d0\u3000\u305d\u306e\uff11\uff13\u3000MySQL"},"content":{"rendered":"

M\u306e\u66f4\u65b0(Mountain Lion OSX10.8\u30b5\u30fc\u30d0) \u305d\u306e\uff11\uff13\u30fcMySQL
\nApple \u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306eMySQL \u3092\u3084\u3081\u3061\u3083\u3063\u305f\u3089\u3057\u3044\u3002 WordPress\u3067\u3053\u308c\u307e\u3067\u30d6\u30ed\u30b0\u3092\u4f5c\u3063\u3066\u3044\u305f\u306e\u3067MySQL\u306e\u307b\u3046\u304c\u3044\u3044\u3002\u305d\u3053\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002 Install MyAQL on Mpuntain Lion<\/a>\u306b\u3057\u305f\u304c\u3063\u305f\u300210.6 \u7528\u306e\u3067\u52d5\u304f\u3089\u3057\u3044\u3002 dev.mysql.com\/downloads\/mysql<\/a> \u3067Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive(mysql-5.5.27-osx10.6-x86_64.dmg)\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3002
\n\u30e6\u30fc\u30b6\u767b\u9332\u3092\u6c42\u3081\u3089\u308c\u308b\u304c\u3001\u4e0b\u306e\u226b No thanks, just start my download!\u3000\u3092\u30af\u30ea\u30c3\u30af\u3059\u308c\u3070\u3044\u3044\u3002 \u30c0\u30d6\u30eb\u30af\u30a4\u30c3\u30af\u3057\u3066\u89e3\u51cd\u3057\u3001mysql-5.5.27-osx10.6-x86_64.pkg \u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3001unidentified developer \u306e\u3060\u304b\u3089\u3060\u3081\u3060\u3068\u3044\u3063\u3066\u3044\u308b\u3002 \u53f3\u30af\u30ea\u30c3\u30af\u3067\u3053\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u958b\u304f\u304b\u3089\u3000\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9.app\u3000\u3092\u9078\u629e\u3059\u308b\u3002\u3000\u300c\u30db\u30f3\u30c8\u306b\u3044\u3044\u304b\u300d\u3068\u3044\u3046\u306e\u3067\u3000Open\u3000\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u3042\u3068\u306f\u666e\u901a\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u304b\u3089\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u5b9f\u65bd\u3059\u308b\u3002gatekeeper\u3067\u8a2d\u5b9a\u3059\u308b<\/a>\u3068\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3067\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b\u3051\u3069\u3001\u4f55\u56de\u3082\u3053\u306e\u30b5\u30a4\u30c8\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u308f\u3051\u3067\u306f\u306a\u3044\u306e\u3067\u3001\u3053\u306e\u65b9\u6cd5\u3067\u3044\u3044\u306e\u3060\u3002
\n\u540c\u69d8\u306bMySQLStartupItem.pkg\u3082\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002\u3053\u308c\u306f\u30b5\u30fc\u30d0\u8d77\u52d5\u6642\u306bMySQL\u3082\u8d77\u52d5\u3055\u305b\u308b\u305f\u3081\u3002
\nMySQL.prefPane \u3082\u540c\u69d8\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002\u3053\u308c\u306f\u00a0\u30b7\u30b9\u30c6\u30e0\u74b0\u5883\u8a2d\u5b9a\u306e\u30a2\u30a4\u30c6\u30e0\u3002
\n\u4f7f\u3046\u524d\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u3042\u308b\u3068\u3044\u3046\u30d7\u30ed\u30f3\u30d7\u30c8\u304c\u3067\u3066\u304f\u308b\u306e\u3067\u3001\u3042\u3093\u305f\u3060\u3051\u3042\u308b\u3044\u306f\u3059\u3079\u3066\u306e\u30e6\u30fc\u30b6\u3082\u4f7f\u3048\u308b\u3088\u3046\u306b\u3059\u308b\u304b\u306e\u3069\u3063\u3061\u304b\u3092\u9078\u3076\u3002 \u30b7\u30b9\u30c6\u30e0\u74b0\u5883\u8a2d\u5b9a\u306eOther \u306bMySQL\u306e\u30dc\u30bf\u30f3\u304c\u3067\u304d\u3066\u3044\u308b\u3002Start\/Stop \u3092\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3067\u304d\u308b\u308f\u3051\u3060\u3002\u307e\u305fAutomatically Start MySQL Server on Startup \u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u308b\u3068\u30b5\u30fc\u30d0 \u8d77\u52d5\u6642\u306b\u8d77\u52d5\u3055\u305b\u308b\uff0f\u3055\u305b\u306a\u3044\u306e\u8a2d\u5b9a\u304c\u3067\u304d\u308b\u3002<\/span>
\n\u3069\u3053\u306b\u306a\u306b\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305f\u304b\u7b49\u306fReadMe.txt\u3092\u8aad\u3081\u3070\u3044\u3044\u3002
\n\u30b7\u30b9\u30c6\u30e0\u74b0\u5883\u8a2d\u5b9a\u306eMySQL\u304b\u3089MySQL\u3092\u8d77\u52d5\u3057\u3066\u304a\u3044\u3066\u3001\u30bf\u30fc\u30df\u30ca\u30eb\u3092\u8d77\u52d5\u3059\u308b\u3002\u81ea\u5206\u306edirectory\u306b\u3044\u308b\u306f\u305a\u3060\u304b\u3089
\n.bash_profile \u3068\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u308a\u3001\u4e2d\u306b<\/p>\n

export PATH=$PATH:\/usr\/local\/mysql\/bin<\/p><\/blockquote>\n

\u306e\uff11\u884c\u3092\u66f8\u304f\u3002
\n\u3055\u3089\u306b$ mysql -u root \u3068\u5165\u529b\u3057\u3066MySQL\u306b\u5165\u308a\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\u3002<\/p>\n

\n
hoge:~ hoge$ mysql -u root<\/div>\n
Welcome to the MySQL monitor. \u00a0Commands end with ; or g.<\/div>\n
Your MySQL connection id is 4<\/div>\n
Server version: 5.5.27 MySQL Community Server (GPL)<\/div>\n
Copyright (c) 2000, 2011, Oracle and\/or its affiliates. All rights reserved.<\/div>\n
Oracle is a registered trademark of Oracle Corporation and\/or its<\/div>\n
affiliates. Other names may be trademarks of their respective<\/div>\n
owners.<\/div>\n
Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.<\/div>\n<\/blockquote>\n
mysql>\u306e\u30d7\u30ed\u30f3\u30d7\u30c8\u306e\u5f8c\u306b<\/div>\n
\n
GRANT ALL ON *.* TO ‘root’@’localhost’ IDENTIFIED BY PASSWORD \u00a0‘xxxxxx’ \u00a0WITH GRANT OPTION;<\/div>\n<\/blockquote>\n
\u3068\u5165\u529b\u3059\u308b\uff08\u6539\u884c\u306a\u3057\u306e\uff11\u884c\u3060\uff09\u3002’xxxxxx ‘\u306bMySQL\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u6587\u5b57\u5217\u3092\u5165\u308c\u308b<\/div>\n
\n
mysql> GRANT ALL ON *.* TO ‘root’@’localhost’ IDENTIFIED BY ‘xxxxxx’ WITH GRANT OPTION;<\/div>\n
Query OK, 0 rows affected (0.00 sec)<\/div>\n<\/blockquote>\n
\u3068\u8fd4\u3063\u3066\u304f\u308b\u304b\u3089\u3000quit \u3092\u5165\u529b\u3059\u308b\u3002<\/div>\n
\n
mysql> quit<\/div>\n
Bye<\/div>\n<\/blockquote>\n
\/var\u306bmysql\u3068\u3044\u3046directory \u3092\u4f5c\u308a\u3001\u30b7\u30f3\u30dc\u30ea\u30c3\u30af\u30ea\u30f3\u30af\u3092\u5f35\u308b\u3002<\/div>\n
\n
\n
hoge:~ hoge$ sudo mkdir \/var\/mysql<\/div>\n
hoge:~ hoge$ sudo ln -s \/tmp\/mysql.sock \/var\/mysql\/mysql.sock<\/div>\n<\/blockquote>\n<\/div>\n
\/var\/mysql\u3000\u3067\u30b7\u30f3\u30dc\u30ea\u30c3\u30af\u30ea\u30f3\u30af\u304c\u3067\u304d\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u3002<\/div>\n
lrwxr-xr-x \u00a0 1 root \u00a0wheel \u00a0 \u00a015 Sep \u00a04 16:41 mysql.sock -> \/tmp\/mysql.sock<\/div>\n

MySQL \u3092\u30de\u30cd\u30fc\u30b8\u3059\u308b\u306e\u306bSequel Pro<\/a>\u304c\u85a6\u3081\u3089\u308c\u3066\u3044\u308b\u3044\u308b\u3051\u3069\u3001\u307e\u3060\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u306a\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\t\t\t\t\t\t<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,3],"tags":[],"class_list":["post-2456","post","type-post","status-publish","format-standard","hentry","category-mountain-lion-server","category-3"],"_links":{"self":[{"href":"https:\/\/nbsigh2.com\/index.php?rest_route=\/wp\/v2\/posts\/2456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nbsigh2.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nbsigh2.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nbsigh2.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nbsigh2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2456"}],"version-history":[{"count":1,"href":"https:\/\/nbsigh2.com\/index.php?rest_route=\/wp\/v2\/posts\/2456\/revisions"}],"predecessor-version":[{"id":20641,"href":"https:\/\/nbsigh2.com\/index.php?rest_route=\/wp\/v2\/posts\/2456\/revisions\/20641"}],"wp:attachment":[{"href":"https:\/\/nbsigh2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nbsigh2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nbsigh2.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}