phpMyAdmin无法从Linux客户端连接到Windows 7上的远程服务器 [英] phpMyAdmin can't connect to remote sever on Windows 7 from Linux client

问题描述

我无法从Linux计算机上的phpMyAdmin连接到Windows 7上的mysql服务器.

I cannot connect to mysql server on Windows 7 from my phpMyAdmin on Linux machine.

我已经通过修改common.inc.php配置了phpMyAdmin. 我在common.inc.php的底部添加了以下几行:

I've configured phpMyAdmin by modifying common.inc.php. I've added at the bottom of common.inc.php the following lines:

$i=2;
$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
$i++;

我看到列出了远程服务器的下拉菜单，但是当我选择一个远程服务器phphMyAdmin返回到本地主机，并且没有错误消息它不会连接到远程服务器.

I see a drop down menu with remote server listed, but when I selected a remote server phphMyAdmin returns to localhost and it doesn't connect to remote without error messages.

使用mysql命令连接到远程数据库服务器，并使用相同的用户名/密码，我可以成功连接到数据库服务器.

Using mysql command to connect to the remote database server and using the same user/password, I can successfully connect to the database server.

版本为:

PHP 5.4.16 Development Server
phpMyAdmin 4.4.15.10
MySQL 5.6.32 - MySQL Community Server (GPL)

请求是从帖子发起的 配置时来自phmpMyAdmin的错误为了使用本地phpMyAdmin客户端访问远程服务器 我在其中输入了有关phpMyAdmin的配置的请求

The request is initiated from the post Error from phmpMyAdmin when is configured in order to access remote server with local phpMyAdmin client where I have entered a request regarding the configuration of phpMyAdmin

推荐答案

您可以通过在phpmyadmin配置文件中添加代码块来访问远程服务器...

You can access the remote server by adding a block of code in your phpmyadmin config file...

$i++;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = '';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

尝试

这篇关于phpMyAdmin无法从Linux客户端连接到Windows 7上的远程服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！