connecting to a database on diff server

Discussion in 'MySQL' started by netpox, Jan 29, 2007.

0
  1. #1
    One of my databases is on a server where my config file says the server is localhost. How do i connect to it from a different server.
     
    netpox, Jan 29, 2007 IP
  2. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #2
    In Cpanel - > Under MySQL -> At the very bottom there is a list of access hosts. Add the IP you wish to connect from to the list.
    When you connect from the other server simply add the IP you with to connect to instead of localhost.
     
    maiahost, Jan 29, 2007 IP
    daboss likes this.
  3. netpox

    netpox Active Member

    Messages:
    1,625
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    90
    #3
    thanks i'll give it a try
     
    netpox, Jan 30, 2007 IP
  4. Kalyse

    Kalyse Peon

    Messages:
    1,221
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Wow, is it really that predictable that everyone uses cPanel?

    I really dislike it.

    I dont get why its so popular.

    I switched immediately to Plesk once I used it. Its much nicer for UI and functionality is easier.

    This is the only function in Plesk that isnt available. Ironic :)

    I wonder why.
     
    Kalyse, Jan 31, 2007 IP
  5. eralper

    eralper Peon

    Messages:
    38
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If the server is on that computer (localhost), you can connect from another server by referencing the server's name or ip

    Eralper
     
    eralper, Jan 31, 2007 IP
  6. FFMG

    FFMG Well-Known Member

    Messages:
    1,091
    Likes Received:
    39
    Best Answers:
    0
    Trophy Points:
    160
    #6
    No you cannot, you need to configure MySQL to accept incoming connections from sites other than 'localhost'.

    FFMG
     
    FFMG, Feb 1, 2007 IP
    daboss likes this.
  7. Neptune

    Neptune Well-Known Member

    Messages:
    1,465
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    108
    #7
    Correct. In order for MySQL to recognize your computer or other server, it needs to be added to the allowed ip's. If it is not, it will deny you access.
     
    Neptune, Feb 1, 2007 IP
    daboss likes this.
  8. Azfar

    Azfar Peon

    Messages:
    575
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I have done that but the sad thing is this what come out ---> Your PHP installation appears to be missing the MySQL extension which is required by WordPress.



    --Azfar
     
    Azfar, Dec 20, 2008 IP
  9. indiglo

    indiglo Active Member

    Messages:
    108
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #9
    According to me, Just close all the things and Try using Servlet, JSP and oracle 9i, It provides you security, ease (If you have great coding skills) and a rock solid hacker proof site.

    Thank you.
     
    indiglo, Jan 15, 2009 IP