site from a host connect to db from another host

Discussion in 'Databases' started by radeon011, Mar 28, 2011.

0
  1. #1
    Hello,
    Who can help me with one thing...
    I have a server (Mu Online) on my PC , my server use sql2000 and what i want to do is :

    My site from HOST A to connect to db from my server from HOST B

    My site have the config.php file like this:

    <?php
    error_reporting(E_ALL ^E_NOTICE ^E_WARNING);

    $host = "127.0.0.1";
    $database = "MuOnline";
    $user = "sa";
    $password = "pword";
    require("includes/connect.php");

    $ip = "85.204.46.43";
    $port = "55901";
    $port_cs = "55919";
    $port_vip = "55921";
    ?>
    The 3306 port is open
    I put the IP from the server host there and everything is white when I refresh the site
    Thanks
     
    Last edited: Mar 28, 2011
    radeon011, Mar 28, 2011 IP
  2. radeon011

    radeon011 Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    sql2000 allow remote ?
     
    radeon011, Mar 29, 2011 IP
  3. srisen2

    srisen2 Peon

    Messages:
    359
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    just make the host the host B IP

    $host = "127.0.0.1";

    this is local IP you need the real ip check your sites main domain on ipfunctions.com and use the host to ip tool
     
    srisen2, Mar 31, 2011 IP