如何使用本地phmyadmin客户端访问远程服务器?
16lz
2021-01-22
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?
假设有一个远程服务器，并且我在我的计算机上安装了phpadmin myclient。如何访问此服务器并通过phpMyAdmin客户机管理它?这有可能吗?
11 个解决方案
#1
113
Just add below lines to your “config.inc.php” file in the bottom:
只需在“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
. 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.
。您将获得“当前服务器”:“127.0.0.1”和您提供的“$cfg['Servers'][$i]['主机']['主机']”在服务器之间切换。
more Details: http://goo.gl/FZ6nqD
更多信息:http://goo.gl/FZ6nqD。
更多相关文章
- Docker：除非我手动重启，否则MySQL会拒绝主机IP
- MySQL SELECT INTO OUTFILE到不同的服务器？
- 无法连接到MySQL服务器
- XMPP环境搭建 (mac环境下 安装自己独立的mysql与服务器(openfire
- 远程服务器CentOS7安装MySQL并用本地Navicat连接
- 使用mysql和PHP从本地主机连接到远程数据库
- 如何将数据从MYsql服务器传输到iphone
- 阿里云服务器忘记mysql的登录密码时候如何修改密码
- 解决Linux主机上的 远程MySQL客户端无法连接的问题