Connecting from one server to mysql on another server

Discussion in 'Apache' started by netpox, Feb 4, 2007.

0
  1. #1
    I have my database on a dedicated server where in the config i usually just put localhost for the hostname, now the website is on on a shared hosting plan and i need to connect it to that database thats on my dedicated server. What do i put in the hostname now?
     
    netpox, Feb 4, 2007 IP
  2. scdc

    scdc Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Instead of localhost you should put IP address or FQDN of that dedicated server
     
    scdc, Feb 4, 2007 IP
  3. koolasia

    koolasia Banned

    Messages:
    1,413
    Likes Received:
    59
    Best Answers:
    0
    Trophy Points:
    0
    #3
    First You Have To Allow The Other Server To Connect i think it can be done via cpanel

    than change the localhost and put the address of the mysql server there instead
     
    koolasia, Feb 4, 2007 IP
  4. lookzovt

    lookzovt Peon

    Messages:
    38
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    You have to check:
    1. /etc/my.cnf (skip-networking)
    2. Firewall (port 3306)
    3. Privilages on MySQL (can be different from localhost and others)
     
    lookzovt, Feb 4, 2007 IP
  5. netpox

    netpox Active Member

    Messages:
    1,625
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    90
    #5
    I am still confused. I am in cpanel...where do i go now...can someone give me step by step instructions on how to do this...thanks.
     
    netpox, Feb 27, 2007 IP