phpMyAdmin允許定義輸入的MySQL服務器IP地址,用戶名和密碼
目前創新互聯建站已為數千家的企業提供了網站建設、域名、網絡空間、網站改版維護、企業網站設計、五蓮網站維護等服務,公司將堅持客戶導向、應用為本的策略,正道將秉承"和諧、參與、激情"的文化,與客戶和合作伙伴齊心協力一起成長,共同發展。
修改/libraries/config.default.php
為真即可,簡單安全省事
$cfg['AllowArbitraryServer'] = true;
phpMyAdmin修改config.inc.php,服務器地址為下拉列表可選登錄多個服務器
增加config.sample.inc.php
文件,參考下面配置或者訪問setup手動生成
/*
* Generated configuration file
* Generated by: phpMyAdmin 4.4.11 setup script
* Date: Fri, 10 Jul 2015 15:54:42 +0800
*/
/* Servers configuration */
$i = 0;
/* Server: 10.4.14.64 [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '10.10.6.64';
$cfg['Servers'][$i]['host'] = '10.10.6.64';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server: 10.10.1.172 [2] */
$i++;
$cfg['Servers'][$i]['verbose'] = '10.10.1.172';
$cfg['Servers'][$i]['host'] = '10.10.1.172';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* End of servers configuration */
$cfg['blowfish_secret'] = '559f78c86f22d8.48481095';
$cfg['DefaultLang'] = 'zh_CN';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
如果mysql是5.1的這個版本php會報錯(
),解決方案:
vi /var/www/html/phpmyadmin/libraries/common.inc.php #查找 if (PMA_MYSQL_INT_VERSION < 50500) { #更換為 if (PMA_MYSQL_INT_VERSION < 50100) {