{"id":3061,"date":"2021-08-13T12:10:00","date_gmt":"2021-08-13T03:10:00","guid":{"rendered":"https:\/\/sitecloud.jp\/?post_type=blog&p=3061"},"modified":"2023-01-19T13:29:47","modified_gmt":"2023-01-19T04:29:47","slug":"aws%e7%92%b0%e5%a2%83%e3%81%aewordpress%e5%9f%ba%e6%9c%ac%e6%a7%8b%e6%88%90%e3%83%91%e3%82%bf%e3%83%bc%e3%83%b3%e3%82%92%e7%b4%b9%e4%bb%8b-web%e3%82%b5%e3%83%bc%e3%83%90%e3%83%bc1%e5%8f%b0%e3%83%bbdb","status":"publish","type":"blog","link":"https:\/\/kurojica.com\/server\/blog\/3061\/","title":{"rendered":"AWS\u74b0\u5883\u306eWordPress\u57fa\u672c\u69cb\u6210\u30d1\u30bf\u30fc\u30f3\u3092\u7d39\u4ecb Web\u30b5\u30fc\u30d0\u30fc1\u53f0\u30fbDB\u30b5\u30fc\u30d0\u30fc1\u53f0"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n
\"\"<\/a><\/figure><\/div>\n\n\n\n

\u3053\u3093\u306b\u3061\u306f\u3002\u300c\u30af\u30ed\u30b8\u30ab\u30b5\u30fc\u30d0\u30fc\u7ba1\u7406\u300d<\/a>\u30b3\u30f3\u30b5\u30eb\u30c6\u30a3\u30f3\u30b0\u30c1\u30fc\u30e0\u306e\u4e09\u8c37\u3067\u3059\u3002<\/p>\n\n\n\n

\u3053\u306e\u8a18\u4e8b\u306f\u3001AWS\u521d\u5fc3\u8005\u5411\u3051AWS\u74b0\u5883\u306eWordPress\u57fa\u672c\u30d1\u30bf\u30fc\u30f38\u3064\u4f5c\u3063\u3066\u307f\u305f<\/a>\u306e\u30d1\u30bf\u30fc\u30f32\u306e\u4f5c\u6210\u65b9\u6cd5\u3092\u7d39\u4ecb\u3059\u308b\u8a18\u4e8b\u3067\u3059\u3002\u305d\u306e\u307e\u307e\u771f\u4f3c\u3092\u3059\u308c\u3070\u3001\u8ab0\u3067\u3082AWS\u3092\u4f7f\u3063\u3066WordPress\u306e\u5165\u3063\u305f\u30bf\u30a4\u30c8\u30eb\u901a\u308a\u306e\u69cb\u6210\u306e\u30b5\u30fc\u30d0\u30fc\u3092\u5efa\u3066\u308b\u4e8b\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n

WordPress\u306e\u69cb\u7bc9<\/h2>\n\n\n\n

Web\u30b5\u30fc\u30d0\u30fc\u5074\u30b5\u30fc\u30d0\u30fc\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4f5c\u6210<\/h3>\n\n\n\n

\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u306b\u3064\u3044\u3066\u306f\u3053\u306e\u8a18\u4e8b<\/a>\u3068\u540c\u69d8\u306e\u4f5c\u696d\u3092\u884c\u3046\u306e\u3067\u3001\u3053\u3061\u3089\u3082\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

1.Amazon Linux 2\u3067\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002
\u4e0a\u8a18\u306e\u8a18\u4e8b\u3092\u53c2\u8003\u306b\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u5f8c\u306b\u5225\u30b5\u30fc\u30d0\u30fc\u306eMySQL\u306b\u5916\u90e8\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u306e\u3067\u3001\u624b\u98066:\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u306e\u8a2d\u5b9a\u306b\u304a\u3044\u3066\u3001\u30bf\u30a4\u30d7\u3068\u3057\u3066MYSQL\/Aurora\u3092\u9078\u629e\u3057\u30013306\u756a\u30dd\u30fc\u30c8\u3092\u958b\u3051\u3066\u304a\u304d\u307e\u3059\u3002\u30bd\u30fc\u30b9\u306f\u3001\u4efb\u610f\u306e\u5834\u6240\u306b\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

2.ssh\u63a5\u7d9a\u3057\u3001\u30b5\u30fc\u30d0\u30fc\u69cb\u7bc9\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\u5b9f\u884c\u3059\u308b\u30b3\u30de\u30f3\u30c9\u306e\u307f\u5217\u6319\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

$ ssh -i [\u516c\u958b\u9375].pem ec2-user@[IP\u30a2\u30c9\u30ec\u30b9]
[ec2-user@ ~]$ sudo su -
[root@ ~]# amazon-linux-extras install php7.2
[root@ ~]# yum localinstall https:\/\/dev.mysql.com\/get\/mysql80-community-release-el7-1.noarch.rpm -y
[root@ ~]# yum-config-manager --disable mysql80-community
[root@ ~]# yum-config-manager --enable mysql57-community
[root@ ~]# yum install -y httpd php mysql-community-server
[root@ ~]# systemctl start httpd mysqld
[root@ ~]# systemctl enable mysqld httpd
Created symlink from \/etc\/systemd\/system\/multi-user.target.wants\/mysqld.service to \/usr\/lib\/systemd\/system\/mysqld.service.
Created symlink from \/etc\/systemd\/system\/multi-user.target.wants\/httpd.service to \/usr\/lib\/systemd\/system\/httpd.service.<\/p>\n\n\n\n

\u3053\u308c\u306b\u3088\u3063\u3066\u3001\u6700\u65b0\u306eLAMP\u74b0\u5883(Apache,MySQL,PHP)\u304c\u69cb\u7bc9\u3055\u308c\u307e\u3059\u3002\u5c1a\u3001\u3053\u306e\u6642\u70b9\u3067\u30b5\u30fc\u30d0\u30fc\u5074\u306e\u30b5\u30fc\u30d0\u30fc\u306bMySQL\u3092\u7528\u610f\u3059\u308b\u70b9\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5074\u30b5\u30fc\u30d0\u30fc\u306eMySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001\u30e6\u30fc\u30b6\u8a2d\u5b9a\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u3067\u3059\u3002<\/p>\n\n\n\n

3.Wordpress\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002
\u65e5\u672c\u8a9e\u7248WordPress\u3092\u53d6\u5f97\u3057\u3066\u89e3\u51cd\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

[root@ ~]# cd \/var\/www\/html\/
[root@ html]# wget https:\/\/ja.wordpress.org\/latest-ja.tar.gz
[root@ html]# tar -xzvf latest-ja.tar.gz
[root@ html]# rm latest-ja.tar.gz<\/p>\n\n\n\n

\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u30eb\u30fc\u30c8\u306e\u53c2\u7167\u5148\u3092\u3053\u3053\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

[root@ html]# vim \/etc\/httpd\/conf\/httpd.conf
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot \"\/var\/www\/html\/wordpress\"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<\/p>\n\n\n\n

3.MySQL\u306b\u304a\u3044\u3066\u3001WordPress\u7528\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002
\u5f8c\u307b\u3069\u3001DB\u5074\u306e\u30b5\u30fc\u30d0\u30fcDB\u3092\u4f7f\u3046\u306e\u3067\u3001\u3053\u306eDB\u306f\u4e0d\u8981\u306b\u306a\u308a\u307e\u3059\u304c\u3001\u4f5c\u696d\u3092\u7c21\u5358\u306b\u3059\u308b\u305f\u3081\u306b\u4f5c\u3063\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

4.WordPress\u306e\u521d\u671f\u8a2d\u5b9a\u3092\u3059\u308b\u3002
\u30d6\u30e9\u30a6\u30b6\u3067IP\u30a2\u30c9\u30ec\u30b9\u76f4\u4e0b\u306eWordPress\u306b\u30a2\u30af\u30bb\u30b9\u3057\u30013\u3067\u4f5c\u6210\u3057\u305fDB\u306e\u60c5\u5831\u3092\u5165\u529b\u3057\u3001\u8a2d\u5b9a\u3092\u7d42\u3048\u3066\u304f\u3060\u3055\u3044\u3002\u30b5\u30a4\u30c8\u60c5\u5831\u306e\u767b\u9332\u307e\u3067\u7d42\u3048\u305f\u3089\u3001Web\u30b5\u30fc\u30d0\u30fc\u5074\u30b5\u30fc\u30d0\u30fc\u306e\u8a2d\u5b9a\u306f\u7d42\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5074\u30b5\u30fc\u30d0\u30fc\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4f5c\u6210<\/h3>\n\n\n\n

1.Web\u30b5\u30fc\u30d0\u30fc\u5074\u3068\u540c\u69d8\u306bLAMP\u74b0\u5883\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002Web\u30b5\u30fc\u30d0\u30fc\u5074\u306e\u624b\u9806\u306b\u6cbf\u3063\u30662\u307e\u3067\u7d42\u308f\u3089\u305b\u3066\u304f\u3060\u3055\u3044\u3002
\u306a\u304a\u3001\u3053\u3053\u3067HTTP\u3084HTTPS\u306e\u30a2\u30af\u30bb\u30b9\u3092\u30ed\u30fc\u30ab\u30eb\u306e\u307f\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001DB\u5074\u30b5\u30fc\u30d0\u30fc\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u9ad8\u304f\u4fdd\u3064\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

2.\u5916\u90e8\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u3092\u53d7\u3051\u4ed8\u3051\u308b\u305f\u3081MySQLDB\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002
\u30ed\u30b0\u304b\u3089\u521d\u671f\u30d1\u30b9\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

[root@ ~]# cat \/var\/log\/mysqld.log | grep 'localhost'
2018-08-07T01:47:41.008720Z 1 [Note] A temporary password is generated for root@localhost:[\u3053\u3053\u304c\u30d1\u30b9\u30ef\u30fc\u30c9]<\/p>\n\n\n\n

\u3053\u3061\u3089\u3067\u30ed\u30b0\u30a4\u30f3\u3057\u3001root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5909\u66f4\u3057\u305f\u5f8cWordPress\u7528\u306e\u30e6\u30fc\u30b6(wpa001)\u3068DB(wpa001)\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

[root@ ~]# mysql -uroot -p
Enter password: [\u521d\u671f\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b]
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Defaultp@ssw0rd';
mysql> create database wpa001;
mysql> create user wpa001@localhost identified by 'Hogehoge@1234';
mysql> grant all on wpa001.* to wpa001@localhost identified by 'Hogehoge@1234';
mysql> flush privileges;<\/p>\n\n\n\n

\u4eca\u306e\u3053\u306e\u72b6\u614b\u3067\u3042\u308c\u3070\u3001\u5404DB\u3078\u306e\u30a2\u30af\u30bb\u30b9\u306f\u30ed\u30fc\u30ab\u30eb\u30db\u30b9\u30c8\u306e\u307f\u306b\u5236\u9650\u3055\u308c\u3066\u3044\u308b\u306f\u305a\u3067\u3059\u3002\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308bIP\u30a2\u30c9\u30ec\u30b9\u3092Web\u30b5\u30fc\u30d0\u30fc\u5074\u30b5\u30fc\u30d0\u30fc\u306e\u307f\u306b\u8a2d\u5b9a\u3057\u3066\u3001\u5916\u90e8\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

mysql> select user, host from mysql.user;
+---------------+-----------+
| user | host |
+---------------+-----------+
| root | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| wpa001 | localhost |
+---------------+-----------+
4 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON wpa001.* TO wpa001@'[Web\u30b5\u30fc\u30d0\u30fc\u5074IP\u30a2\u30c9\u30ec\u30b9]' IDENTIFIED BY '[\u30d1\u30b9\u30ef\u30fc\u30c9]' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> select user, host from mysql.user;
+---------------+-----------+
| user | host |
+---------------+-----------+
| wpa001 | [IP\u30a2\u30c9\u30ec\u30b9] |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
| wpa001 | localhost |
+---------------+-----------+
5 rows in set (0.00 sec)<\/p>\n\n\n\n

\u3053\u308c\u3067\u6307\u5b9a\u3055\u308c\u305f\u30db\u30b9\u30c8\u304b\u3089wpa001\u3068\u3044\u3046\u30e6\u30fc\u30b6\u304c\u3001wp001\u3068\u3044\u3046DB\u306b\u63a5\u7d9a\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u4ed6\u306e\u30db\u30b9\u30c8\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u306f\u53d7\u3051\u4ed8\u3051\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\u4ee5\u4e0a\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5074\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306f\u4f5c\u6210\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n

WordPress\u304c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5074\u306eDB\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3059\u308b<\/h3>\n\n\n\n

1.\u307e\u305a\u306f\u3001Web\u30b5\u30fc\u30d0\u30fc\u5074\u304b\u3089DB\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u306e\u304b\u78ba\u304b\u3081\u307e\u3059\u3002<\/p>\n\n\n\n

[root@ ~]# mysql -h\u3000[DB\u5074\u30b5\u30fc\u30d0\u30fc\u306eIP\u30a2\u30c9\u30ec\u30b9] -u wpa001 -p -P 3306
Enter password:[\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5074\u306eDB(wpa001)\u3067\u8a2d\u5b9a\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9]
Welcome to the MySQL monitor. Commands end with ; or \\g.
Your MySQL connection id is 11
Server version: 5.7.25 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and\/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.

mysql><\/p>\n\n\n\n

\u4ee5\u4e0a\u306e\u3088\u3046\u306b\u8868\u793a\u3055\u308c\u305f\u3089OK\u3067\u3059\u3002\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n

2.WordPress\u306e\u8a2d\u5b9a\u3092\u3057\u307e\u3059\u3002wp-config.php\u306b\u53c2\u7167\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u60c5\u5831\u304c\u3042\u308b\u306e\u3067\u3001\u3053\u3053\u3092\u7de8\u96c6\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

[root@ ~]# vim \/var\/www\/html\/wordpress\/wp-config.php
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
\/\/ ** MySQL \u8a2d\u5b9a - \u3053\u306e\u60c5\u5831\u306f\u30db\u30b9\u30c6\u30a3\u30f3\u30b0\u5148\u304b\u3089\u5165\u624b\u3057\u3066\u304f\u3060\u3055\u3044\u3002 ** \/\/
\/** WordPress \u306e\u305f\u3081\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d *\/
define('DB_NAME', 'wpa001');

\/** MySQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30e6\u30fc\u30b6\u30fc\u540d *\/
define('DB_USER', 'wpa001');

\/** MySQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d1\u30b9\u30ef\u30fc\u30c9 *\/
\/**define('DB_PASSWORD', '[\u5143\u306e\u30d1\u30b9\u30ef\u30fc\u30c9]');*\/
define('DB_PASSWORD','[DB\u5074DB(wpa001)\u306b\u8a2d\u5b9a\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9]');

\/** MySQL \u306e\u30db\u30b9\u30c8\u540d *\/
\/**define('DB_HOST', 'localhost');*\/
define('DB_HOST', '[DB\u5074\u30b5\u30fc\u30d0\u30fc\u306eIP\u30a2\u30c9\u30ec\u30b9]');
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<\/p>\n\n\n\n

\u3053\u308c\u3067Web\u30b5\u30fc\u30d0\u30fc\u5074\u304b\u3089WordPress\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001DB\u5074\u306ewpa001\u3068\u3044\u3046DB\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n","protected":false},"author":2,"featured_media":3062,"template":"","tags":[41,39],"class_list":["post-3061","blog","type-blog","status-publish","has-post-thumbnail","hentry","tag-aws","tag-wordpress"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kurojica.com\/server\/wp-json\/wp\/v2\/blog\/3061"}],"collection":[{"href":"https:\/\/kurojica.com\/server\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/kurojica.com\/server\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/kurojica.com\/server\/wp-json\/wp\/v2\/users\/2"}],"version-history":[{"count":0,"href":"https:\/\/kurojica.com\/server\/wp-json\/wp\/v2\/blog\/3061\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kurojica.com\/server\/wp-json\/wp\/v2\/media\/3062"}],"wp:attachment":[{"href":"https:\/\/kurojica.com\/server\/wp-json\/wp\/v2\/media?parent=3061"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kurojica.com\/server\/wp-json\/wp\/v2\/tags?post=3061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}