檔案位置
D:\wamp\apps\phpmyadmin4.0.4\config.inc.php
完整設定檔內容
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 4.0.4 setup script
* Date: Mon, 26 Aug 2013 05:32:47 +0000
*/
$cfg['blowfish_secret'] = 'a8b7c6d';
$i = 0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = '127.0.0.1:3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['blowfish_secret'] = 'SB12035555';
$cfg['Error_Handler']['display'] = true;
$cfg['VersionCheck'] = false;
$cfg['ThemeDefault'] = 'original';
$cfg['MaxDbList'] = 300;
$cfg['MaxNavigationItems'] = 300;
$cfg['MaxTableList'] = 300;
$cfg['NavigationDisplayLogo'] = false;
$cfg['ShowDbStructureCreation'] = true;
$cfg['ShowDbStructureLastUpdate'] = true;
$cfg['ShowDbStructureLastCheck'] = false;
$cfg['HideStructureActions'] = true;
$cfg['FontFamily'] = 'MS YaHei';
$cfg['FontFamilyFixed'] = 'Vencent';
?>
關鍵參數說明
| 參數 | 說明 |
|---|
blowfish_secret | Cookie 認證加密金鑰，請設定為 32 字元以上隨機字串 |
auth_type | 認證方式：cookie（推薦）、http、config、signon |
host | MySQL 主機位址，可含埠號 host:port |
connect_type | 連線類型：tcp、socket |
extension | PHP 擴展：mysqli（推薦）、mysql |
AllowNoPassword | 是否允許空密碼登入 |
DefaultLang | 預設介面語言 |
UploadDir/SaveDir | 匯入/匯出檔案目錄（需可寫入權限） |
VersionCheck | 是否檢查版本更新 |
MaxDbList 等 | 導航列表最大顯示數量 |
FontFamily | 介面字型設定 |
安全性建議
- 生產環境務必修改
blowfish_secret 為強隨機字串
- 設定
AllowNoPassword = false
- 限制存取 IP 或使用 HTTPS
- 定期更新 phpMyAdmin 版本
