{"id":55,"date":"2013-04-02T11:04:00","date_gmt":"2013-04-02T02:04:00","guid":{"rendered":"http:\/\/ec2-52-35-32-26.us-west-2.compute.amazonaws.com\/blog\/2013\/04\/02\/20130402110400\/"},"modified":"2013-04-02T11:04:00","modified_gmt":"2013-04-02T02:04:00","slug":"20130402110400","status":"publish","type":"post","link":"http:\/\/daimlars.jp\/blog\/?p=55","title":{"rendered":"MySQL\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb"},"content":{"rendered":"

brew<\/a>\u3055\u3093\u5f37\u529b\u3067\u3059\u3002\u77ac\u6bba\u3067\u7d42\u4e86<\/p>\n

lion:apache2 jun$ brew<\/a> install mysql<\/a><\/p>\n

Warning: Your Xcode<\/a> (4.6) is outdated<\/p>\n

Please install Xcode<\/a> 4.6.1.<\/p>\n

Warning: It appears you have MacPorts<\/a> or Fink<\/a> installed.<\/p>\n

Software installed with other package managers causes known problems for<\/p>\n

Homebrew. If a formula fails to build, uninstall MacPorts<\/a>\/Fink<\/a> and try again.<\/p>\n

==> Downloading https:\/\/downloads.sf.net\/project\/machomebrew\/Bottles\/mysql-5.6.1<\/a><\/p>\n

######################################################################## 100.0%<\/p>\n

==> Pouring mysql<\/a>-5.6.10.mountain_lion.bottle.tar.gz<\/p>\n

==> Caveats<\/p>\n

Set up databases to run AS YOUR USER ACCOUNT with:<\/p>\n

unset TMPDIR<\/p>\n

mysql<\/a>_install_db –verbose –user=`whoami` –basedir=”$(brew<\/a> –prefix mysql<\/a>)” –datadir=\/usr\/local\/var\/mysql<\/a> –tmpdir=\/tmp<\/p>\n<\/p>\n

To set up base tables in another folder, or use a different user to run<\/p>\n

mysqld, view the help for mysql<\/a>_install_db:<\/p>\n

mysql<\/a>_install_db –help<\/p>\n<\/p>\n

and view the MySQL<\/a> documentation:<\/p>\n

* http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/mysql-install-db.html<\/a><\/p>\n

* http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/default-privileges.html<\/a><\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

To run as, for instance, user “mysql<\/a>“, you may need to `sudo`:<\/p>\n

sudo mysql<\/a>_install_db …options…<\/p>\n<\/p>\n

A “\/etc\/my.cnf” from another install may interfere with a Homebrew-built<\/p>\n

server starting up correctly.<\/p>\n<\/p>\n

To connect:<\/p>\n

mysql<\/a> -uroot<\/p>\n<\/p>\n

To have launchd start mysql<\/a> at login:<\/p>\n

ln -sfv \/usr\/local\/opt\/mysql<\/a>\/*.plist ~\/Library\/LaunchAgents<\/p>\n

Then to load mysql<\/a> now:<\/p>\n

launchctl load ~\/Library\/LaunchAgents\/homebrew.mxcl.mysql<\/a>.plist<\/p>\n

Or, if you don’t want\/need launchctl, you can just run:<\/p>\n

mysql<\/a>.server start<\/p>\n

==> Summary<\/p>\n

\ud83c\udf7a \/usr\/local\/Cellar\/mysql<\/a>\/5.6.10: 9244 files, 351M<\/p>\n

lion:apache2 jun$<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

brew\u3055\u3093\u5f37\u529b\u3067\u3059\u3002\u77ac\u6bba\u3067\u7d42\u4e86 lion:apache2 jun$ brew install mysql Warning: Your Xcode (4.6) is outdated Please install Xco […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-55","post","type-post","status-publish","format-standard","hentry","category-engineering"],"_links":{"self":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=55"}],"version-history":[{"count":0,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/55\/revisions"}],"wp:attachment":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}