{"id":416,"date":"2010-10-22T21:46:51","date_gmt":"2010-10-22T12:46:51","guid":{"rendered":"http:\/\/wp.kaz.bz\/tech\/?p=416"},"modified":"2010-11-01T19:39:24","modified_gmt":"2010-11-01T10:39:24","slug":"%e5%88%a5%e3%81%aedb%e3%82%b5%e3%83%bc%e3%83%90%e3%81%ab%e3%81%82%e3%82%8b%e6%97%a2%e5%ad%98db%e3%81%ae%e7%ae%a1%e7%90%86%e3%82%92plesk%e3%81%a7%e3%82%84%e3%82%8b%e6%96%b9%e6%b3%95%e3%80%82","status":"publish","type":"post","link":"https:\/\/wp.kaz.bz\/tech\/2010\/10\/22\/416.html","title":{"rendered":"\u5225\u306eDB\u30b5\u30fc\u30d0\u306b\u3042\u308b\u65e2\u5b58DB\u306e\u7ba1\u7406\u3092Plesk\u3067\u3084\u308b\u65b9\u6cd5\u3002"},"content":{"rendered":"<p>Plesk\u306e\u78ba\u304b Ver.8 \u3042\u305f\u308a\u304b\u3089\u3001\u5225\u30b5\u30fc\u30d0\u306b\u3042\u308bDB\u3092\u7ba1\u7406\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u3002<\/p>\n<h4>\uff3bDB\u30b5\u30fc\u30d0\u5074\u306e\u8a2d\u5b9a\uff3d<\/h4>\n<p>DB\u63a5\u7d9a\u306e\u8a2d\u5b9a\u3092\u3057\u305f\u3044Plesk\u306e\u3042\u308b\u30b5\u30fc\u30d0\u306e\u30ed\u30fc\u30ab\u30ebIP\u30a2\u30c9\u30ec\u30b9\u304b\u3089DB\u30b5\u30fc\u30d0\u3078\u306e\u30a2\u30af\u30bb\u30b9\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u6a29\u9650\u8a2d\u5b9a\u3059\u308b\u3002<\/p>\n<pre class=\"brush:\">\r\n\u3053\u308c\u306f\u7279\u6b8a\u306a\u3053\u3068\u3067\u306f\u306a\u304f\u3001Web\u30fbDB\u30b5\u30fc\u30d0\u3092\u5225\u306e\u30b5\u30fc\u30d0\u3067\u3084\u308b\u5834\u5408\u3001\u666e\u901a\u306bMySQL\u306e\u8a2d\u5b9a\u3067\u3084\u3063\u3066\u3044\u308b\u3053\u3068\u3067\u3059\u3002\r\n<\/pre>\n<p>DB\u30b5\u30fc\u30d0\u3067\u4ee5\u4e0b\u306eSQL\u3092\u5b9f\u884c<\/p>\n<pre class=\"brush:sql\">\r\nGRANT ALL PRIVILEGES ON *.*\r\nTO '\u30e6\u30fc\u30b6'@'\u30db\u30b9\u30c8'\r\nIDENTIFIED BY '\u30d1\u30b9\u30ef\u30fc\u30c9'\r\nWITH GRANT OPTION;\r\n<\/pre>\n<p>\u30fb\u30e6\u30fc\u30b6\u306fPlesk\u306b\u8a2d\u5b9a\u3059\u308b\u30e6\u30fc\u30b6\uff08root \u3067\u3082\u3044\u3044\u304c\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30ec\u30d9\u30eb\u306f\u8003\u3048\u308b\u3053\u3068\uff09<br \/>\n\u30fb\u30db\u30b9\u30c8\u306fPlesk\u306e\u30ed\u30fc\u30ab\u30ebIP<\/p>\n<h4>\uff3bPlesk\u306e\u8a2d\u5b9a\uff3d<\/h4>\n<p>Plesk\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3001\u3010\u30b5\u30fc\u30d0\u3011\u2192\u3010\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u3011\u3042\u305f\u308a\u304b\u3089\u3001\u4e0a\u8a18\u3067\u8a2d\u5b9a\u3057\u305fDB\u30e6\u30fc\u30b6\u3067DB\u30b5\u30fc\u30d0\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3067\u3001\u5404\u30c9\u30e1\u30a4\u30f3\u306e\u7ba1\u7406\u30e1\u30cb\u30e5\u30fc\u306b\u3042\u308bDB\u4f5c\u6210\u304b\u3089DB\u304c\u4f5c\u308c\u308b\u3088\u3046\u306b\u306a\u308b\u3002<\/p>\n<p>\u3053\u306e\u8a2d\u5b9a\u5f8c\u304b\u3089\u3001\u65b0\u898f\u306bDB\u3092\u4f5c\u6210\u3059\u308b\u306e\u3067\u3042\u308c\u3070\u3053\u308c\u3067\u5b8c\u4e86\u3002<\/p>\n<pre class=\"brush:\">\r\n\u304c\u3001\u65e2\u5b58DB\u306f\u898b\u3048\u306a\u3044\u306e\u3067\u3069\u3046\u306b\u304b\u898b\u3048\u308b\u3088\u3046\u306b\u3059\u308b\u65b9\u6cd5\u306f\u4ee5\u4e0b\u3002\r\nSSH\u63a5\u7d9a\u306a\u3069\u3067Plesk\u30b5\u30fc\u30d0\u306eMySQL\u306eDB\u300cpsa\u300d\u306b\u63a5\u7d9a\u3001\u7de8\u96c6\u3067\u304d\u308b\u3053\u3068\u524d\u63d0\u3002\r\n\r\n\u2605\u975e\u63a8\u5968\uff1aPlesk\u306e\u7ba1\u7406DB\u81ea\u4f53\u3092\u624b\u52d5\u3067\u3044\u3058\u308a\u307e\u3059\u3002\u6574\u5408\u6027\u3092\u5d29\u3059\u6050\u308c\u304c\u3042\u308a\u307e\u3059\u3002\r\n<\/pre>\n<h4>\uff3bDB\u30b5\u30fc\u30d0\u4e0a\u306e\u65e2\u5b58DB\u3092\u7ba1\u7406\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u5834\u5408\uff3d<\/h4>\n<div style=\"padding:3px;margin:0px;border-width:1px;border-style: solid;border-color: #585858;\">\n\u3000\uff08\u524d\u63d0\uff1a\u6b63\u3057\u3044\u304b\u3069\u3046\u304b\u306f\u4e0d\u660e\u3060\u304c\u3001\u3069\u3046\u3084\u3089\u3053\u3046\u52d5\u3044\u3066\u3044\u308b\u3001\u3068\u3044\u3046\u30ec\u30d9\u30eb\uff09<\/p>\n<dl>\n<dt>psa<\/dt>\n<dd>Plesk\u81ea\u4f53\u306e\u7ba1\u7406\u7528DB\u540d<\/dd>\n<dt>DatabaseServers<\/dt>\n<dd>\u305d\u306ePlesk\u304b\u3089\u7ba1\u7406\u3067\u304d\u308bDB\u30b5\u30fc\u30d0\u306e\u7ba1\u7406\u30c6\u30fc\u30d6\u30eb<\/dd>\n<dt>db_users<\/dt>\n<dd>\u5404\u30c9\u30e1\u30a4\u30f3\u3067\u8a2d\u5b9a\u3057\u305fDB\u30e6\u30fc\u30b6\u306e\u7ba1\u7406\u30c6\u30fc\u30d6\u30eb<\/dd>\n<dt>data_bases<\/dt>\n<dd>\u5404\u30c9\u30e1\u30a4\u30f3\u3067\u8a2d\u5b9a\u3057\u305fDB\u306e\u7ba1\u7406\u30c6\u30fc\u30d6\u30eb<br \/>\n\uff08DB\u540d\u30fbDB\u30e6\u30fc\u30b6\u540d\u30fbDB\u30b5\u30fc\u30d0\u306e\u7d10\u3065\u3051\u304c\u884c\u308f\u308c\u3066\u3044\u308b\uff09<\/dd>\n<\/dl>\n<\/div>\n<ol>\n<li>Plesk\u4e0a\u306e\u30c9\u30e1\u30a4\u30f3\u304b\u3089\u30ed\u30fc\u30ab\u30eb\u306b\u30c0\u30df\u30fcDB\u3001\u30c0\u30df\u30fcDB\u30e6\u30fc\u30b6\u3092\u4f5c\u6210<\/li>\n<ul>\n<li>\u305d\u306e\u969b\u3001DB\u30b5\u30fc\u30d0\u306b\u3042\u308bDB\u7528\u306e\u30e6\u30fc\u30b6\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3067\u8a2d\u5b9a\u3057\u3066\u304a\u304f\u3068\u697d<\/li>\n<li>\u3053\u306e\u6642\u70b9\u3067\u30ed\u30fc\u30ab\u30eb\u30b5\u30fc\u30d0\u306eDB\u306b\u6307\u5b9a\u3057\u305fDB\u30fb\u30e6\u30fc\u30b6\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u4f5c\u696d\u5b8c\u4e86\u5f8c\u305d\u308c\u3089\u3092\u524a\u9664\u3059\u308b<\/li>\n<\/ul>\n<li>\u4ee5\u4e0bSSH\u3092\u5229\u7528\u3057\u3066 mysql \u3067\u63a5\u7d9a\u5f8c\u306e\u30a4\u30e1\u30fc\u30b8<\/li>\n<ol>\n<li>Plesk \u7ba1\u7406DB\u3078\u63a5\u7d9a<\/li>\n<pre class=\"brush:sql\">use psa<\/pre>\n<li>\u63a5\u7d9a\u5148\u306b\u306a\u308bDB\u30b5\u30fc\u30d0\u306eID\u3092\u78ba\u8a8d\uff08\u521d\u3081\u3066\u306a\u3089\u304a\u305d\u3089\u304f2\uff09<\/li>\n<pre class=\"brush:sql\">select * from DatabaseServers;<\/pre>\n<li>\u30c0\u30df\u30fc\u3067\u4f5c\u3063\u305f\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6ID\u3092\u78ba\u8a8d<\/li>\n<pre class=\"brush:sql\">select * db_users;<\/pre>\n<li>\u30c0\u30df\u30fc\u3067\u4f5c\u3063\u305f\u30e6\u30fc\u30b6\u3092\u6b63\u3057\u3044DB\u63a5\u7d9a\u30e6\u30fc\u30b6\u540d\u306b\u5909\u66f4<\/li>\n<pre class=\"brush:sql\">\r\nupdate db_users\r\nset name='\u6b63\u3057\u3044\u30e6\u30fc\u30b6\u540d'\r\nwhere id=\u4e0a\u3067\u78ba\u8a8d\u3057\u305f\u30c0\u30df\u30fc\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6ID;\r\n<\/pre>\n<li>\u30c0\u30df\u30fc\u3067\u4f5c\u3063\u305fDB\u306eID\u3092\u78ba\u8a8d\u3001\u63a5\u7d9a\u5148DB\u306e\u30b5\u30fc\u30d0ID\u304c\u3042\u308b\u306f\u305a<\/li>\n<pre class=\"brush:sql\">select * from data_bases;<\/pre>\n<li>\u30e6\u30fc\u30b6\u3068\u540c\u69d8\u306b\u3001DB\u540d\u30682.-2.\u3067\u78ba\u8a8d\u3057\u305f\u30b5\u30fc\u30d0ID\u3078\u66f4\u65b0<\/li>\n<li>1.\u3067Plesk\u4e0a\u304b\u3089\u4f5c\u6210\u3057\u305f\u30c0\u30df\u30fcDB\u3001\u30e6\u30fc\u30b6\u3092\u524a\u9664<\/li>\n<\/ol>\n<\/ol>\n<p>\u3067\u6271\u3048\u308b\u306f\u305a\u3067\u3059\u3002<br \/>\n\u7d30\u304b\u3044\u9593\u9055\u3044\u306f\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u5927\u304d\u306a\u6d41\u308c\u306f\u3053\u308c\u3067\u3042\u3063\u3066\u3044\u308b\u306f\u305a\u3002<br \/>\n\u3044\u3046\u307e\u3067\u3082\u306a\u304f\u7121\u4fdd\u8a3c\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plesk\u306e\u78ba\u304b Ver.8 \u3042\u305f\u308a\u304b\u3089\u3001\u5225\u30b5\u30fc\u30d0\u306b\u3042\u308bDB\u3092\u7ba1\u7406\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u3002 \uff3bDB\u30b5\u30fc\u30d0\u5074\u306e\u8a2d\u5b9a\uff3d DB\u63a5\u7d9a\u306e\u8a2d\u5b9a\u3092\u3057\u305f\u3044Plesk\u306e\u3042\u308b\u30b5\u30fc\u30d0\u306e\u30ed\u30fc\u30ab\u30ebIP\u30a2\u30c9\u30ec\u30b9\u304b\u3089DB\u30b5\u30fc\u30d0\u3078\u306e\u30a2\u30af\u30bb\u30b9\u304c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[34],"tags":[],"class_list":["post-416","post","type-post","status-publish","format-standard","hentry","category-plesk"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1725,"url":"https:\/\/wp.kaz.bz\/tech\/2013\/07\/26\/1725.html","url_meta":{"origin":416,"position":0},"title":"CentOS6\u7cfb\u3067SSH\u516c\u958b\u9375\u8a8d\u8a3c\u3092LDAP\u8a8d\u8a3c\u306b\u3059\u308b\u65b9\u6cd5\u3002","author":"kaz. Suenaga","date":"2013\/07\/26","format":false,"excerpt":"SSH\uff08CentOS\u6a19\u6e96\u30ea\u30dd\u30b8\u30c8\u30ea\u306eOpenSSH\uff09\u306e\u516c\u958b\u9375\u8a8d\u8a3c\u3067LDAP\u8a8d\u8a3c\u3092\u5229\u7528\u3059\u308b\u624b\u9806\u3067\u3059\u3002 \u2026","rel":"","context":"CentOS","block_context":{"text":"CentOS","link":"https:\/\/wp.kaz.bz\/tech\/category\/lin\/centos"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":82,"url":"https:\/\/wp.kaz.bz\/tech\/2006\/09\/26\/82.html","url_meta":{"origin":416,"position":1},"title":"RDF\/RSS1\/ATOM\u306e\u6b63\u5e38\u8868\u793a\u3002\u305d\u306e\u5f8c\u3002","author":"kaz. Suenaga","date":"2006\/09\/26","format":false,"excerpt":"http:\/\/hibi.hamazo.tv\/e65829.html [1] \u554f\u984c\u306f\u3068\u3066\u3082\u5965\u6df1\u3044\u3088\u3046\u3060\u2026","rel":"","context":"WordPress","block_context":{"text":"WordPress","link":"https:\/\/wp.kaz.bz\/tech\/category\/web\/wordpress"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1755,"url":"https:\/\/wp.kaz.bz\/tech\/2013\/08\/31\/1755.html","url_meta":{"origin":416,"position":2},"title":"\u67d0\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u3067\u306e\u5927\u898f\u6a21\u6539\u3056\u3093\u3067\u8d77\u3053\u3063\u3066\u3044\u305f\uff08\u3068\u63a8\u6e2c\u3055\u308c\u308b\uff09\u72b6\u614b\u306e\u6574\u7406\u3002","author":"kaz. Suenaga","date":"2013\/08\/31","format":false,"excerpt":"2013\/08\/31 01:36 \u521d\u7248 2013\/08\/31 10:00 \u53c2\u8003\u30ea\u30f3\u30af\u8ffd\u52a0 2013\/\u2026","rel":"","context":"\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8","block_context":{"text":"\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8","link":"https:\/\/wp.kaz.bz\/tech\/category\/internet"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14,"url":"https:\/\/wp.kaz.bz\/tech\/2009\/06\/01\/14.html","url_meta":{"origin":416,"position":3},"title":"www. \u3067\u59cb\u307e\u308b\u30b5\u30fc\u30d0\u3067\u30b5\u30d6\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u65b0\u898f\u30d6\u30ed\u30b0\u3092\u4f5c\u6210\u3059\u308b\u5834\u5408\u3002","author":"kaz. Suenaga","date":"2009\/06\/01","format":false,"excerpt":"\u3053\u308c\u3067\u5168\u3066\u304b\u306f\u308f\u304b\u308a\u307e\u305b\u3093\u304c\u3001\u898b\u3064\u3051\u305f\u3082\u306e\u3092\u66f8\u3044\u3066\u3044\u304d\u307e\u3059\u3002 \u30fb[wp-config.php] \u4e0b\u8a18\u2026","rel":"","context":"WordPressMU","block_context":{"text":"WordPressMU","link":"https:\/\/wp.kaz.bz\/tech\/category\/web\/wordpress\/wordpressmu"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":59,"url":"https:\/\/wp.kaz.bz\/tech\/2007\/07\/02\/59.html","url_meta":{"origin":416,"position":4},"title":"pg_dump\u306a\u3069\u3067\u81ea\u52d5\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a","author":"kaz. Suenaga","date":"2007\/07\/02","format":false,"excerpt":"http:\/\/www.postgresql.jp\/document\/current\/html\/lib\u2026","rel":"","context":"PostgreSQL","block_context":{"text":"PostgreSQL","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/db\/postgresql"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1703,"url":"https:\/\/wp.kaz.bz\/tech\/2013\/07\/03\/1703.html","url_meta":{"origin":416,"position":5},"title":"OpenSSH\u3067\u306e\u516c\u958b\u9375\u8a8d\u8a3c\u3002","author":"kaz. Suenaga","date":"2013\/07\/03","format":false,"excerpt":"SSH\u30ed\u30b0\u30a4\u30f3\u6642\u306e\u8a8d\u8a3c\u65b9\u5f0f\uff08\u30d1\u30b9\u30ef\u30fc\u30c9\u8a8d\u8a3c\u30fb\u516c\u958b\u9375\u8a8d\u8a3c\uff09\u306b\u3064\u3044\u3066\u306e\u8003\u5bdf\u3067\u3059\u3002 \u516c\u958b\u9375\u6697\u53f7 \u516c\u958b\u9375\u8a8d\u8a3c\u2026","rel":"","context":"OpenSSH","block_context":{"text":"OpenSSH","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/openssh"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/comments?post=416"}],"version-history":[{"count":0,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/416\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/media?parent=416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/categories?post=416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/tags?post=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}