{"id":128,"date":"2008-10-27T00:29:15","date_gmt":"2008-10-26T15:29:15","guid":{"rendered":"http:\/\/www.asfit.net\/blog\/kan\/?p=128"},"modified":"2008-10-27T00:29:15","modified_gmt":"2008-10-26T15:29:15","slug":"mysql%e3%81%ae%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97","status":"publish","type":"post","link":"https:\/\/www.asfit.net\/blog\/kan\/?p=128","title":{"rendered":"mysql\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7"},"content":{"rendered":"<p>\u30e6\u30fc\u30b6\u30fc\u60c5\u5831\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u65b9\u6cd5\u306f\u5224\u3089\u305a\u3002\u30e6\u30fc\u30b6\u306e\u4f5c\u6210\u3068\u6a29\u9650\u306e\u4ed8\u4e0e\u306f\u624b\u52d5\u3067\u884c\u3063\u305f\u3002<br \/>\n\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<br \/>\nmysqldump -u root -pROOTPW DATABASE > database.sql<br \/>\n\u30ea\u30b9\u30c8\u30a2<br \/>\ncreate database HOGEHOGE;<br \/>\ncreate user USERNAME;<br \/>\ngrant all privileges on DATABASE.* to USERNAME@&#8221;localhost&#8221; identified by &#8216;USERPASSWD&#8217; ;<br \/>\nmysql -u root -pROOTPW DATABASE < database.sql\n\uff4d\uff59\uff53\uff51\uff4c\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3092UTF-8\u306b\u8a2d\u5b9a\n# vi \/etc\/mysql\/mysql.cnf\n...\n[mysqld]\n...\ndefault-character-set = utf8\nskip-character-set-client-handshake\n...\n\uff4d\uff59\uff53\uff51\uff4c\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u78ba\u8a8d\nmysql -u root -p\nmysql>status ;<br \/>\nmysql> status;<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\nmysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2<br \/>\nConnection id:          8991<br \/>\nCurrent database:<br \/>\nCurrent user:           root@localhost<br \/>\nSSL:                    Not in use<br \/>\nCurrent pager:          stdout<br \/>\nUsing outfile:          &#8221;<br \/>\nUsing delimiter:        ;<br \/>\nServer version:         5.0.51a-3ubuntu5.1-log (Ubuntu)<br \/>\nProtocol version:       10<br \/>\nConnection:             Localhost via UNIX socket<br \/>\nServer characterset:    utf8<br \/>\nDb     characterset:    utf8<br \/>\nClient characterset:    utf8<br \/>\nConn.  characterset:    utf8<br \/>\nUNIX socket:            \/var\/run\/mysqld\/mysqld.sock<br \/>\nUptime:                 34 days 18 hours 8 min 37 sec<br \/>\nThreads: 1  Questions: 234567  Slow queries: 0  Opens: 1334  Flush tables: 1  Open tables: 64  Queries per second avg: 0.078<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\nmysql><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30e6\u30fc\u30b6\u30fc\u60c5\u5831\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u65b9\u6cd5\u306f\u5224\u3089\u305a\u3002\u30e6\u30fc\u30b6\u306e\u4f5c\u6210\u3068\u6a29\u9650\u306e\u4ed8\u4e0e\u306f\u624b\u52d5\u3067\u884c\u3063\u305f\u3002 \u30d0\u30c3\u30af\u30a2\u30c3\u30d7 mysqldump -u root -pROOTPW DATABASE > database.sql \u30ea\u30b9\u30c8\u30a2 create&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/www.asfit.net\/blog\/kan\/index.php?rest_route=\/wp\/v2\/posts\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.asfit.net\/blog\/kan\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.asfit.net\/blog\/kan\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.asfit.net\/blog\/kan\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.asfit.net\/blog\/kan\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=128"}],"version-history":[{"count":0,"href":"https:\/\/www.asfit.net\/blog\/kan\/index.php?rest_route=\/wp\/v2\/posts\/128\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.asfit.net\/blog\/kan\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.asfit.net\/blog\/kan\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.asfit.net\/blog\/kan\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}