当前位置：文江博客话题详情

使用 phpMyAdmin 连接到外部服务器

发布于 2024-08-11 03:55:10 字数 43 浏览 3 评论 0原文

我在本地计算机上安装了 phpMyAdmin。如何让它连接到外部服务器？

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

活泼老夫 2024-08-18 03:55:10

在配置文件中，将“host”变量更改为指向外部服务器。配置文件名为 config.inc.php，位于 phpMyAdmin 主文件夹中。应该有这样一行：

$cfg['Servers'][$i]['host'] = 'localhost';

只需将 localhost 更改为您服务器的 IP 地址。

注意：您可能必须配置外部服务器以允许远程连接，但我已经在共享主机上这样做了几次，所以应该没问题。

In the config file, change the "host" variable to point to the external server. The config file is called config.inc.php and it will be in the main phpMyAdmin folder. There should be a line like this:

$cfg['Servers'][$i]['host'] = 'localhost';

Just change localhost to your server's IP address.

Note: you may have to configure the external server to allow remote connections, but I've done this several times on shared hosting so it should be fine.

回复收藏 0 原文

朮生 2024-08-18 03:55:10

要设置外部数据库并仍然使用本地数据库，您需要编辑 config.inc.php 文件：

On Ubuntu: sudo gedit /etc/phpmyadmin/config.inc.php

该文件大致设置如下：

if (!empty($dbname)) {

    //Your local db setup

     $i++;
}

您需要做的是通过复制来复制“您的本地数据库设置”并将其粘贴到我在下面的代码中显示的 IF 语句的外部，并将主机更改为您的外部 IP。我的例子是：

$cfg['Servers'][$i]['host'] = '10.10.1.90:23306';

您可以保留默认值（除非您知道需要更改它们）

保存并刷新您的 PHPMYADMIN 登录页面，然后应该会出现一个新的下拉列表。你应该可以走了。

编辑：如果您想为服务器指定一个名称以在登录页面选择，而不仅仅是选择 IP 地址，请将其添加到服务器设置中：

$cfg['Servers'][$i]['verbose'] = 'Name to show when selecting your server';

如果您有多个服务器配置，那就太好了。

To set up an external DB and still use your local DB, you need to edit the config.inc.php file:

On Ubuntu: sudo gedit /etc/phpmyadmin/config.inc.php

The file is roughly set up like this:

if (!empty($dbname)) {

    //Your local db setup

     $i++;
}

What you need to do is duplicate the "your local db setup" by copying and pasting it outside of the IF statement I've shown in the code below, and change the host to you external IP. Mine for example is:

$cfg['Servers'][$i]['host'] = '10.10.1.90:23306';

You can leave the defaults (unless you know you need to change them)

Save and refresh your PHPMYADMIN login page and a new dropdown should appear. You should be good to go.

EDIT: if you want to give the server a name to select at login page, rather than having just the IP address to select, add this to the server setup:

$cfg['Servers'][$i]['verbose'] = 'Name to show when selecting your server';

It's good if you have multiple server configs.

回复收藏 0 原文

遗弃Ｍ 2024-08-18 03:55:10

使用 PhpMyAdmin 版本 4.5.4.1deb2ubuntu2，您可以在 /etc/phpmyadmin/config-db.php 中设置变量，

因此将 $dbserver 设置为您的服务器名称，例如 $dbserver='mysql.example.com';

<?php
##
## database access settings in php format
## automatically generated from /etc/dbconfig-common/phpmyadmin.conf
## by /usr/sbin/dbconfig-generate-include
##
## by default this file is managed via ucf, so you shouldn't have to
## worry about manual changes being silently discarded.  *however*,
## you'll probably also want to edit the configuration file mentioned
## above too.
##
$dbuser='phpmyadmin';
$dbpass='P@55w0rd';
$basepath='';
$dbname='phpmyadmin';
$dbserver='localhost';
$dbport='';
$dbtype='mysql';

using PhpMyAdmin version 4.5.4.1deb2ubuntu2, you can set the variables in /etc/phpmyadmin/config-db.php

so set $dbserver to your server name, e.g. $dbserver='mysql.example.com';

<?php
##
## database access settings in php format
## automatically generated from /etc/dbconfig-common/phpmyadmin.conf
## by /usr/sbin/dbconfig-generate-include
##
## by default this file is managed via ucf, so you shouldn't have to
## worry about manual changes being silently discarded.  *however*,
## you'll probably also want to edit the configuration file mentioned
## above too.
##
$dbuser='phpmyadmin';
$dbpass='P@55w0rd';
$basepath='';
$dbname='phpmyadmin';
$dbserver='localhost';
$dbport='';
$dbtype='mysql';

回复收藏 0 原文

紫竹語嫣☆ 2024-08-18 03:55:10

在4.0或以上版本，我们需要创建一个'config.inc.php'或将'config.sample.inc.php'重命名为'config.inc.php'；

就我而言，我还为每个环境（开发和生产）使用一台 mysql 服务器：

/* others code*/  
$whoIam = gethostname();
switch($whoIam) {
    case 'devHost':
        $cfg['Servers'][$i]['host'] = 'localhost';
        break;
    case 'MasterServer':
        $cfg['Servers'][$i]['host'] = 'masterMysqlServer';
        break;
} /* others code*/

at version 4.0 or above, we need to create one 'config.inc.php' or rename the 'config.sample.inc.php' to 'config.inc.php';

In my case, I also work with one mysql server for each environment (dev and production):

/* others code*/  
$whoIam = gethostname();
switch($whoIam) {
    case 'devHost':
        $cfg['Servers'][$i]['host'] = 'localhost';
        break;
    case 'MasterServer':
        $cfg['Servers'][$i]['host'] = 'masterMysqlServer';
        break;
} /* others code*/

回复收藏 0 原文