开启phpmyadmin多服务器管理

来源：互联网发布：蚊子是宠物知乎编辑：程序博客网时间：2024/05/09 13:19

VM155:/opt/lampp/htdocs # tar zxvf /home/userSoft/phpMyAdmin-3.4.3.1-all-languages.tar.gz

VM155:/opt/lampp/htdocs # mv phpMyAdmin-3.4.3.1-all-languages/ dm

VM155:/opt/lampp/htdocs # vim dm/libraries/config.default.php

将

$cfg['AllowArbitraryServer'] = false;

改为

$cfg['AllowArbitraryServer'] = true;

VM155:/opt/lampp/htdocs # cp dm/config.sample.inc.php dm/config.inc.php

VM155:/opt/lampp/htdocs # vim dm/config.inc.php

修改下面信息

$cfg['blowfish_secret'] = ‘xxx’;

/* Storage database and tables */

$cfg['Servers'][$i]['pmadb'] = ‘phpmyadmin’;

$cfg['Servers'][$i]['bookmarktable'] = ‘pma_bookmark’;

$cfg['Servers'][$i]['relation'] = ‘pma_relation’;

$cfg['Servers'][$i]['table_info'] = ‘pma_table_info’;

$cfg['Servers'][$i]['table_coords'] = ‘pma_table_coords’;

$cfg['Servers'][$i]['pdf_pages'] = ‘pma_pdf_pages’;

$cfg['Servers'][$i]['column_info'] = ‘pma_column_info’;

$cfg['Servers'][$i]['history'] = ‘pma_history’;

$cfg['Servers'][$i]['tracking'] = ‘pma_tracking’;

$cfg['Servers'][$i]['designer_coords'] = ‘pma_designer_coords’;

$cfg['Servers'][$i]['userconfig'] = ‘pma_userconfig’;

在浏览器中输入http://192.168.194.159/dm