How do i connect to a remote mysql database from a local computer, Maybe using IP

Discussion in 'MySQL' started by webdezzi, Jul 18, 2007.

0
  1. #1
    i need help with connecting to mysql database from a local computer to my hosting account's database. I need this feature so that i can extract data from my remote server as the data comes in, i intend to write a php script which will reside on the local computer and if refreshed, updates the local database with fresh records from the server.

    I think i shud be doing this using My Domain IP or Hostname(www.com) instead of the usual Localhost but its just not working.

    and if there is a better way to accomplish this task, Pls let me know about it. Thanks, I will hang around for a while , hope to get response today.
     
    webdezzi, Jul 18, 2007 IP
  2. Thibaut

    Thibaut Well-Known Member

    Messages:
    886
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    140
    #2
    Hello,

    You're using the good way, but you should first check if you allow the client to connect to the server. Also don't forget to open your TCP port.
    Some details: http://help.hardhathosting.com/question.php/87

    Cheers !
    Thibaut
     
    Thibaut, Jul 18, 2007 IP
  3. unitedlocalbands

    unitedlocalbands Well-Known Member

    Messages:
    246
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    128
    #3
    You can use SQL Server 2000 Enterprise Edition.
     
    unitedlocalbands, Jul 26, 2007 IP
  4. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #4
    you need to GRANT access to your DB. Go into your account admin panel and check there.
    You have to find your IP first, check to see if is behind a router or firewall, then set that IP in your panel.
     
    gibex, Jul 28, 2007 IP
  5. Spartan_Strategy

    Spartan_Strategy Peon

    Messages:
    197
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #5
    The most often missed step in making a MySQL connection is installing the MySQL driver for ODBC on your local PC. You will need to setup a DSN on the server. Data Source Name.

    MySQL ODBC drivers allow you to connect to MySQL running on your Virtual Private Servers and import/export databases to and from your own PC.

    MySQL Connector/ODBC 3.51 Downloads
    http://dev.mysql.com/downloads/connector/odbc/

    If using Access to connect to remote MySQL.
    http://www.gsp.com/support/virtual/mysql/odbc/
     
    Spartan_Strategy, Jul 28, 2007 IP