yum install httpd mariadb mariadb-server php php-mbstring php-mysql -y
# 下載最新版(以 5.2.1 為例)
wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.tar.gz
tar zxvf phpMyAdmin-5.2.1-all-languages.tar.gz
mv phpMyAdmin-5.2.1-all-languages /var/www/html/phpmyadmin
# 設定權限
chown -R apache:apache /var/www/html/phpmyadmin
chmod -R 755 /var/www/html/phpmyadmin
# 檢查模組是否存在
ls /usr/lib64/httpd/modules/libphp*.so
# 編輯 /etc/httpd/conf.d/php.conf
LoadModule php_module /usr/lib64/httpd/modules/libphp7.so # 依實際檔名調整
AddHandler php-script .php
DirectoryIndex index.php
cd /var/www/html/phpmyadmin
cp libraries/config.default.php config.inc.php
vim config.inc.php
$cfg['PmaAbsoluteUri'] = 'https://your-domain.com/phpmyadmin/';
$cfg['blowfish_secret'] = 'your_32_chars_random_string_here'; // 32 字元隨機字串
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // 推薦 cookie 認證
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = ''; // 留空由使用者輸入
$cfg['Servers'][$i]['port'] = 3306;
$cfg['Servers'][$i]['socket'] = '';
systemctl start mariadb
systemctl enable mariadb
# 安全性初始化
mysql_secure_installation
# 依提示設定 root 密碼、移除匿名用戶、禁止遠程 root、移除測試庫
systemctl start httpd
systemctl enable httpd
# 防火牆開放 80/443
firewall-cmd --permanent --add-service=http
firewall-cmd --permanent --add-service=https
firewall-cmd --reload
瀏覽器打開:https://your-server-ip/phpmyadmin
輸入 root 與剛設定的密碼登入。
mv /var/www/html/phpmyadmin /var/www/html/pma_secret_abc123# /etc/httpd/conf.d/phpmyadmin.conf
AuthType Basic
AuthName "Restricted Area"
AuthUserFile /etc/httpd/.htpasswd
Require valid-user
Require ip 192.168.1.0/24| 現象 | 原因 | 解決 |
|---|---|---|
| 空白頁/500 錯誤 | PHP 模組未載入/版本不匹配 | 檢查 httpd/error_log、確認 php_module 路徑 |
| 無法登入 | root 帳號 plugin=unix_socket | UPDATE mysql.user SET plugin='mysql_native_password' WHERE User='root'; FLUSH PRIVILEGES; |
| blowfish_secret 警告 | 未設定或長度不足 | 設定 32 字元隨機字串 |
| 無法建立設定儲存 | 缺少 phpmyadmin 設定資料庫 |