如何使用本地phpMyAdmin客户端访问远程服务器? [英] How to access remote server with local phpMyAdmin client?

问题描述

假设有一个远程服务器，并且我的计算机上本地安装了phpMyAdmin客户端.如何访问该服务器并通过phpMyAdmin客户端进行管理?那可能吗?

解决方案

只需将以下几行添加到底部的/etc/phpmyadmin/config.inc.php文件中:

$i++;
$cfg['Servers'][$i]['host'] = 'HostName:port'; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = 'userName';   //user name for your remote server
$cfg['Servers'][$i]['password'] = 'Password';  //password
$cfg['Servers'][$i]['auth_type'] = 'config';       // keep it as config

.您将获得当前服务器:"下拉列表，同时显示"127.0.0.1"和服务器之间的"$ cfg ['Servers'] [$ i] ['host']"凸轮开关.

更多详细信息: http://sforsuresh.in/access-远程mysql服务器使用本地phpmyadmin/

Assuming there is a remote server and I have phpMyAdmin client installed localy on my computer. How can I access this server and manage it via phpMyAdmin client? Is that possible?

解决方案

Just add below lines to your /etc/phpmyadmin/config.inc.php file in the bottom:

$i++;
$cfg['Servers'][$i]['host'] = 'HostName:port'; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = 'userName';   //user name for your remote server
$cfg['Servers'][$i]['password'] = 'Password';  //password
$cfg['Servers'][$i]['auth_type'] = 'config';       // keep it as config

. You will get "Current Server:" drop down with both "127.0.0.1" and one what you have provided with "$cfg['Servers'][$i]['host']" cam switch between the servers.

more Details: http://sforsuresh.in/access-remote-mysql-server-using-local-phpmyadmin/

这篇关于如何使用本地phpMyAdmin客户端访问远程服务器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！