{"id":653,"date":"2008-09-02T12:30:55","date_gmt":"2008-09-02T03:30:55","guid":{"rendered":"https:\/\/wp-78qb7hnp.pistolfly.jp\/weblog\/2008\/09\/macportsmysql5.html"},"modified":"2008-09-02T12:30:55","modified_gmt":"2008-09-02T03:30:55","slug":"macportsmysql5","status":"publish","type":"post","link":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html","title":{"rendered":"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb"},"content":{"rendered":"<pre class=\"command-line\">$ sudo port install mysql5 +server\n--->  Fetching mysql5\n--->  Verifying checksum(s) for mysql5\n--->  Extracting mysql5\n--->  Configuring mysql5\n--->  Building mysql5 with target all\n--->  Staging mysql5 into destroot\n--->  Creating launchd control script\n###########################################################\n# A startup item has been generated that will aid in\n# starting mysql5 with launchd. It is disabled\n# by default. Execute the following command to start it,\n# and to cause it to launch at startup:\n#\n# sudo launchctl load -w \/Library\/LaunchDaemons\/org.macports.mysql5.plist\n###########################################################\n--->  Installing mysql5 5.0.67_0+server\n******************************************************\n* In order to setup the database, you might want to run\n* sudo -u mysql mysql_install_db5\n* if this is a new install\n******************************************************\n--->  Activating mysql5 5.0.67_0+server\n--->  Cleaning mysql5\n<\/pre>\n<p>\u81ea\u52d5\u8d77\u52d5\u3092\u8a2d\u5b9a\u3002<\/p>\n<pre class=\"command-line\">$ sudo launchctl load -w \/Library\/LaunchDaemons\/org.macports.mysql5.plist\n<\/pre>\n<p>mysql  \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8a2d\u5b9a\u3002<\/p>\n<pre class=\"command-line\">$ sudo -u mysql mysql_install_db5\nInstalling MySQL system tables...\n080902 12:32:58 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295\n080902 12:32:58 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295\n080902 12:32:58 [Warning] Setting lower_case_table_names=2 because file system for \/opt\/local\/var\/db\/mysql5\/ is case insensitive\nOK\nFilling help tables...\n080902 12:32:58 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295\n080902 12:32:58 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295\n080902 12:32:58 [Warning] Setting lower_case_table_names=2 because file system for \/opt\/local\/var\/db\/mysql5\/ is case insensitive\nOK\nTo start mysqld at boot time you have to copy\nsupport-files\/mysql.server to the right place for your system\nPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !\nTo do so, start the server, then issue the following commands:\n\/opt\/local\/lib\/mysql5\/bin\/mysqladmin -u root password 'new-password'\n\/opt\/local\/lib\/mysql5\/bin\/mysqladmin -u root -h macbook.local password 'new-password'\nAlternatively you can run:\n\/opt\/local\/lib\/mysql5\/bin\/mysql_secure_installation\nwhich will also give you the option of removing the test\ndatabases and anonymous user created by default.  This is\nstrongly recommended for production servers.\nSee the manual for more instructions.\nYou can start the MySQL daemon with:\ncd \/opt\/local ; \/opt\/local\/lib\/mysql5\/bin\/mysqld_safe &\nYou can test the MySQL daemon with mysql-test-run.pl\ncd mysql-test ; perl mysql-test-run.pl\nPlease report any problems with the \/opt\/local\/lib\/mysql5\/bin\/mysqlbug script!\nThe latest information about MySQL is available on the web at\nhttp:\/\/www.mysql.com\nSupport MySQL by buying support\/licenses at http:\/\/shop.mysql.com\n<\/pre>\n<p>root\u30e6\u30fc\u30b6\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\u3084\u533f\u540d\u30a2\u30ab\u30a6\u30f3\u30c8\u3001test\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u524a\u9664\u306a\u3069\u304c\u4ee5\u4e0b\u3067\u5b9f\u884c\u3055\u308c\u308b\u3089\u3057\u3044\u3002<\/p>\n<pre class=\"command-line\">$ \/opt\/local\/lib\/mysql5\/bin\/mysql_secure_installation\n<\/pre>\n<p>\u3057\u304b\u3057\u3001\u5b9f\u884c\u3057\u3066\u307f\u305f\u304c\u3001\u533f\u540d\u30a2\u30ab\u30a6\u30f3\u30c8\u3082test\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3082\u6b8b\u3063\u3066\u3044\u305f\u306e\u3067\u3001<br \/>\n<a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/ja\/default-privileges.html\">MySQL :: MySQL 5.1 \u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u30de\u30cb\u30e5\u30a2\u30eb :: 2.10.3 \u6700\u521d\u306e MySQL \u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u78ba\u4fdd<\/a><br \/>\n\u3092\u53c2\u8003\u306b\u3001\u81ea\u5206\u3067\u3084\u308b\u3002<br \/>\nmysql\u30b3\u30de\u30f3\u30c9\u3084\u3001ruby\u306emysql\u30a2\u30c0\u30d7\u30bf\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\u304d\u306b\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u6307\u5b9a\u3059\u308bmysql-config\u3078\u306e\u30d1\u30b9\u3092\u901a\u3059\u305f\u3081\u3001.bash_profile\u306a\u3069\u3067$PATH\u306b<br \/>\n\/opt\/local\/lib\/mysql5\/bin<br \/>\n\u3092\u8ffd\u52a0\u3057\u3066\u304a\u304f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>$ sudo port install mysql5 +server ---> Fetching mysql5 ---> Verifying checksum(s) for mysql5 ---> Extracting  &hellip; <a href=\"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"","_original_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[34,13],"tags":[],"class_list":["post-653","post","type-post","status-publish","format-standard","hentry","category-mac","category-mysql","ja"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb - Pistolfly<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb - Pistolfly\" \/>\n<meta property=\"og:description\" content=\"$ sudo port install mysql5 +server ---&gt; Fetching mysql5 ---&gt; Verifying checksum(s) for mysql5 ---&gt; Extracting &hellip; \u7d9a\u304d\u3092\u8aad\u3080 MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html\" \/>\n<meta property=\"og:site_name\" content=\"Pistolfly\" \/>\n<meta property=\"article:published_time\" content=\"2008-09-02T03:30:55+00:00\" \/>\n<meta name=\"author\" content=\"Pistolfly\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pistolfly\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/2008\\\/09\\\/macportsmysql5.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/2008\\\/09\\\/macportsmysql5.html\"},\"author\":{\"name\":\"Pistolfly\",\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/#\\\/schema\\\/person\\\/e779e918730b507907b3a35b77a9a2ab\"},\"headline\":\"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\",\"datePublished\":\"2008-09-02T03:30:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/2008\\\/09\\\/macportsmysql5.html\"},\"wordCount\":21,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/#\\\/schema\\\/person\\\/e779e918730b507907b3a35b77a9a2ab\"},\"articleSection\":[\"Mac\",\"MySQL\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/2008\\\/09\\\/macportsmysql5.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/2008\\\/09\\\/macportsmysql5.html\",\"url\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/2008\\\/09\\\/macportsmysql5.html\",\"name\":\"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb - Pistolfly\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/#website\"},\"datePublished\":\"2008-09-02T03:30:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/2008\\\/09\\\/macportsmysql5.html#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/2008\\\/09\\\/macportsmysql5.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/2008\\\/09\\\/macportsmysql5.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/#website\",\"url\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/\",\"name\":\"Pistolfly\",\"description\":\"Developer Blog\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/#\\\/schema\\\/person\\\/e779e918730b507907b3a35b77a9a2ab\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/#\\\/schema\\\/person\\\/e779e918730b507907b3a35b77a9a2ab\",\"name\":\"Pistolfly\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0b3ddb2859adabf28a2b97ae9fff98772ddffc46088d11cad2b9a2cef66115e7?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0b3ddb2859adabf28a2b97ae9fff98772ddffc46088d11cad2b9a2cef66115e7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0b3ddb2859adabf28a2b97ae9fff98772ddffc46088d11cad2b9a2cef66115e7?s=96&d=mm&r=g\",\"caption\":\"Pistolfly\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0b3ddb2859adabf28a2b97ae9fff98772ddffc46088d11cad2b9a2cef66115e7?s=96&d=mm&r=g\"},\"description\":\"Software Engineer in Tokyo, Japan\",\"url\":\"https:\\\/\\\/www.pistolfly.com\\\/weblog\\\/author\\\/pistolfly\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb - Pistolfly","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html","og_locale":"ja_JP","og_type":"article","og_title":"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb - Pistolfly","og_description":"$ sudo port install mysql5 +server ---> Fetching mysql5 ---> Verifying checksum(s) for mysql5 ---> Extracting &hellip; \u7d9a\u304d\u3092\u8aad\u3080 MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb &rarr;","og_url":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html","og_site_name":"Pistolfly","article_published_time":"2008-09-02T03:30:55+00:00","author":"Pistolfly","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"Pistolfly","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"2\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html#article","isPartOf":{"@id":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html"},"author":{"name":"Pistolfly","@id":"https:\/\/www.pistolfly.com\/weblog\/#\/schema\/person\/e779e918730b507907b3a35b77a9a2ab"},"headline":"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb","datePublished":"2008-09-02T03:30:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html"},"wordCount":21,"commentCount":0,"publisher":{"@id":"https:\/\/www.pistolfly.com\/weblog\/#\/schema\/person\/e779e918730b507907b3a35b77a9a2ab"},"articleSection":["Mac","MySQL"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html","url":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html","name":"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb - Pistolfly","isPartOf":{"@id":"https:\/\/www.pistolfly.com\/weblog\/#website"},"datePublished":"2008-09-02T03:30:55+00:00","breadcrumb":{"@id":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pistolfly.com\/weblog\/2008\/09\/macportsmysql5.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/www.pistolfly.com\/weblog"},{"@type":"ListItem","position":2,"name":"MacPorts\u3067MySQL5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb"}]},{"@type":"WebSite","@id":"https:\/\/www.pistolfly.com\/weblog\/#website","url":"https:\/\/www.pistolfly.com\/weblog\/","name":"Pistolfly","description":"Developer Blog","publisher":{"@id":"https:\/\/www.pistolfly.com\/weblog\/#\/schema\/person\/e779e918730b507907b3a35b77a9a2ab"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pistolfly.com\/weblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/www.pistolfly.com\/weblog\/#\/schema\/person\/e779e918730b507907b3a35b77a9a2ab","name":"Pistolfly","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/0b3ddb2859adabf28a2b97ae9fff98772ddffc46088d11cad2b9a2cef66115e7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0b3ddb2859adabf28a2b97ae9fff98772ddffc46088d11cad2b9a2cef66115e7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b3ddb2859adabf28a2b97ae9fff98772ddffc46088d11cad2b9a2cef66115e7?s=96&d=mm&r=g","caption":"Pistolfly"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/0b3ddb2859adabf28a2b97ae9fff98772ddffc46088d11cad2b9a2cef66115e7?s=96&d=mm&r=g"},"description":"Software Engineer in Tokyo, Japan","url":"https:\/\/www.pistolfly.com\/weblog\/author\/pistolfly"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paorzz-ax","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.pistolfly.com\/weblog\/wp-json\/wp\/v2\/posts\/653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pistolfly.com\/weblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pistolfly.com\/weblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pistolfly.com\/weblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pistolfly.com\/weblog\/wp-json\/wp\/v2\/comments?post=653"}],"version-history":[{"count":0,"href":"https:\/\/www.pistolfly.com\/weblog\/wp-json\/wp\/v2\/posts\/653\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.pistolfly.com\/weblog\/wp-json\/wp\/v2\/media?parent=653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pistolfly.com\/weblog\/wp-json\/wp\/v2\/categories?post=653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pistolfly.com\/weblog\/wp-json\/wp\/v2\/tags?post=653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}