Remote MYSQL HELP

Discussion in 'MySQL' started by black.hat, Mar 18, 2009.

0
  1. #1
    I have an script that installed on two servers
    i just use one of them to update my site,
    If there is a programmer here that can tell me how i can remote the mysql from the first server to the second server?

    for example in first server there is an file called config.php that included the mysql details

    i just want to add a remote address for second mysql server
    so the script can connect to my other site and get the sql information

    thanks
     
    black.hat, Mar 18, 2009 IP
  2. MayurGondaliya

    MayurGondaliya Well-Known Member

    Messages:
    1,233
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    170
    #2
    - You need to provide the mysql server host name or IP address to connect to the remote mysql server.

    - Your mysql server must allow the remote TCP connections from your web server.

    - You can add the remote allow IP from the cpanel.
     
    MayurGondaliya, Mar 19, 2009 IP