{"id":3715,"date":"2025-03-29T23:00:00","date_gmt":"2025-03-29T14:00:00","guid":{"rendered":"https:\/\/jikoman.sin-cos.com\/blog\/?p=3715"},"modified":"2025-03-29T23:00:00","modified_gmt":"2025-03-29T14:00:00","slug":"vps-16","status":"publish","type":"post","link":"https:\/\/jikoman.sin-cos.com\/blog\/2025\/03\/vps-16\/","title":{"rendered":"VPS\u3067AlmaLinux (16) phpMyAdmin\u306e\u5c0e\u5165"},"content":{"rendered":"\n<p><a href=\"\/blog\/2025\/03\/vps-15\/\" data-type=\"post\" data-id=\"3426\">\u524d\u56de<\/a>\u306f\u3001MariaDB\u306e\u69cb\u7bc9\u3092\u884c\u3063\u305f\u3002<br>\u4eca\u56de\u306f\u3001phpMyAdmin\u306e\u5c0e\u5165\u3092\u884c\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">EPEL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n\n\n\n<p>\u307e\u305a\u306f\u3001<a href=\"https:\/\/fedoraproject.org\/wiki\/EPEL\" target=\"_blank\" rel=\"noreferrer noopener\">Extra Packages for Enterprise Linux<\/a>&nbsp;(EPEL)\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<br>ACME\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u969b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u308b\u305f\u3081\u4e0d\u8981\u3060\u304c\u3001\u307e\u3060\u306e\u5834\u5408\u306f\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/p>\n\n\n\n<!--more-->\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo dnf -y install epel-release<br>\u3000\uff1a<br>Installed:<br>  epel-release-9-9.el9.noarch                                                                                                                                    <br><br>Complete!<br>$ sudo dnf -y upgrade<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">phpMyAdmin\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n\n\n\n<p>\u6b21\u306bphpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo dnf -y install phpMyAdmin<br>\u3000\uff1a<br>Installed:<br>  fontconfig-2.14.0-2.el9_1.x86_64      gd-2.3.2-3.el9.x86_64                httpd-filesystem-2.4.62-1.el9_5.2.noarch     jbigkit-libs-2.1-23.el9.x86_64       <br>  libX11-1.7.0-9.el9.x86_64             libX11-common-1.7.0-9.el9.noarch     libXau-1.0.9-8.el9.x86_64                    libXpm-3.5.13-10.el9.x86_64          <br>  libjpeg-turbo-2.0.90-7.el9.x86_64     libtiff-4.4.0-13.el9.x86_64          libwebp-1.2.0-8.el9_3.x86_64                 libxcb-1.13.1-9.el9.x86_64           <br>  libxslt-1.1.34-9.el9.x86_64           libzip-1.7.3-8.el9.x86_64            php-common-8.0.30-1.el9_2.x86_64             php-fpm-8.0.30-1.el9_2.x86_64        <br>  php-gd-8.0.30-1.el9_2.x86_64          php-intl-8.0.30-1.el9_2.x86_64       php-mbstring-8.0.30-1.el9_2.x86_64           php-mysqlnd-8.0.30-1.el9_2.x86_64    <br>  php-pdo-8.0.30-1.el9_2.x86_64         php-pecl-zip-1.19.2-6.el9.x86_64     php-process-8.0.30-1.el9_2.x86_64            php-xml-8.0.30-1.el9_2.x86_64        <br>  phpMyAdmin-5.2.2-1.el9.noarch         xml-common-0.6.3-58.el9.noarch      <br><br>Complete!<\/pre>\n\n\n\n<p>\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u6b21\u306e\u5834\u6240\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\/etc\/phpMyAdmin\/config.inc.php<br>phpMyAdmin\u306e\u8a2d\u5b9a<\/li>\n\n\n\n<li>\/etc\/nginx\/default.d\/phpMyAdmin.conf<br>phpMyAdmin\u3092\u8868\u793a\u3059\u308b\u305f\u3081\u306eWeb\u30b5\u30fc\u30d0\u306e\u8a2d\u5b9a<\/li>\n<\/ul>\n\n\n\n<p>Web\u30b5\u30fc\u30d0\u30fc\u306e\u8a2d\u5b9a\u304c\u5909\u66f4\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001Web\u30b5\u30fc\u30d0\u30fc\u3092\u518d\u8d77\u52d5\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl restart nginx<\/pre>\n\n\n\n<p>\u3053\u306e\u6642\u70b9\u3067\u3001\u6b21\u306eURL\u3067phpMyAdmin\u304c\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">https:\/\/your.domain\/phpMyAdmin\/<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">URL\u306e\u5909\u66f4<\/h3>\n\n\n\n<p>\u305f\u3060\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u4e0aURL\u3092\u5909\u3048\u305f\u65b9\u304c\u826f\u3044\u306e\u3067\u3001\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u5909\u66f4\u3059\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo vi \/etc\/nginx\/default.d\/phpMyAdmin.conf<\/pre>\n\n\n\n<p>\u5143\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u6b21\u306e\u3068\u304a\u308a\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># phpMyAdmin<br><br>location = \/phpMyAdmin {<br>    alias \/usr\/share\/phpMyAdmin\/;<br>}<br><br>location \/phpMyAdmin\/ {<br>     root \/usr\/share;<br>     index index.php index.html;<br><br>     location ~ ^\/phpMyAdmin\/(.+\\.php)$<br>     {<br>         try_files $uri =404;<br>         fastcgi_intercept_errors on;<br>         include        fastcgi_params;<br>         fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;<br>         fastcgi_pass   php-fpm;<br>     }<br>}<\/pre>\n\n\n\n<p>\u6b21\u306e\u3088\u3046\u306b\u5909\u66f4\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># phpMyAdmin<br><br>location = \/<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-medium-pink-color\">tekitou<\/mark> {<br>    alias \/usr\/share\/phpMyAdmin\/;<br>}<br><br>location \/<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-medium-pink-color\">tekitou<\/mark>\/ {<br>     <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-medium-pink-color\">alias \/usr\/share\/phpMyAdmin\/;<\/mark><br>     index index.php index.html;<br><br>     location ~ ^\/<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-medium-pink-color\">tekitou<\/mark>\/(.+\\.php)$<br>     {<br>         try_files $uri =404;<br>         fastcgi_intercept_errors on;<br>         include        fastcgi_params;<br>         fastcgi_param  SCRIPT_FILENAME  <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-medium-pink-color\">$request_filename<\/mark>;<br>         fastcgi_pass   php-fpm;<br>     }<br>}<\/pre>\n\n\n\n<p>\u30b5\u30fc\u30d0\u30fc\u306e\u8a2d\u5b9a\u3092\u8aad\u307f\u8fbc\u307f\u76f4\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl reload nginx<\/pre>\n\n\n\n<p>\u6b21\u306eURL\u3067phpMyAdmin\u304c\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">https:\/\/your.domain\/<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-medium-pink-color\">tekitou<\/mark>\/<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u30e6\u30fc\u30b6\u30fc\u8ffd\u52a0<\/h3>\n\n\n\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u3067\u304d\u305f\u304c\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u8a8d\u8a3c\u53ef\u80fd\u306a\u30e6\u30fc\u30b6\u30fc\u304c\u306a\u3044\u305f\u3081\u3001\u30ed\u30b0\u30a4\u30f3\u304c\u3067\u304d\u306a\u3044\u3002<\/p>\n\n\n\n<p>phpMyAdmin\u304b\u3089\u30ed\u30b0\u30a4\u30f3\u53ef\u80fd\u306a\u30e6\u30fc\u30b6\u30fc\u3092\u3001CUI\u3067\u4f5c\u6210\u3059\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo mariadb<br>Welcome to the MariaDB monitor.  Commands end with ; or \\g.<br>Your MariaDB connection id is 7<br>Server version: 11.4.5-MariaDB-log MariaDB Server<br><br>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<br><br>Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<br><br>MariaDB [(none)]&gt; CREATE USER pma_admin@localhost IDENTIFIED BY 'admin_password';<br>Query OK, 0 rows affected (0.012 sec)<br><br>MariaDB [(none)]&gt; flush privileges;<br>Query OK, 0 rows affected (0.001 sec)<br><br>MariaDB [(none)]&gt; SELECT * FROM mysql.global_priv WHERE user = 'pma_admin';<br>+-----------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>| Host      | User      | Priv                                                                                                                                                                     |<br>+-----------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>| localhost | pma_admin | {\"access\":0,\"version_id\":100000,\"plugin\":\"mysql_native_password\",\"authentication_string\":\"*\",\"password_last_changed\":1000000000} |<br>+-----------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>1 row in set (0.002 sec)<\/pre>\n\n\n\n<p>\u30ed\u30b0\u30a4\u30f3\u306f\u53ef\u80fd\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"760\" height=\"924\" src=\"\/blog\/wp-content\/uploads\/2025\/03\/image-74.png\" alt=\"\" class=\"wp-image-3766\" srcset=\"https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-74.png 760w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-74-247x300.png 247w\" sizes=\"auto, (max-width: 760px) 100vw, 760px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"332\" src=\"\/blog\/wp-content\/uploads\/2025\/03\/image-75.png\" alt=\"\" class=\"wp-image-3767\" srcset=\"https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-75.png 900w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-75-300x111.png 300w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-75-768x283.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<p>\u3060\u3060\u3001\u30ed\u30b0\u30a4\u30f3\u306f\u3067\u304d\u308b\u304c\u3001\u6a29\u9650\u304c\u4f55\u3082\u306a\u3044\u3002<\/p>\n\n\n\n<p>\u4e00\u6642\u7684\u306b\u6a29\u9650\u3092\u30d5\u30eb\u306b\u4ed8\u3051\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">MariaDB [(none)]&gt; GRANT ALL PRIVILEGES ON *.* TO pma_admin@localhost;<br>Query OK, 0 rows affected (0.002 sec)<br><br>MariaDB [(none)]&gt; SELECT * FROM mysql.global_priv WHERE user='pma_admin';<br>+-----------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>| Host      | User      | Priv                                                                                                                                                                                 |<br>+-----------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>| localhost | pma_admin | {\"access\":1000000000000,\"version_id\":100000,\"plugin\":\"mysql_native_password\",\"authentication_string\":\"*\",\"password_last_changed\":1000000000} |<br>+-----------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>1 row in set (0.001 sec)<\/pre>\n\n\n\n<p>\u8868\u793a\u3055\u308c\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3082\u5897\u3048\u305f\u3002<\/p>\n\n\n\n<p>\u53f3\u306e\u6700\u4e0b\u306b\u300cphpMyAdmin \u74b0\u5883\u4fdd\u7ba1\u9818\u57df\u304c\u5b8c\u5168\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\u305f\u3081\u3001\u3001\u3001\u300d\u3068\u3044\u3046\u8868\u793a\u304c\u51fa\u3066\u3044\u308b\u306e\u3067\u3001\u300c\u3053\u3061\u3089\u300d\u3092\u9078\u629e\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"248\" src=\"\/blog\/wp-content\/uploads\/2025\/03\/image-76-1024x248.png\" alt=\"\" class=\"wp-image-3770\" srcset=\"https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-76-1024x248.png 1024w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-76-300x73.png 300w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-76-768x186.png 768w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-76-1536x372.png 1536w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-76.png 1860w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u300c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u300d\u90e8\u5206\u3092\u9078\u629e\u3057\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6e96\u5099\u3059\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"248\" src=\"\/blog\/wp-content\/uploads\/2025\/03\/image-77-1024x248.png\" alt=\"\" class=\"wp-image-3771\" srcset=\"https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-77-1024x248.png 1024w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-77-300x73.png 300w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-77-768x186.png 768w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-77.png 1347w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u305a\u3089\u305a\u3089\u3068\u51e6\u7406\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u3066\u3001\u3084\u3063\u3068\u5b8c\u4e86\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"364\" height=\"1024\" src=\"\/blog\/wp-content\/uploads\/2025\/03\/image-78-364x1024.png\" alt=\"\" class=\"wp-image-3772\" srcset=\"https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-78-364x1024.png 364w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-78-107x300.png 107w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-78-768x2163.png 768w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-78-727x2048.png 727w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-78-scaled.png 909w\" sizes=\"auto, (max-width: 364px) 100vw, 364px\" \/><\/figure>\n\n\n\n<p><a href=\"\/blog\/2025\/09\/vps-17\">\u6b21\u56de<\/a>\u306f\u3001WordPress\u3092\u5c0e\u5165\u3059\u308b\u3002<\/p>\n\n\n\n<p>\u304a\u53cb\u9054\u7d39\u4ecb\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5229\u7528\u3057\u3066\u5951\u7d04\u3059\u308b\u306810%OFF\u306b\u306a\u308b\u305d\u3046\u306a\u306e\u3067\u3001<br>\u3082\u3057\u3088\u308d\u3057\u3051\u308c\u3070\u6b21\u306e\u753b\u50cf\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/vps.xserver.ne.jp\/?referral_token=64605993567cf006eae78d\" target=\"_blank\" rel=\" noreferrer noopener\"><img decoding=\"async\" src=\"\/blog\/wp-content\/uploads\/2025\/03\/image-36-1.png\" alt=\"\" class=\"wp-image-3494\"\/><\/a><\/figure>\n\n\n\n<p>\u6295\u7a3f\u4e00\u89a7\u306f\u3053\u3061\u3089\u2192\u300c<a href=\"\/blog\/vps\/\" data-type=\"page\" data-id=\"3450\">VPS\u3067AlmaLinux<\/a>\u300d<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin\u306e\u5c0e\u5165<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[129],"tags":[9,43,50],"class_list":["post-3715","post","type-post","status-publish","format-standard","hentry","category-pc","tag-almalinux","tag-vps","tag-xserver"],"_links":{"self":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/posts\/3715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/comments?post=3715"}],"version-history":[{"count":0,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/posts\/3715\/revisions"}],"wp:attachment":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/media?parent=3715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/categories?post=3715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/tags?post=3715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}