php - 从远程托管服务器加载数据库: phpmyadmin

Question

我有一个项目的离线版本，并且同一项目在线更新了大量数据库记录，我想从本地主机访问服务器上托管的数据库，并且我尝试这样做:

No 1:

<?php

// mysql_connect('localhost', 'root', '');
// mysql_select_db('eghtml5_XXXX');
$dbserver="http://96.127.132.74:xxxx";


$username="xxxxx";
$password="xxxxx";

// $username="root";
// $password="";
$dbname="database_name";
$connection=mysql_connect("$dbserver","$username","$password")or die("could not     connect to the server");

mysql_select_db($dbname, $connection) or die("Error here");
mysql_query("SET NAMES utf8;");

mysql_query("SET CHARACTER_SET utf8;");
?>

另一个尝试将此配置附加到本地主机的 php.ini

$i++;
$cfg['Servers'][$i]['host']          = '96.127.132.74';
$cfg['Servers'][$i]['port']          = 'XXXX';
$cfg['Servers'][$i]['socket']        = '';
$cfg['Servers'][$i]['connect_type']  = 'tcp';
$cfg['Servers'][$i]['extension']     = 'mysql';
$cfg['Servers'][$i]['compress']      = FALSE;
$cfg['Servers'][$i]['auth_type']     = 'config';
$cfg['Servers'][$i]['user']          = 'xxxx';
$cfg['Servers'][$i]['password']      = 'ْْxxxx';

这两种方法都不适合我!

Answer 1

检查是否允许您尝试登录的用户从非“localhost”或在线服务器 IP 的位置进行连接。

并且您必须检查端口 3306(MySQL STD 端口)是否开放以从外部连接(可能是安全问题)