{"id":1924,"date":"2017-04-10T17:21:38","date_gmt":"2017-04-10T08:21:38","guid":{"rendered":"http:\/\/bton.papalabs.net\/?p=1924"},"modified":"2017-05-11T12:17:38","modified_gmt":"2017-05-11T03:17:38","slug":"ubuntu16-04%e3%81%abnginxmysql%e3%81%a7%e4%bd%9c%e6%88%90%e3%81%97%e3%81%9f%e3%83%90%e3%83%bc%e3%83%81%e3%83%a3%e3%83%ab%e3%83%9b%e3%82%b9%e3%83%88%e3%81%ab%e3%80%81phpmyadmin%e3%82%92%e3%82%a4","status":"publish","type":"post","link":"https:\/\/bton.papalabs.net\/?p=1924","title":{"rendered":"ubuntu16.04\u306bNGINX+mySQL\u3067\u4f5c\u6210\u3057\u305f\u30d0\u30fc\u30c1\u30e3\u30eb\u30db\u30b9\u30c8\u306b\u3001PhpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b"},"content":{"rendered":"

phpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n

phpMyAdmin\u306f\u3001\u5148\u306bconoha\u306eDNS\u3067\u8ffd\u52a0\u3057\u3066\u304a\u3044\u305f\u3001https:\/\/phpmyadmin.exmple.com\u3067SSL\u63a5\u7d9a\u3059\u308b\u524d\u63d0\u3067\u3059\u3002<\/p>\n

\u305d\u308c\u3067\u306f\u3084\u3063\u3066\u3044\u304d\u307e\u3057\u3087\u3046\uff01<\/p>\n

\u6700\u521d\u306bAjenti\u306e\u7ba1\u7406\u30d1\u30cd\u30eb\u306e\u300c\u30d1\u30c3\u30b1\u30fc\u30b8\u300d\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u3001’php-mbstring’\u3092\u691c\u7d22\u3057\u3001’\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\/\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u7528\u30de\u30fc\u30af’\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3001\u5de6\u4e0a\u306e\u300c\u9069\u7528\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\uff08\u203b\u540c\u6642\u306b\u3001php7.0-mbstring\u3082\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u307e\u3059\u3002\uff09
\n\"\"<\/a><\/p>\n

\u30bf\u30fc\u30df\u30ca\u30eb\u304b\u3089\u540c\u3058\u3053\u3068\u3092\u884c\u3046\u5834\u5408\u306f\u3001<\/p>\n

\r\n
apt-get -y install php-mbstring\r\n<\/span><\/p>\r\n<\/pre>\n
\u3068\u6253\u3061\u8fbc\u307f\u307e\u3059\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u305f\u304b\u3069\u3046\u304b\u3001<\/p>\n
\r\n
php -m | egrep 'mbstring'<\/span><\/p>\r\n<\/pre>\n
\u3068\u6253\u3061\u8fbc\u3093\u3067\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002
\n‘mbstring’\u3068\u8fd4\u3055\u308c\u3066\u304f\u308c\u3070OK\u3067\u3059\u3002<\/p>\n
\u6b21\u306b\u3001phpmyadmin.exmple.com\u306e\u30d0\u30fc\u30c1\u30e3\u30eb\u30db\u30b9\u30c8\u3067\u3001php\u304c\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3001fastCGI\u3092\u6709\u52b9\u306b\u3057\u307e\u3059\u3002<\/p>\n
Ajenti\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u305f\u3089\u3001\u300cWEB\u30b5\u30a4\u30c8\u300d\u30e1\u30cb\u30e5\u30fc\u3088\u308a\u3001phpmyadmin.exmple.com\u306e\u7ba1\u7406\u753b\u9762\u306b\u5165\u308a\u3001\u300cContent\u300d\u30bf\u30d6\u306e’PHP 7.0 Fast CGI’\u3092\u4f5c\u6210\u8ffd\u52a0\u3057\u307e\u3059\u3002
\n\u203b\u624b\u9806\u306f\u3001\u524d\u56de\u307e\u3067\u306e\u8a18\u4e8b\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002Ajenti\u304b\u3089\u8a2d\u5b9a\u3057\u305f\u5834\u5408\u3001config\u30d5\u30a1\u30a4\u30eb\u3078\u306e\u7d30\u304b\u306a\u8ffd\u8a18\u306fAjenti\u304c\u884c\u306a\u3063\u3066\u304f\u308c\u308b\u306e\u3067\u3001\u57fa\u672c\u3053\u308c\u3060\u3051\u3067\u5927\u4e08\u592b\u3067\u3059\u3002<\/p>\n
\u3053\u308c\u3067\u3001php\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n
\u6b21\u306b\u3001\u516c\u5f0f\u30b5\u30a4\u30c8\u3088\u308aphpMyAdmin\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u3001phpmyadmin.exmple.com\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u30eb\u30fc\u30c8\u306b\u89e3\u51cd\u5c55\u958b\u3057\u307e\u3059\u3002
\n\u540c\u3058\u300cWEB\u30b5\u30a4\u30c8\u300d\u30e1\u30cb\u30e5\u30fc\u306e\u300c\u4e00\u822c\u8a2d\u5b9a\u300d\u30bf\u30d6\u306b\u4e0b\u8a18\u306eURL\u3092\u6253\u3061\u8fbc\u307f\u3001<\/p>\n
https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.7.0\/phpMyAdmin-4.7.0-all-languages.zip<\/pre>\n
\u300cDOWNLOAD AND UNPACK\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002
\n\/var\/www\/phpmyadmin.example.com\/html\/\u306e\u4e2d\u306b\u3001’\u00a0phpMyAdmin-4.7.0-all-languages’\u3068\u3044\u3046\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304c\u4f5c\u6210\u3055\u308c\u3001\u305d\u306e\u4e2d\u306b\u3001\u30d5\u30a1\u30a4\u30eb\u4e00\u5f0f\u304c\u5165\u308a\u307e\u3059\u3002<\/p>\n
\u305d\u306e\u4e2d\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u5168\u3066\u30011\u968e\u5c64\u4e0a\u306e\/html\/\u306b\u79fb\u52d5\u3055\u305b\u307e\u3059\u3002
\nAjenti\u306e\u300c\u30d5\u30a1\u30a4\u30eb\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u300d\u30e1\u30cb\u30e5\u30fc\u3067\u3001
\n\/var\/www\/phpmyadmin.example.com\/html\/phpMyAdmin-4.7.0-all-languages\/\u306b\u79fb\u52d5\u3057\u3001\u4e2d\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u5168\u3066\u9078\u629e\u3057\u3001\u753b\u9762\u4e0a\u306e\u3001\u300c\u5207\u308a\u53d6\u308a\u300d\uff08\u30cf\u30b5\u30df\u306e\u30de\u30fc\u30af\uff09\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3002\/html\/\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u79fb\u52d5\u3057\u3001\u300c\u8cbc\u308a\u4ed8\u3051\u300d\uff08\u30af\u30ea\u30c3\u30d7\u30dc\u30fc\u30c9\u306e\u30de\u30fc\u30af\uff09\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u540c\u3058\u52d5\u4f5c\u3067\u3001\/phpMyAdmin-4.7.0-all-languages\/\u304b\u3089\/html\/\u3078\u5168\u3066\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u300c\u5207\u308a\u53d6\u308a\u300d\u300c\u8cbc\u308a\u4ed8\u3051\u300d\u3092\u7e70\u308a\u8fd4\u3057\u3066\u79fb\u52d5\u3057\u307e\u3059\u3002\u5168\u3066\u7d42\u308f\u3063\u305f\u3089\u3001\u30af\u30ea\u30c3\u30d7\u30dc\u30fc\u30c9\u306f’empty’\u306b\u3057\u3066\u3001\u4e2d\u8eab\u304c\u7a7a\u3063\u307d\u306b\u306a\u3063\u305f\/phpMyAdmin-4.7.0-all-languages\/\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3082\u524a\u9664\u3057\u307e\u3059\u3002<\/p>\n
\u30bf\u30fc\u30df\u30ca\u30eb\u304b\u3089\u540c\u3058\u3053\u3068\u3092\u884c\u3046\u5834\u5408\u306f\u3001\u4e0b\u8a18\u3067\u3059\u3002<\/p>\n
#\/var\/www\/phpmyadmin.example.com\/html\/\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3078\u79fb\u52d5\u3059\u308b<\/span>\u3002\r\ncd\u00a0\/var\/www\/phpmyadmin.example.com\/html\/\r\n\r\n#phpMyAdmin\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3002<\/span>\r\ncurl https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.7.0\/phpMyAdmin-4.7.0-all-languages.tar.gz | tar zx -C \/var\/www\/phpmyadmin.papalabs.xyz\/html<\/span>\r\n
#\u4e2d\u8eab\u3092\uff11\u3064\u4e0a\u306e\/html\/\u76f4\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u79fb\u52d5\u3059\u308b\u3002<\/span>\r\nmv \/var\/www\/phpmyadmin.papalabs.xyz\/html\/phpMyAdmin-4.7.0-all-languages\/* \/var\/www\/phpmyadmin.papalabs.xyz\/html<\/span><\/p>\r\n
#\u7a7a\u306b\u306a\u3063\u305f\u3001phpMyAdmin\u306e\u30d5\u30a9\u30eb\u30c0\u3092\u524a\u9664\u3059\u308b\u3002<\/span>\r\nrm -rf phpMyAdmin-4.7.0-all-languages<\/span><\/p>\r\n<\/pre>\n
\u4ee5\u4e0a\u3067\u3059\u3002<\/p>\n
\u30d6\u30e9\u30a6\u30b6\u304b\u3089\u3001https:\/\/phpmyadmin.example.com\u3078\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001phpMyAdmin\u306e\u7ba1\u7406\u753b\u9762\u3078\u306e\u30ed\u30b0\u30a4\u30f3\u30da\u30fc\u30b8\u304c\u958b\u304d\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
\u4eca\u56de\u3001phpMyAdmin\u306f\u3001\u30b5\u30fc\u30d0\u30fc\u5168\u4f53\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u307e\u3059\uff08\u3068\u3044\u3046\u304bmySQL\u304c\uff11\u3064\u306e\u30b5\u30fc\u30d0\u30fc\u3068\u3057\u3066VPS\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u304a\u308a\u3001phpMyAdmin\u306f\u3001\u305d\u306eDB\u3078\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3044\u304f\uff09\u306e\u3067\u3001\u5404WEB\u30b5\u30a4\u30c8\u3067DB\u3092\u4f5c\u6210\u3059\u308b\u3068\u3001\u4f5c\u6210\u3057\u305fDB\u306e\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u3067\u305d\u306eDB\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u3059\u3002<\/p>\n
Ajenti\u306e\u300cWEB\u30b5\u30a4\u30c8\u300d\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u3001DB\u3092\u4f5c\u6210\u3057\u305f\u3044\u30b5\u30a4\u30c8\u306e\u7ba1\u7406\u753b\u9762\u3092\u958b\u304d\u307e\u3059\u3002
\n\u300cMySQL\u300d\u30bf\u30d6\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001DB\u540d\u3092\u5165\u529b\u3057\u3066\u3001DB\u3092\u4f5c\u6210\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066\u3001DB\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u4e0b\u306e\u300cAPPLY CHANGES\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u78ba\u5b9a\u3057\u307e\u3059\u3002
\n\u3053\u3053\u3067\u4f5c\u6210\u3057\u305f\u3001DB\u3068\u30e6\u30fc\u30b6\u30fc\u306f\u3001\u300c\u30bd\u30d5\u30c8\u30a6\u30a8\u30a2\u300d\u306e[MySQL\u300d\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u3082\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n
\u4f5c\u6210\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u3067phpMyAdmin\u306b\u30ed\u30b0\u30a4\u30f3\u3059\u308c\u3070\u3001phpMyAdmin\u7d4c\u7531\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7ba1\u7406\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n
\u4f5c\u6210\u3057\u305fDB\u3092\u524a\u9664\u3057\u305f\u3044\u5834\u5408\u3001Ajenti\u306e\u7ba1\u7406\u753b\u9762\u304b\u3089\u306f\u3001\uff12\u3064\u306e\u64cd\u4f5c\u304c\u5fc5\u8981\u3067\u3059\u3002
\n\u300cWEB\u30b5\u30a4\u30c8\u300d\u30e1\u30cb\u30e5\u30fc\u306e\u300cMySQL\u300d\u30bf\u30d6\u304b\u3089\u3001DB\u3068\u30e6\u30fc\u30b6\u30fc\u3092\u524a\u9664\u3057\u3001\u300cAPPLY CHANGES\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u78ba\u5b9a\u3057\u307e\u3059\u3002\uff1d\uff1e\u3053\u308c\u3067\u3001\u30a6\u30a7B\u30b5\u30fc\u30d0\u30fc\u306econfig\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u8a72\u5f53\u3059\u308b\u8a2d\u5b9a\u304c\u524a\u9664\u3055\u308c\u307e\u3059\u3002
\n\u3055\u3089\u306b\u3001\u300c\u30bd\u30d5\u30c8\u30a6\u30a8\u30a2\u300d\u306e[MySQL\u300d\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u3082DB\u3068\u30e6\u30fc\u30b6\u30fc\u3092\u524a\u9664\u3057\u307e\u3059\u3002<\/p>\n
\u203b\u500b\u4eba\u7684\u306b\u306f\u3001\u672c\u6765\u3001\u300cWEB\u30b5\u30a4\u30c8\u300d\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u306e\u64cd\u4f5c\u3060\u3051\u3067\u3001\u8ffd\u52a0\u3084\u524a\u9664\u304c\u3067\u304d\u3066\u3044\u308b\u3079\u304d\u3060\u3068\u601d\u3046\u306e\u3067\u3059\u304c\u3001\u8a66\u3057\u3066\u307f\u305f\u3068\u3053\u308d\u3001\u305d\u308c\u3060\u3051\u3067\u306f\u30c7\u30fc\u30bf\u304c\u6b8b\u3063\u3066\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u3001\u3069\u3061\u3089\u306e\u64cd\u4f5c\u3082\u884c\u306a\u3063\u3066\u304a\u304f\u65b9\u304c\u826f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/span><\/p>\n
\uff1c\u3084\u308b\u3053\u3068\u4e00\u89a7\uff1e<\/p>\n