{"id":1001,"date":"2017-02-24T11:50:57","date_gmt":"2017-02-24T02:50:57","guid":{"rendered":"https:\/\/takumi9942.net\/blog\/?p=1001"},"modified":"2024-09-15T14:49:01","modified_gmt":"2024-09-15T05:49:01","slug":"how-to-install-mariadb-phpmyadmin","status":"publish","type":"post","link":"https:\/\/takumi9942.net\/blog\/?p=1001","title":{"rendered":"\u3010Conoha\u3011MariaDB\u3068phpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3048\u308b\u3088\u3046\u306b\u3057\u3066\u307f\u305f"},"content":{"rendered":"<p>\u524d\u56deLet&#8217;s Encrypt\u3092\u5c0e\u5165\u3057\u3066\u30b5\u30a4\u30c8\u3092https\u5316\u3057\u307e\u3057\u305f\u3002<br \/>\n\u4eca\u56de\u306fMySQL\u306e\u5f8c\u7d99MariaDB\u3068phpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3048\u308b\u74b0\u5883\u3092\u4f5c\u308d\u3046\u3068\u601d\u3044\u307e\u3059\u3002<br \/>\n<!--more--><\/p>\n<div class=\"alert alert-danger\" role=\"alert\"><i class=\"fa fa-warning\"><\/i> \u3053\u306e\u8a18\u4e8b\u306f\u6700\u7d42\u66f4\u65b0\u304b\u30891\u5e74\u4ee5\u4e0a\u7d4c\u904e\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u30c7\u30fc\u30bf\u306e\u4fe1\u3074\u3087\u3046\u6027\u304c\u975e\u5e38\u306b\u4f4e\u304f\u306a\u3063\u3066\u3044\u307e\u3059\u3002<br \/>\n\u6700\u65b0\u8a18\u4e8b\u304c\u3042\u308a\u307e\u3059\u306e\u3067\u3001\u305d\u3061\u3089\u3092\u3054\u89a7\u3044\u305f\u3060\u304f\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<br \/>\n\u6700\u65b0\u8a18\u4e8b\u3092\u8868\u793a\u3059\u308b\u306b\u306f\u4ee5\u4e0b\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n<a class=\"btn btn-danger btn-block\" style=\"margin-top: 10px; white-space: normal;\" title=\"\u7121\u6599\u306e\u30aa\u30f3\u30e9\u30a4\u30f3\u30b9\u30c8\u30ec\u30fc\u30b8\u3092\u8ee2\u9001\u901f\u5ea6\u3067\u6bd4\u8f03\u3057\u3066\u307f\u305f\" href=\"https:\/\/takumi9942.net\/blog\/?p=1643\" target=\"_blank\" rel=\"noopener\">MariaDB\u3068phpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066WordPress\u3092\u7acb\u3061\u4e0a\u3052\u308b<\/a><\/div>\n<p>0.<a href=\"https:\/\/takumi9942.net\/blog\/?p=958\">\u524d\u3005\u56de\u306e\u8a18\u4e8b<\/a>\u306b\u793a\u3057\u305f\u65b9\u6cd5\u3067\u5916\u90e8\u30ec\u30dd\u30b8\u30c8\u30ea\u3092\u8ffd\u52a0\u3057\u3001Nginx\u3068PHP\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<p>1.\u307e\u305aphp\u7528\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<pre>yum install php-mysqlnd\r\n<\/pre>\n<p>2.\u30e2\u30b8\u30e5\u30fc\u30eb\u304c\u4f7f\u3048\u308b\u3088\u3046\u306bphp\u3092\u518d\u8d77\u52d5\u3057\u307e\u3059<\/p>\n<pre>systemctl restart php-fpm\r\n<\/pre>\n<p>3.MariaDB\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u305f\u3081\u306e\u30ec\u30dd\u30b8\u30c8\u30ea\u3092\u8ffd\u8a18\u3057\u307e\u3059\u3002<\/p>\n<pre>vim \/etc\/yum.repos.d\/MariaDB.repo\r\n<\/pre>\n<pre># MariaDB 10.1 CentOS repository list - created 2017-02-23 06:49 UTC\r\n# http:\/\/downloads.mariadb.org\/mariadb\/repositories\/\r\n[mariadb]\r\nname = MariaDB\r\nbaseurl = http:\/\/yum.mariadb.org\/10.1\/centos7-amd64\r\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\ngpgcheck=1\r\n<\/pre>\n<p>4.MariaDB\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<pre>yum install MariaDB-server MariaDB-client<\/pre>\n<p>5.MariaDB\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u7de8\u96c6\u3057\u3001\u6a19\u6e96\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u6307\u5b9a\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<pre>vim \/etc\/my.cnf<\/pre>\n<pre>[mysqld]\r\ncharacter-set-server=utf8\r\n\r\n[client]\r\ndefault-character-set=utf8\r\n<\/pre>\n<p>6.MariaDB\u306e\u81ea\u52d5\u8d77\u52d5\u3092\u6709\u52b9\u5316\u3057\u3001\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n<pre>systemctl enable mariadb.service<\/pre>\n<pre>systemctl start mariadb.service<\/pre>\n<p>7.\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u3001MariaDB\u306e\u521d\u671f\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<pre>mysql_secure_installation<\/pre>\n<p>8.\u8cea\u554f\u306b\u3059\u3079\u3066\u7b54\u3048\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<pre>Enter current password for root (enter for none)\r\n#\u6700\u521d\u306f\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\u306e\u3067\u3053\u306e\u307e\u307eEnter\r\nSet root password? [Y\/n]\r\n#[Y]\u30ad\u30fc\u3092\u62bc\u3057\u3066\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\r\nRemove anonymous users? [Y\/n]\r\n#anonymous\u30e6\u30fc\u30b6\u30fc\u306f\u30c6\u30b9\u30c8\u7528\u306e\u30e6\u30fc\u30b6\u30fc\u306a\u306e\u3067\u3001[Y]\u30ad\u30fc\u3092\u62bc\u3057\u3066\u524a\u9664\u3057\u307e\u3059\u3002\r\nDisallow root login remotely? [Y\/n]\r\n#\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5916\u90e8\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u304b\u3069\u3046\u304b\u3092\u9078\u629e\u3057\u307e\u3059\u3002\r\n#\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305fVPS\u5185\u3060\u3051\u3067\u4f7f\u7528\u3059\u308b\u5834\u5408\u306f[Y]\u30ad\u30fc\u3092\u62bc\u3057\u3066\u30ea\u30e2\u30fc\u30c8\u30ed\u30b0\u30a4\u30f3\u3092\u7981\u6b62\u3057\u307e\u3059\r\nRemove test database and access to it? [Y\/n]\r\n#test\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u30c6\u30b9\u30c8\u7528\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306a\u306e\u3067\u3001[Y]\u30ad\u30fc\u3092\u62bc\u3057\u3066\u524a\u9664\u3057\u307e\u3059\u3002\r\nReload privilege tables now? [Y\/n]\r\n#\u3059\u3050\u306b\u8a2d\u5b9a\u3092\u53cd\u6620\u3059\u308b\u304b\u805e\u304b\u308c\u308b\u306e\u3067\u3001[Y]\u30ad\u30fc\u3092\u53cd\u6620\u3057\u307e\u3059\u3002\r\n<\/pre>\n<p>9.PHP\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<pre>vim \/etc\/php.ini<\/pre>\n<pre>date.timezone = \"Asia\/Tokyo\"\r\n\r\nmbstring.language = Japanese\r\nmbstring.internal_encoding = UTF-8\r\nmbstring.http_input = pass\r\nmbstring.http_output = pass\r\nmbstring.encoding_translation = Off\r\nmbstring.detect_order = UTF-8,SJIS,EUC-JP,JIS,ASCII\r\n\r\nexpose_php = Off\r\nsession.sid_length = 32\r\nsession.sid_bits_per_character = 5\r\n<\/pre>\n<pre>chown nginx:nginx \/var\/lib\/php\/session<\/pre>\n<p>10.phpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<pre>yum install --enablerepo=remi phpMyAdmin<\/pre>\n<p>11.phpMyAdmin\u306e\u5404\u7a2e\u8a2d\u5b9a\u3092\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n<pre>vim \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/pre>\n<pre># phpMyAdmin - Web based MySQL browser written in php\r\n# \r\n# Allows only localhost by default\r\n#\r\n# But allowing phpMyAdmin to anyone other than localhost should be considered\r\n# dangerous unless properly secured by SSL\r\n\r\nAlias \/phpMyAdmin \/usr\/share\/phpMyAdmin\r\nAlias \/phpmyadmin \/usr\/share\/phpMyAdmin\r\n\r\n\r\n   AddDefaultCharset UTF-8\r\n\r\n   \r\n     # Apache 2.4\r\n     Require all granted\r\n     # \u2191 Require\u3092\u300clocal\u300d\u304b\u3089\u300call granted\u300d\u306b\u5909\u66f4\r\n   \r\n<\/pre>\n<p>12.Nginx\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n<pre>vim \/etc\/nginx\/conf.d\/ssl.conf<\/pre>\n<pre>    location ^~ \/phpmyadmin {\r\n       alias \/usr\/share\/phpMyAdmin;\r\n       index index.php index.html;\r\n       location ~ ^\/phpmyadmin\/(.+\\.php)$ {\r\n         alias \/usr\/share\/phpMyAdmin\/$1;\r\n         fastcgi_index index.php;\r\n         fastcgi_pass  127.0.0.1:9000;\r\n         fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;\r\n         include       fastcgi_params;\r\n       }\r\n    }\r\n<\/pre>\n<p>13.phpMyAdmin\u306e\u6240\u6709\u8005\u304croot:apache\u3068\u306a\u3063\u3066\u3044\u308b\u306e\u3067nginx\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n<pre>chown -R root:nginx \/etc\/phpMyAdmin<\/pre>\n<p>14.\u8a2d\u5b9a\u304c\u5b8c\u4e86\u3057\u305f\u3089\u300c\u30c9\u30e1\u30a4\u30f3\u540d\/phpmyadmin\u300d\u3078\u30a2\u30af\u30bb\u30b9\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u30e6\u30fc\u30b6\u30fc\u540d\u306f\u300croot\u300d\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u306fMariaDB\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3059\u308c\u3070OK\u3067\u3059\u3002<\/p>\n<p>15.create_tables.sql\u3092\u30db\u30fc\u30e0\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u53d6\u308a\u51fa\u3057\u3001SFTP\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<pre>cp \/usr\/share\/phpMyAdmin\/sql\/create_tables.sql \/home\/\u30e6\u30fc\u30b6\u30fc\u540d\/create_tables.sql\r\n<\/pre>\n<p>16.\u4e0a\u90e8\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u304b\u3089create_tables.sql\u3092\u9078\u629e\u3057\u3066\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1019\" src=\"https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m2-1024x578.png\" alt=\"\" width=\"1024\" height=\"578\" srcset=\"https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m2-1024x578.png 1024w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m2-300x169.png 300w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m2-768x433.png 768w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m2-600x339.png 600w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m2.png 1113w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1020\" src=\"https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m3-1024x520.png\" alt=\"\" width=\"1024\" height=\"520\" srcset=\"https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m3-1024x520.png 1024w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m3-300x152.png 300w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m3-768x390.png 768w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m3-600x305.png 600w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m3.png 1120w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>17.\u5de6\u306e\u30e1\u30cb\u30e5\u30fc\u304b\u3089phpmyadmin\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u3092\u9078\u629e\u80a2\u3001\u4e0a\u90e8\u306e\u7279\u6a29\u3092\u30af\u30ea\u30c3\u30af\u3002\u30e6\u30fc\u30b6\u30fc\u306e\u65b0\u898f\u4f5c\u6210\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p>18.\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3001\u30db\u30b9\u30c8\u540d\u3092\u30ed\u30fc\u30ab\u30eb\u306b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9&#8221;phpmyadmin&#8221;\u3078\u3059\u3079\u3066\u306e\u7279\u6a29\u3092\u4e0e\u3048\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1021\" src=\"https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m1-1024x647.png\" alt=\"\" width=\"1024\" height=\"647\" srcset=\"https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m1-1024x647.png 1024w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m1-300x189.png 300w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m1-768x485.png 768w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m1-600x379.png 600w, https:\/\/takumi9942.net\/blog\/wp-content\/uploads\/2017\/02\/m1.png 1080w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>18.phpMyAdmin\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3057\u307e\u3059<\/p>\n<pre>vim \/etc\/phpMyAdmin\/config.inc.php<\/pre>\n<pre>\/**\r\n * phpMyAdmin configuration storage settings.\r\n *\/\r\n\r\n\/* User used to manipulate with storage *\/\r\n$cfg['Servers'][$i]['controlhost'] = '';\r\n$cfg['Servers'][$i]['controlport'] = '';\r\n$cfg['Servers'][$i]['controluser'] = '\u4f5c\u6210\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u540d';\r\n$cfg['Servers'][$i]['controlpass'] = '\u4f5c\u6210\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9';\r\n\r\n\/* Storage database and tables *\/\r\n$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';\r\n$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';\r\n$cfg['Servers'][$i]['relation'] = 'pma__relation';\r\n$cfg['Servers'][$i]['table_info'] = 'pma__table_info';\r\n$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';\r\n$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';\r\n$cfg['Servers'][$i]['column_info'] = 'pma__column_info';\r\n$cfg['Servers'][$i]['history'] = 'pma__history';\r\n$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';\r\n$cfg['Servers'][$i]['tracking'] = 'pma__tracking';\r\n$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';\r\n$cfg['Servers'][$i]['recent'] = 'pma__recent';\r\n$cfg['Servers'][$i]['favorite'] = 'pma__favorite';\r\n$cfg['Servers'][$i]['users'] = 'pma__users';\r\n$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';\r\n$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';\r\n$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';\r\n$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';\r\n$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';\r\n$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';\r\n#\u3053\u3053\u307e\u3067\u306e\u30b3\u30e1\u30f3\u30c8\u884c\u3092\u5916\u3059\r\n\r\n\/**\r\n * End of servers configuration\r\n *\/\r\n<\/pre>\n<p>19.\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u51fa\u6765\u305f\u306e\u3067\u3001Wordpress\u304c\u52d5\u4f5c\u3059\u308b\u3088\u3046\u306bPHP\u306b\u66f8\u304d\u8fbc\u307f\u6a29\u9650\u3092\u4e0e\u3048\u307e\u3059<\/p>\n<pre>#\u81ea\u5206\u306e\u30e6\u30fc\u30b6\u30fc\u3092nginx\u30b0\u30eb\u30fc\u30d7\u306b\u5165\u308c\r\nusermod -aG nginx takumi9942\r\n#\u516c\u958b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u6240\u6709\u8005\u3092nginx\u306b\u3057\u307e\u3059\r\nchown -R nginx:nginx \/usr\/share\/nginx\/html\/\r\n#\u6700\u5f8c\u306bset GID\u30d3\u30c3\u30c8\u3092\u7acb\u3066\u3066\u5b8c\u4e86\u3067\u3059\r\nchmod 2775 \/usr\/share\/nginx\/html\/<\/pre>\n<p>20.\u3064\u3044\u3067\u306b\u30e1\u30fc\u30eb\u3082\u9001\u4fe1\u3067\u304d\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<pre>\r\nvim \/etc\/postfix\/main.cf\r\n#\u4ee5\u4e0b\u3092\u5909\u66f4\r\nmyhostname = \u30c9\u30e1\u30a4\u30f3\u540d\r\nmyorigin = $myhostname\r\n<\/pre>\n<p>\u3053\u308c\u3067WEB\u74b0\u5883\u306e\u69cb\u7bc9\u306f\u4e00\u901a\u308a\u5b8c\u4e86\u3067\u3059\u3002<br \/>\nVPS\u3063\u3066\u5927\u5909\u3067\u3059\u306d(;\u00b4\u0434\uff40)\uff84\uff8e\uff8e\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"\u524d\u56deLet&#8217;s Encrypt\u3092\u5c0e\u5165\u3057\u3066\u30b5\u30a4\u30c8\u3092https\u5316\u3057\u307e\u3057\u305f\u3002 \u4eca\u56de\u306fMySQL\u306e\u5f8c\u7d99MariaDB\u3068phpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3048\u308b\u74b0\u5883\u3092\u4f5c\u308d\u3046\u3068\u601d\u3044\u307e\u3059\u3002","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"csco_display_header_overlay":false,"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","csco_post_video_location":[],"csco_post_video_location_hash":"","csco_post_video_url":"","csco_post_video_bg_start_time":0,"csco_post_video_bg_end_time":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[14],"tags":[],"class_list":{"0":"post-1001","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-conoha","7":"cs-entry","8":"cs-video-wrap"},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1001"}],"version-history":[{"count":1,"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1001\/revisions"}],"predecessor-version":[{"id":2563,"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1001\/revisions\/2563"}],"wp:attachment":[{"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/takumi9942.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}