{"id":1602,"date":"2023-12-16T23:02:48","date_gmt":"2023-12-16T14:02:48","guid":{"rendered":"https:\/\/rfsec.ddns.net\/db\/?p=1602"},"modified":"2025-09-14T10:39:47","modified_gmt":"2025-09-14T01:39:47","slug":"wordpress-%e3%81%ae%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%a8mysql","status":"publish","type":"post","link":"https:\/\/rfsec.ddns.net\/db\/?p=1602","title":{"rendered":"WordPress \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068Mysql"},"content":{"rendered":"\n<p>\u53c2\u8003\u306b\u3057\u305f\u30b5\u30a4\u30c8<\/p>\n\n\n\n<p><a href=\"https:\/\/qiita.com\/cherubim1111\/items\/b259493a39e36f5d524b\">https:\/\/qiita.com\/cherubim1111\/items\/b259493a39e36f5d524b<\/a><\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>TimeZOne\u8a2d\u5b9a\nsudo su - \ntimedatectl set-timezone Asia\/Tokyo\n\nApache\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\napt -y update\napt -y install apache2 \nsystemctl enable apache2\nsystemctl start apache2\n\nPHP 7.4 \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\napt -y install php7.4 php7.4-mysql\n\nMariaDB 10.5 \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\napt -y install mariadb-server mariadb-client\nsystemctl enable mariadb\nsystemctl start mariadb\n\nWordPress \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\ncd \/var\/www\/html\nwget https:\/\/ja.wordpress.org\/latest-ja.tar.gz\ntar xvf latest-ja.tar.gz\nchown -R www-data:www-data .\n\nWordPress \u7528\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210\uff08DB\u540dwirdpress\u306e\u5834\u5408)\nCREATE DATABASE wordpress DEFAULT CHARACTER SET utf8;\n\nWordPress \u7528 MariaDB \u30e6\u30fc\u30b6\u306e\u4f5c\u6210\nCREATE DATABASE wordpress;\nCREATE USER &#39;wordpressuser&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;your_password&#39;;\nGRANT ALL PRIVILEGES ON wordpress.* TO &#39;wordpressuser&#39;@&#39;localhost&#39;;\nFLUSH PRIVILEGES;\nEXIT;<\/code><\/pre><\/div>\n<\/div><\/div>\n\n\n\n<p>MySQL\u306e\u64cd\u4f5c<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4e00\u89a7\u8868\u793a\nMariaDB [(none)]&gt; show databases;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| mysql              |\n| performance_schema |\n| press              |\n| rf                 |\n| wp                 |\n+--------------------+\n6 rows in set (0.001 sec)\n\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30a2\u30af\u30bb\u30b9\nMariaDB [(none)]&gt; use press;\nReading table information for completion of table and column names\nYou can turn off this feature to get a quicker startup with -A\n\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u8868\u793a\nDatabase changed\nMariaDB [press]&gt; show tables;\n+-----------------------+\n| Tables_in_press       |\n+-----------------------+\n| ww_commentmeta        |\n| ww_comments           |\n| ww_links              |\n| ww_options            |\n| ww_postmeta           |\n| ww_posts              |\n| ww_term_relationships |\n| ww_term_taxonomy      |\n| ww_termmeta           |\n| ww_terms              |\n| ww_usermeta           |\n| ww_users              |\n+-----------------------+\n12 rows in set (0.001 sec)\n\n\u30c6\u30fc\u30d6\u30eb\u8868\u793a\u306e\u4e2d\u8eab\u3092\u8868\u793a\nMariaDB [press]&gt; select * FROM ww_users;\n+----+------------+------------------------------------+---------------+---------------------------+---------------------------+---------------------+---------------------+-------------+--------------+\n| ID | user_login | user_pass                          | user_nicename | user_email                | user_url                  | user_registered     | user_activation_key | user_status | display_name |\n+----+------------+------------------------------------+---------------+---------------------------+---------------------------+---------------------+---------------------+-------------+--------------+\n|  1 | mars       | $P$BpsXyK.d4ER7ABVH9hZioBiaGNFvAJ1 | mars          | ei2k-hrai@asahi-net.or.jp | http:\/\/ps2.ddns.net\/press | 2021-04-01 12:53:41 |                     |           0 | mars         |\n+----+------------+------------------------------------+---------------+---------------------------+---------------------------+---------------------+---------------------+-------------+--------------+\n1 row in set (0.001 sec)\n\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u524a\u9664\u3059\u308b\nDROP DATABASE [IF EXISTS] db_name<\/code><\/pre><\/div>\n\n\n\n<p>\u30e6\u30fc\u30b6\u30d1\u30b9\u30ef\u30fc\u30c9\u3092DB\u304b\u3089\u76f4\u63a5\u5909\u66f4\u3059\u308b\u65b9\u6cd5<\/p>\n\n\n\n<p><a href=\"https:\/\/www.wakuwakubank.com\/posts\/648-wordpress-userpassword\/\">https:\/\/www.wakuwakubank.com\/posts\/648-wordpress-userpassword\/<\/a><\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>UPDATE \u5bfe\u8c61DB.DB\u63a5\u982d\u8a9eusers                # UPDATE press.ww_users\nSET user_pass = MD5(&#39;\u65b0\u3057\u3044\u30d1\u30b9\u30ef\u30fc\u30c9&#39;)     # SET user_pass = MD5(&#39;\u65b0\u3057\u3044\u30d1\u30b9\u30ef\u30fc\u30c9&#39;) \nWHERE user_login = &#39;\u30d1\u30b9\u3092\u5909\u66f4\u3057\u305f\u3044\u30e6\u30fc\u30b6\u30fc\u540d&#39;;<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u53c2\u8003\u306b\u3057\u305f\u30b5\u30a4\u30c8 https:\/\/qiita.com\/cherubim1111\/items\/b259493a39e36f5d524b MySQL\u306e\u64cd\u4f5c \u30e6\u30fc\u30b6\u30d1\u30b9\u30ef\u30fc\u30c9\u3092DB\u304b\u3089\u76f4\u63a5\u5909\u66f4\u3059\u308b\u65b9\u6cd5 https:\/\/www. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1602","post","type-post","status-publish","format-standard","hentry","category-network"],"featured_image_src":null,"author_info":{"display_name":"mars","author_link":"https:\/\/rfsec.ddns.net\/db\/?author=1"},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=\/wp\/v2\/posts\/1602","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1602"}],"version-history":[{"count":2,"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=\/wp\/v2\/posts\/1602\/revisions"}],"predecessor-version":[{"id":2156,"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=\/wp\/v2\/posts\/1602\/revisions\/2156"}],"wp:attachment":[{"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rfsec.ddns.net\/db\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}