phpMyAdmin 安裝

Web介面管理MySQL資料庫

phpMyAdmin 安裝

運行環境

確認已安裝好NGINX Mariadb

下載phpMyAdmin

cd /var/www/html

wget https://files.phpmyadmin.net/phpMyAdmin/5.2.2/phpMyAdmin-5.2.2-all-languages.zip
unzip phpMyAdmin-5.2.2-all-languages.zip
mv phpMyAdmin-5.2.2-all-languages phpmyadmin
rm phpMyAdmin-5.2.2-all-languages.zip

Nginx設定

server {
  listen 80;
  listen [::]:80;

  server_name _;

  root /var/www/html;
  index index.html;

  location /phpmyadmin/ {
          alias /var/www/html/phpmyadmin/;
          index index.php;
  }
  location ~ ^/phpmyadmin/(.+\.php)$ {
    alias /var/www/html/phpmyadmin/;
    include fastcgi_params;
    fastcgi_pass unix:/run/php/php8.4-fpm.sock;
    fastcgi_param SCRIPT_FILENAME /var/www/html/phpmyadmin/$1;
    fastcgi_param PATH_INFO $1;
  }
}
nginx -t
service nginx restart

若登入後網頁跳轉失敗

cd /var/www/html/phpmyadmin

cp config.sample.inc.php config.inc.php
nano config.inc.php
於最下面新增
$cfg['PmaAbsoluteUri'] = '/phpmyadmin/';


 

 

phpMyAdmin 使用Nginx反向代理

nginx反向代理主機設定

location /phpmyadmin/ {        #代理名稱
      proxy_pass http://10.0.0.4/phpmyadmin/;     #phpmyadmin主機位置
      proxy_set_header X-Forwarded-Proto $scheme;
    }

phpmyadmin主機設定，路徑下/var/www/html/phpmyadmin/config.inc.php 編輯或新增此檔案

<?php
$cfg['PmaAbsoluteUri'] = "https://自訂網域/phpmyadmin/";
?>