{"id":1786,"date":"2019-03-04T06:56:24","date_gmt":"2019-03-03T21:56:24","guid":{"rendered":"https:\/\/www.oqiita.com\/?p=1786"},"modified":"2019-03-04T06:56:24","modified_gmt":"2019-03-03T21:56:24","slug":"%e3%80%90aws%e3%80%91ubuntu%e3%81%abphpmydmin","status":"publish","type":"post","link":"https:\/\/www.oqiita.com\/?p=1786","title":{"rendered":"\u3010AWS\u3011Ubuntu\u306bphpMydmin"},"content":{"rendered":"

DB\u306fMysql\u306b\u3057\u305f\u3002\u7406\u7531\u306a\u3093\u3066\u7121\u3044\u3088\uff01<\/p>\n

<\/p>\n

Mysql\u3082\u5fc5\u8981\u306a\u306e\u3067\u524d\u306e\u8a18\u4e8b\u3067\u4f5c\u3063\u305f\u74b0\u5883\u306b\u3044\u308c\u307e\u3059\u3002<\/p>\n

\u524d\u306e\u8a18\u4e8b\u306f\u3053\u3061\u3089<\/p>\n

\n\t\t\t
\n\t\t\t\"\"<\/span><\/p>\n
\n\t\t\t\t

PHP\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n
<\/i> PHP\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/span><\/p>\n
sudo apt update\nsudo apt install php7.2 php7.2-common php7.2-cli php7.2-fpm php7.2-mysql php7.2-dev php7.2-mbstring php7.2-zip<\/code><\/pre>\n<\/div>\n
php-fpm\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306f
\n\/etc\/php\/7.2\/fpm\/php-fpm.conf<\/p>\n
php\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306f
\n\/etc\/php\/7.2\/fpm\/php.ini<\/p>\n
nginx\u306e\u8a2d\u5b9a<\/h3>\n
\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u5909\u66f4
\n\u30b5\u30f3\u30d7\u30eb\u304c\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u306b\u306a\u3063\u3066\u308b\u306e\u3067\u3001\u305d\u306e\u307e\u307e\u30b3\u30e1\u30f3\u30c8\u3092\u89e3\u9664\u3057\u3066\u4f7f\u7528\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n
<\/i> nginx \u8a2d\u5b9a<\/span><\/p>\n
sudo vi \/etc\/nginx\/sites-enabled\/default\n\n# pass PHP scripts to FastCGI server\n#\nlocation ~ \\.php$ {\n    include snippets\/fastcgi-php.conf;\n    #\n    #     # With php-fpm (or other unix sockets):\n    fastcgi_pass unix:\/run\/php\/php7.2-fpm.sock;\n    #     # With php-cgi (or other tcp sockets):\n    #     fastcgi_pass 127.0.0.1:9000;\n}<\/code><\/pre>\n<\/div>\n
nginx\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u518d\u8aad\u307f\u8fbc\u307f\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u518d\u8aad\u307f\u8fbc\u307f<\/span><\/p>\n
sudo service nginx reload}<\/code><\/pre>\n<\/div>\n
PHP\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n
<\/i> PHP\u4f5c\u6210<\/span><\/p>\n
sudo vi \/var\/www\/html\/info.php<\/code><\/pre>\n<\/div>\n
\u30d5\u30a1\u30a4\u30eb\u306e\u5185\u5bb9\u306f\u4ee5\u4e0b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
<\/i> info.php<\/span><\/p>\n
<?php \n    phpinfo(); \n?>\n<\/code><\/pre>\n<\/div>\n
\u30d6\u30e9\u30a6\u30b6\u3067\u78ba\u8a8d\u3057\u307e\u3059\u3002
\nhttp:\/\/\u300c\u30c9\u30e1\u30a4\u30f3\u300d\/info.php<\/p>\n
MYSQL<\/h3>\n
MYSQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n
<\/i> MYSQL \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/span><\/p>\n
sudo apt install mysql-server mysql-client<\/code><\/pre>\n<\/div>\n
MYSQL\u306e\u72b6\u614b\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n
<\/i> MYSQL\u72b6\u614b\u78ba\u8a8d<\/span><\/p>\n
sudo service mysql status<\/code><\/pre>\n<\/div>\n
MYSQL\u306e\u521d\u671f\u8a2d\u5b9a\u3092\u3057\u307e\u3059\u3002<\/p>\n
<\/i> MYSQL\u72b6\u614b\u78ba\u8a8d<\/span><\/p>\n
sudo mysql_secure_installation<\/code><\/pre>\n<\/div>\n
\u9014\u4e2d\u3067\u5bfe\u8a71\u5f62\u5f0f\u3067\u78ba\u8a8d\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n
\u25a0\u30d1\u30b9\u30ef\u30fc\u30c9\u30c1\u30a7\u30c3\u30af\u3092\u884c\u3046
\nVALIDATE PASSWORD PLUGIN can be used to test passwords
\nand improve security. It checks the strength of password
\nand allows the users to set only those passwords which are
\nsecure enough. Would you like to setup VALIDATE PASSWORD plugin?<\/p>\n
Press y|Y for Yes, any other key for No: y<\/p>\n
\u25a0\u30d1\u30b9\u30ef\u30fc\u30c9\u30c1\u30a7\u30c3\u30af\u306e\u30ec\u30d9\u30eb\u3092\u9078\u629e
\nLOW    Length >= 8
\nMEDIUM Length >= 8, numeric, mixed case, and special characters
\nSTRONG Length >= 8, numeric, mixed case, special characters and dictionary file<\/p>\n
Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 0 <\/p>\n
\u25a0root \u30d1\u30b9\u30ef\u30fc\u30c9\uff08\u518d\u5165\u529b\uff09
\nNew password:
\nRe-enter new password: <\/p>\n
\u25a0\u305d\u306e\u307e\u307e\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3067\u826f\u3044\u304b
\nDo you wish to continue with the password provided?
\nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : Y<\/p>\n
\u25a0\u533f\u540d\u30e6\u30fc\u30b6\u30fc\u306e\u524a\u9664
\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : Y<\/p>\n
\u25a0\u30ea\u30e2\u30fc\u30c8\u30ed\u30b0\u30a4\u30f3\u306e\u8a31\u53ef\u3057\u306a\u3044\uff1f
\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y<\/p>\n
\u25a0\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u524a\u9664\u3057\u307e\u3059\u304b\uff1f
\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y<\/p>\n
\u25a0\u30c6\u30fc\u30d6\u30eb\u306e\u518d\u8aad\u307f\u8fbc\u307f
\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y<\/p>\n
\u5bfe\u8a71\u5f62\u5f0f\u306e\u5185\u5bb9\u306f\u4ee5\u4e0b\u5168\u6587\u3067\u3059\u3002
\n\u5168\u6587\u3092\u8868\u793a<\/a><\/p>\n
\n
<\/i> MYSQL\u521d\u671f\u8a2d\u5b9a\u5bfe\u8a71\u5185\u5bb9<\/span><\/p>\n
sudo mysql_secure_installation\n\nSecuring the MySQL server deployment.\n\nConnecting to MySQL using a blank password.\n\nVALIDATE PASSWORD PLUGIN can be used to test passwords\nand improve security. It checks the strength of password\nand allows the users to set only those passwords which are\nsecure enough. Would you like to setup VALIDATE PASSWORD plugin?\n\nPress y|Y for Yes, any other key for No: y\n\nThere are three levels of password validation policy:\n\nLOW    Length >= 8\nMEDIUM Length >= 8, numeric, mixed case, and special characters\nSTRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file\n\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: \n\nInvalid option provided.\n\nThere are three levels of password validation policy:\n\nLOW    Length >= 8\nMEDIUM Length >= 8, numeric, mixed case, and special characters\nSTRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file\n\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 0\nPlease set the password for root here.\n\nNew password: \n\nRe-enter new password: \n\nEstimated strength of the password: 50 \nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : Y\nBy default, a MySQL installation has an anonymous user,\nallowing anyone to log into MySQL without having to have\na user account created for them. This is intended only for\ntesting, and to make the installation go a bit smoother.\nYou should remove them before moving into a production\nenvironment.\n\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : Y   \nSuccess.\n\n\nNormally, root should only be allowed to connect from\n'localhost'. This ensures that someone cannot guess at\nthe root password from the network.\n\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nBy default, MySQL comes with a database named 'test' that\nanyone can access. This is also intended only for testing,\nand should be removed before moving into a production\nenvironment.\n\n\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y\n - Dropping test database...\nSuccess.\n\n - Removing privileges on test database...\nSuccess.\n\nReloading the privilege tables will ensure that all changes\nmade so far will take effect immediately.\n\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nAll done! <\/code><\/pre>\n<\/div>\n<\/div>\n
MYSQL\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u307e\u3059\u3002<\/p>\n
<\/i> MYSQL\u30ed\u30b0\u30a4\u30f3<\/span><\/p>\n
sudo mysql -u root -p<\/code><\/pre>\n<\/div>\n
MYSQL\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n
<\/i> MYSQL\u30b9\u30c6\u30fc\u30bf\u30b9\u78ba\u8a8d<\/span><\/p>\n
 \" data-output=\"2-99\">status\n--------------\nmysql  Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using  EditLine wrapper\n\nConnection id:\t\t5\nCurrent database:\t\nCurrent user:\t\troot@localhost\nSSL:\t\t\tNot in use\nCurrent pager:\t\tstdout\nUsing outfile:\t\t''\nUsing delimiter:\t;\nServer version:\t\t5.7.25-0ubuntu0.18.04.2 (Ubuntu)\nProtocol version:\t10\nConnection:\t\tLocalhost via UNIX socket\nServer characterset:\tlatin1\nDb     characterset:\tlatin1\nClient characterset:\tutf8\nConn.  characterset:\tutf8\nUNIX socket:\t\t\/var\/run\/mysqld\/mysqld.sock\nUptime:\t\t\t15 min 30 sec\n\nThreads: 1  Questions: 20  Slow queries: 0  Opens: 113  Flush tables: 1  Open tables: 106  Queries per second avg: 0.021\n--------------\n<\/code><\/pre>\n<\/div>\n
\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u66f8\u304d\u63db\u3048\u307e\u3059\u3002<\/p>\n
<\/i> mysql.cnf<\/span><\/p>\n
sudo vi \/etc\/mysql\/mysql.conf.d\/mysqld.cnf\n\n[mysqld]\n# \u6587\u5b57\u30b3\u30fc\u30c9\ncharacter-set-server = utf8\n\n# \u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u6709\u52b9\u671f\u9650\ndefault_password_lifetime = 0<\/code><\/pre>\n<\/div>\n
MYSLQ\u30e6\u30fc\u30b6\u30fc\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u30e6\u30fc\u30b6\u30fc\u8ffd\u52a0<\/span><\/p>\n
 \" data-output=\"\">create user \u30e6\u30fc\u30b6\u540d identified by 'Password123@';<\/code><\/pre>\n<\/div>\n
MYSLQ\u30e6\u30fc\u30b6\u30fc\u4e00\u89a7\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u30e6\u30fc\u30b6\u30fc\u4e00\u89a7<\/span><\/p>\n
 \" data-output=\"\">select Host, User from mysql.user;<\/code><\/pre>\n<\/div>\n
\u6a29\u9650\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u6a29\u9650\u8ffd\u52a0<\/span><\/p>\n
 \" data-output=\"\">-- \u5168\u6a29\u9650\u3092\u30e6\u30fc\u30b6\u30fc\u306b\u8ffd\u52a0\nGRANT ALL PRIVILEGES ON 'db_name'.* TO 'user_name'@'%' WITH GRANT OPTION;\n\n-- \u5168DB\u306e\u5168\u6a29\u9650\u3092\u30e6\u30fc\u30b6\u30fc\u306b\u8ffd\u52a0\nGRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%' WITH GRANT OPTION;<\/code><\/pre>\n<\/div>\n
DB\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u6a29\u9650\u8ffd\u52a0<\/span><\/p>\n
 \" data-output=\"\">create database test_db1;<\/code><\/pre>\n<\/div>\n
MYSQL\u3092\u518d\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u6a29\u9650\u8ffd\u52a0<\/span><\/p>\n
sudo service mysql restart<\/code><\/pre>\n<\/div>\n
\u518d\u5ea6\u72b6\u614b\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u518d\u78ba\u8a8d<\/span><\/p>\n
 \" data-output=\"\">status<\/code><\/pre>\n<\/div>\n
phpmyadmin<\/h3>\n
\u307e\u305a\u306f\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3002<\/p>\n
<\/i> \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/span><\/p>\n
cd ~\nwget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.8.5\/phpMyAdmin-4.8.5-all-languages.zip<\/code><\/pre>\n<\/div>\n
\u89e3\u51cd\u3057\u307e\u3059\u3002<\/p>\n
<\/i> zip\u89e3\u51cd<\/span><\/p>\n
sudo unzip phpMyAdmin-4.8.5-all-languages.zip<\/code><\/pre>\n<\/div>\n
\u30ea\u30cd\u30fc\u30e0\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u30ea\u30cd\u30fc\u30e0<\/span><\/p>\n
sudo mv phpMyAdmin-4.8.5-all-languages phpmyadmin<\/code><\/pre>\n<\/div>\n
\u79fb\u52d5\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u79fb\u52d5<\/span><\/p>\n
sudo mv phpmyadmin\/ \/usr\/share\/<\/code><\/pre>\n<\/div>\n
\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u8abf\u6574\u3092\u3057\u307e\u3059\u3002<\/p>\n
<\/i> \u30d5\u30a1\u30a4\u30eb\u7de8\u96c6<\/span><\/p>\n
sudo nano \/etc\/nginx\/sites-available\/default\n\nlocation \/phpmyadmin {\n    root \/usr\/share;\n    index index.php;\n \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    }\n}<\/code><\/pre>\n<\/div>\n
nginx\u3092\u518d\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n
<\/i> nginx\u518d\u8d77\u52d5<\/span><\/p>\n
sudo service nginx restart<\/code><\/pre>\n<\/div>\n
\u30d6\u30e9\u30a6\u30b6\u3067\u78ba\u8a8d\u3057\u307e\u3059\u3002
\n\"\"<\/a><\/p>\n
\u307e\u3068\u3081<\/h3>\n
\u666e\u901a\u306b\u82e6\u52b4\u3057\u305fw
\n\u666e\u6bb5PHP\u3068\u304b\u4f7f\u308f\u306a\u3044\u3057\u3001MYSQL\u3082\u30d0\u30fc\u30b8\u30e7\u30f3\u4e0a\u304c\u3063\u3066\u3066\u3044\u308d\u3044\u308d\u5909\u66f4\u304c\u3042\u308a\u5927\u5909\u3060\u3063\u305f\uff01<\/p>\n
\u4ee5\u4e0a\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
DB\u306fMysql\u306b\u3057\u305f\u3002\u7406\u7531\u306a\u3093\u3066\u7121\u3044\u3088\uff01<\/p>\n","protected":false},"author":1,"featured_media":733,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[31],"tags":[50,230,234,235],"class_list":{"0":"post-1786","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-aws","8":"tag-mysql","9":"tag-nginx","10":"tag-php","11":"tag-phpmyadmin","12":"entry"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.oqiita.com\/wp-content\/uploads\/2018\/05\/sango_db_icatch.png","jetpack_shortlink":"https:\/\/wp.me\/p8QluP-sO","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/1786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1786"}],"version-history":[{"count":26,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/1786\/revisions"}],"predecessor-version":[{"id":1817,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/1786\/revisions\/1817"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/media\/733"}],"wp:attachment":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}