{"id":1825,"date":"2018-05-15T10:39:30","date_gmt":"2018-05-15T01:39:30","guid":{"rendered":"https:\/\/lovelinux.mydns.jp\/?p=1825"},"modified":"2018-05-17T01:06:25","modified_gmt":"2018-05-16T16:06:25","slug":"ubuntu-18-04-%e3%81%ab-nginx-mysql-php-phpmyadmin%e7%92%b0%e5%a2%83%e3%82%92%e6%95%b4%e3%81%88%e3%82%8b","status":"publish","type":"post","link":"https:\/\/lovelinux.mydns.jp\/?p=1825","title":{"rendered":"Ubuntu 18.04 \u306b nginx mysql php phpmyadmin\u74b0\u5883\u3092\u6574\u3048\u308b"},"content":{"rendered":"

Ubuntu 18.04\u306bnginx mysql php phpmyadmin\u306e\u74b0\u5883\u3092\u6574\u3048\u307e\u3059\u3002
\nmysql\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\u306b\u82e5\u5e72\u82e6\u52b4\u3057\u307e\u3057\u305f\u306e\u3067\u305d\u306e\u6642\u306e\u30e1\u30e2\u3067\u3059\u3002<\/p>\n

nginx\u3001mysql\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n

[bash]
\n$ sudo apt-get install nginx mysql-server
\n[\/bash]<\/p>\n

nginx\u306e\u8d77\u52d5\u78ba\u8a8d<\/h3>\n

[bash]
\n$ sudo systemctl start nginx
\n[\/bash]<\/p>\n

\u30d6\u30e9\u30a6\u30b6\u30fc\u3067 http:\/\/localhost\u3000\u3068\u3057\u3066nginx\u306e\u30c8\u30c3\u30d7\u30da\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n

php\u3001php-fpm\u306a\u3069\u306a\u3069\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n

[bash]
\n$ sudo apt-get install php php-fpm php-mysql php-gettext php-common php-mbstring php-mbstring
\n[\/bash]<\/p>\n

\u3053\u306e\u30bf\u30a4\u30df\u30f3\u30b0\u3067nginx\u306eindex.html \u304capache\u30e9\u30a4\u30af\u306a\u3082\u306e\u306b\u66f8\u304d\u63db\u3048\u3089\u308c\u308b\u3063\u307d\u3044\u304c\u3001\u6c17\u306b\u3057\u306a\u3044\uff08\u7b11\uff09<\/p>\n

php.ini\u8abf\u6574<\/h3>\n

[bash]
\n$ sudo nano \/etc\/php\/7.2\/fpm\/php.ini
\n[\/bash]<\/p>\n

\u4ee5\u4e0b\u306e\u90e8\u5206\u3092\u8abf\u6574\u3057\u307e\u3059\u3002
\n[diff]
\n+ cgi.fix_pathinfo=0
\n[\/diff]<\/p>\n

nginx\u3000php\u9023\u643a<\/h3>\n

\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u8abf\u6574<\/h4>\n

[bash]
\n$ sudo nano \/etc\/nginx\/sites-available\/default
\n[\/bash]<\/p>\n

\u4ee5\u4e0b\u3092\u8ffd\u8a18\u3057\u307e\u3059\u3002<\/p>\n

[bash]
\n location ~ \\.php$ {
\n try_files $uri =404;
\n fastcgi_pass unix:\/var\/run\/php\/php7.2-fpm.sock;
\n fastcgi_index index.php;
\n fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
\n include fastcgi_params;
\n }
\n[\/bash]<\/p>\n

\u30c6\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210<\/h4>\n

[bash]
\n$ sudo nano \/var\/www\/html\/test.php
\n[\/bash]<\/p>\n

\u4ee5\u4e0b\u306e\uff11\u884c\u3092\u8a18\u8ff0\u3057\u3066\u304f\u3060\u3055\u3044\u3002
\n[bash]
\n
\n[\/bash]<\/p>\n

nginx\u518d\u8d77\u52d5<\/h4>\n

[bash]
\n$ sudo systemctl restart nginx
\n[\/bash]<\/p>\n

\u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u52d5\u4f5c\u78ba\u8a8d<\/h4>\n

http:\/\/localhost\/test.php \u3078\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8868\u793a\u304c\u3055\u308c\u308c\u3070OK
\n\"phptest\"<\/a><\/p>\n

phpmyadmin\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n

https:\/\/www.phpmyadmin.net\/<\/a>\u3088\u308a\u6700\u65b0\u7248\u3092\u5165\u624b\u3002<\/p>\n

\u89e3\u51cd\u3057\u3066 \/usr\/share\u3078\u30b3\u30d4\u30fc<\/h4>\n

[bash]
\n$ unzip phpMyAdmin-4.8.0-all-languages.zip
\n$ mv phpMyAdmin-4.8.0-all-languages phpmyadmin
\n$ sudo mv phpmyadmin\/ \/usr\/share\/
\n[\/bash]<\/p>\n

\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u8abf\u6574<\/h4>\n

[bash]
\n$ sudo nano \/etc\/nginx\/sites-available\/default
\n[\/bash]<\/p>\n

\u4ee5\u4e0b\u3092\u8ffd\u8a18
\n[bash]
\n location \/phpmyadmin {
\n root \/usr\/share;
\n index index.php;<\/p>\n

location ~ ^\/phpmyadmin.+\\.php$ {
\n fastcgi_pass unix:\/var\/run\/php\/php7.2-fpm.sock;
\n fastcgi_index index.php;
\n fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
\n include fastcgi_params;
\n }<\/p>\n

}
\n[\/bash]<\/p>\n

nginx\u518d\u8d77\u52d5<\/h4>\n

[bash]
\n$ sudo systemctl stop nginx
\n$ sudo systemctl start nginx
\n[\/bash]<\/p>\n

\u52d5\u4f5c\u78ba\u8a8d<\/h4>\n

http:\/\/localhost\/phpmyadmin \u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8868\u793a\u306b\u306a\u308c\u3070\u6210\u529f
\n\"phptest2\"<\/a><\/p>\n

Mysql root\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u8a2d\u5b9a<\/h4>\n

\u4ee5\u524d\u306e\u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30b7\u30e7\u30f3\u3060\u3068 mysql\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u3001root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5c0b\u306d\u308b\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u51fa\u3066\u304d\u3066\u3001\u305d\u3053\u3067root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3067\u304d\u305f\u306e\u3067\u3059\u304c\u300118.04\u3067\u306f\u306a\u305c\u304b\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u4ee5\u4e0b\u3067\u8abf\u6574\u3002<\/p>\n

[bash]
\n$ sudo mysql -u root
\nmysql> USE mysql
\nmysql> UPDATE user SET plugin=’mysql_native_password’ WHERE User=’root’;
\nmysql> FLUSH PRIVILEGES;
\nmysql> exit;<\/p>\n

[\/bash]<\/p>\n

[bash]
\n$ mysql -u root
\nmysql> SET PASSWORD FOR root@’localhost’ = PASSWORD(‘xxxxxxxx’);
\nmysql> exit;<\/p>\n

[\/bash]<\/p>\n","protected":false},"excerpt":{"rendered":"

Ubuntu 18.04\u306bnginx mysql php phpmyadmin\u306e\u74b0\u5883\u3092\u6574\u3048\u307e\u3059\u3002 mysql\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\u306b\u82e5\u5e72\u82e6\u52b4\u3057\u307e\u3057\u305f\u306e\u3067\u305d\u306e\u6642\u306e\u30e1\u30e2\u3067\u3059\u3002 nginx\u3001mysql\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb [bash] $ sudo apt-get install nginx mysql-server [\/bash] nginx\u306e\u8d77\u52d5\u78ba\u8a8d [bash] $ sudo systemctl start nginx [\/bash] \u30d6\u30e9\u30a6\u30b6\u30fc\u3067 http:\/\/localhost\u3000\u3068\u3057\u3066nginx\u306e\u30c8\u30c3\u30d7\u30da\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002 php\u3001php-fpm\u306a\u3069\u306a\u3069\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb [bash] $ sudo apt-get install php php-fpm php-mysql php-gettext php-common php-mbstring php-mbstring [\/bash] \u3053\u306e\u30bf\u30a4\u30df\u30f3\u30b0\u3067nginx\u306eindex.html \u304capache\u30e9\u30a4\u30af\u306a\u3082\u306e\u306b\u66f8\u304d\u63db\u3048\u3089\u308c\u308b\u3063\u307d\u3044\u304c\u3001\u6c17\u306b\u3057\u306a\u3044\uff08\u7b11\uff09 php.ini\u8abf\u6574 [bash] $ sudo nano \/etc\/php\/7.2\/fpm\/php.ini [\/bash] \u4ee5\u4e0b\u306e\u90e8\u5206\u3092\u8abf\u6574\u3057\u307e\u3059\u3002 [diff] + cgi.fix_pathinfo=0 [\/diff] nginx\u3000php\u9023\u643a \u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u8abf\u6574 [bash] $ sudo nano \/etc\/nginx\/sites-available\/default [\/bash] \u4ee5\u4e0b\u3092\u8ffd\u8a18\u3057\u307e\u3059\u3002 [bash] location ~ \\.php$ { try_files $uri =404; fastcgi_pass unix:\/var\/run\/php\/php7.2-fpm.sock; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params; } [\/bash] \u30c6\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210 [bash] $ sudo nano \/var\/www\/html\/test.php [\/bash] \u4ee5\u4e0b\u306e\uff11\u884c\u3092\u8a18\u8ff0\u3057\u3066\u304f\u3060\u3055\u3044\u3002 [bash] [\/bash] nginx\u518d\u8d77\u52d5 [bash] $ sudo systemctl restart nginx [\/bash] \u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u52d5\u4f5c\u78ba\u8a8d http:\/\/localhost\/test.php \u3078\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8868\u793a\u304c\u3055\u308c\u308c\u3070OK phpmyadmin\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb https:\/\/www.phpmyadmin.net\/\u3088\u308a\u6700\u65b0\u7248\u3092\u5165\u624b\u3002 \u89e3\u51cd\u3057\u3066 \/usr\/share\u3078\u30b3\u30d4\u30fc [bash] $ unzip phpMyAdmin-4.8.0-all-languages.zip $ mv phpMyAdmin-4.8.0-all-languages phpmyadmin $ sudo mv phpmyadmin\/ \/usr\/share\/ [\/bash] \u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u8abf\u6574 [bash] $ sudo nano \/etc\/nginx\/sites-available\/default [\/bash] \u4ee5\u4e0b\u3092\u8ffd\u8a18 [bash] location \/phpmyadmin { root \/usr\/share; index index.php; location ~ ^\/phpmyadmin.+\\.php$ { fastcgi_pass unix:\/var\/run\/php\/php7.2-fpm.sock; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params; } } [\/bash] nginx\u518d\u8d77\u52d5 [bash] $ sudo systemctl stop nginx $ sudo systemctl start nginx [\/bash] \u52d5\u4f5c\u78ba\u8a8d http:\/\/localhost\/phpmyadmin \u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8868\u793a\u306b\u306a\u308c\u3070\u6210\u529f Mysql root\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u8a2d\u5b9a \u4ee5\u524d\u306e\u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30b7\u30e7\u30f3\u3060\u3068 mysql\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u3001root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5c0b\u306d\u308b\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u51fa\u3066\u304d\u3066\u3001\u305d\u3053\u3067root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3067\u304d\u305f\u306e\u3067\u3059\u304c\u300118.04\u3067\u306f\u306a\u305c\u304b\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u4ee5\u4e0b\u3067\u8abf\u6574\u3002 [bash] $ sudo mysql -u root mysql> USE mysql mysql> UPDATE user SET plugin=’mysql_native_password’ WHERE User=’root’; mysql> FLUSH PRIVILEGES; mysql> exit; [\/bash] [bash] $ mysql -u root mysql> SET PASSWORD FOR root@’localhost’ = PASSWORD(‘xxxxxxxx’); mysql> exit; [\/bash]<\/p>\n","protected":false},"author":1,"featured_media":1827,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":{"0":"post-1825","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-4"},"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t