{"id":2221,"date":"2015-09-09T02:25:02","date_gmt":"2015-09-08T17:25:02","guid":{"rendered":"http:\/\/tech.akat.info\/?p=2221"},"modified":"2015-09-09T02:26:29","modified_gmt":"2015-09-08T17:26:29","slug":"phpmyadmin%e3%81%a7%e8%a4%87%e6%95%b0db%e3%82%92%e7%ae%a1%e7%90%86%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/tech.akat.info\/?p=2221","title":{"rendered":"phpmyadmin\u3067\u8907\u6570DB\u3092\u7ba1\u7406\u3059\u308b"},"content":{"rendered":"

\"2015-09-09_022430\"<\/a><\/p>\n

config.inc.php\u306b[Second server]\u4ee5\u4e0b\u306e\u5185\u5bb9\u3092\u8ffd\u8a18\u3059\u308b
\nconfig.inc.php\u306b\u3064\u3044\u3066\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u3088\u3063\u3066\u30d5\u30a1\u30a4\u30eb\u306e\u3042\u308b\u5834\u6240\u304c\u9055\u3046\u305f\u3081\u6ce8\u610f<\/p>\n

\r\n### Second server \u3092\u8ffd\u52a0\u3057\u305f ###\r\nroot@hostname:\/home\/shimizu# vi \/etc\/phpmyadmin\/config.inc.php\r\n...\r\n\/* Configure according to dbconfig-common if enabled *\/\r\nif (!empty($dbname)) {\r\n    \/* Authentication type *\/\r\n    $cfg['Servers'][$i]['auth_type'] = 'cookie';\r\n    \/* Server parameters *\/\r\n    if (empty($dbserver)) $dbserver = 'localhost';\r\n    $cfg['Servers'][$i]['host'] = $dbserver;\r\n\r\n    if (!empty($dbport) || $dbserver != 'localhost') {\r\n        $cfg['Servers'][$i]['connect_type'] = 'tcp';\r\n        $cfg['Servers'][$i]['port'] = $dbport;\r\n    }\r\n    \/\/$cfg['Servers'][$i]['compress'] = false;\r\n    \/* Select mysqli if your server has it *\/\r\n    $cfg['Servers'][$i]['extension'] = 'mysqli';\r\n    \/* Optional: User for advanced features *\/\r\n    $cfg['Servers'][$i]['controluser'] = $dbuser;\r\n    $cfg['Servers'][$i]['controlpass'] = $dbpass;\r\n    \/* Optional: Advanced phpMyAdmin features *\/\r\n    $cfg['Servers'][$i]['pmadb'] = $dbname;\r\n    $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';\r\n    $cfg['Servers'][$i]['relation'] = 'pma__relation';\r\n    $cfg['Servers'][$i]['table_info'] = 'pma__table_info';\r\n    $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';\r\n    $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';\r\n    $cfg['Servers'][$i]['column_info'] = 'pma__column_info';\r\n    $cfg['Servers'][$i]['history'] = 'pma__history';\r\n    $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';\r\n    $cfg['Servers'][$i]['tracking'] = 'pma__tracking';\r\n    $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';\r\n    $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';\r\n    $cfg['Servers'][$i]['recent'] = 'pma__recent';\r\n    $cfg['Servers'][$i]['favorite'] = 'pma__favorite';\r\n    $cfg['Servers'][$i]['users'] = 'pma__users';\r\n    $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';\r\n    $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';\r\n    $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';\r\n\r\n    \/* Uncomment the following to enable logging in to passwordless accounts,\r\n     * after taking note of the associated security risks. *\/\r\n    \/\/ $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;\r\n\r\n    \/* Advance to next server for rest of config *\/\r\n    $i++;\r\n}\r\n\r\n\/*\r\n *  *  * Second server\r\n *\/\r\n\/* Authentication type *\/\r\n$cfg['Servers'][$i]['auth_type'] = 'cookie';\r\n\/* Server parameters *\/\r\n$cfg['Servers'][$i]['host'] = '104.155.205.9';\r\n$cfg['Servers'][$i]['connect_type'] = 'tcp';\r\n$cfg['Servers'][$i]['compress'] = false;\r\n$cfg['Servers'][$i]['AllowNoPassword'] = false;\r\n...\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
config.inc.php\u306b[Second server]\u4ee5\u4e0b\u306e\u5185\u5bb9\u3092\u8ffd\u8a18\u3059\u308b config.inc.php\u306b\u3064\u3044\u3066\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u3088\u3063\u3066\u30d5\u30a1\u30a4\u30eb\u306e\u3042\u308b\u5834\u6240\u304c\u9055\u3046\u305f\u3081\u6ce8\u610f ### Second server \u3092\u8ffd\u52a0\u3057\u305f  […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[25],"tags":[],"_links":{"self":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/2221"}],"collection":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2221"}],"version-history":[{"count":4,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/2221\/revisions"}],"predecessor-version":[{"id":2226,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/2221\/revisions\/2226"}],"wp:attachment":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}