PHP MyAdmin 設定多伺服器管理

2014-06-11

1. 在phpmyadmin資料夾底下,開啟config.inc.php

2. 找到 /* Servers configuration */

3. 加入以下的編碼:

$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = '<127.0.0.1>';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

4. 然後之後用原本的root帳號登入後就可以看到旁邊多了個下拉選項讓你選擇server 

Contact

Github

Codepen

歡迎參觀我的賣場
© 2013 Copyright Digishot Web | Design Tools
Visitors【622436】
digishot webdesign studio