37 users online (1 members and 36 guests)  


  Results 1 to 9 of 9

Related

  1. How to connect to database mysql    Forum: Databases
    Replies: 1
  2. i can connect, but i can't do anything    Forum: Databases
    Replies: 2
  3. MySQL remote access?    Forum: Web Hosting Forum
    Replies: 6
  1. #1
    ibrahim's Avatar
    New User

    Status
    Offline
    Join Date
    May 2005
    Posts
    1

    remote connect to Mysql

    When I asked the hosting company about connecting to Mysql from my machine they told me to connect via phpmyadmin from the cpanel. But what I want is to connect via my machine, so how can I do that. For example by using Mysql-Front app.. Thank you.

  2. #2
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662

    Re: remote connect to Mysql

    Hi, welcome to the forums.

    You can do this, but only if mySQL is configured to accept remote connections. Back to your host to ask this, I would say.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  3. #3
    Flaggster's Avatar
    New User

    Status
    Offline
    Join Date
    Aug 2005
    Posts
    2

    Re: remote connect to Mysql

    There is a piece of software, called PHPMaker, http://www.hkvstore.com/phpmaker/

    This software will allow you to connect remotely to the sql server remotely - its a bit of a kludge, but it works for me

  4. #4
    vinyl-junkie's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    721

    Re: remote connect to Mysql

    It really doesn't matter what software you use, so long as your web host allows remote access (and you've set the connection parameters correctly). QuietDean is right. Check with your web host first.

  5. #5
    DeadMeatGF's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    381

    Re: remote connect to Mysql

    It is very likely that your host blocks remote database access for security reasons - I know mine do, and it's the one thing they absolutely will not budge on

  6. #6
    loanskey's Avatar
    New User

    Status
    Offline
    Join Date
    Apr 2006
    Posts
    11

    Re: remote connect to Mysql

    put this sign "%" or your IP in the remote mysql login allow list in your websites control panel

    in cpanel that can be done in the database page at the footer.

    Ravish Kumar
    Last edited by HTML; 09-08-2006 at 06:24 AM.

  7. #7
    Kirtie's Avatar
    New User

    Status
    Offline
    Join Date
    Sep 2006
    Location
    Fargo, ND USA
    Posts
    6

    Re: remote connect to Mysql

    Hello-
    I'm afraid that if you are using a virtual server with your web hosting company, the previous post was correct: I seriously doubt you'll gain remote access to your MySQL server.
    One option is to get hosting on a dedicated server, which would fix this problem, but it's generally $$$.
    Wish I had a better response for you-
    Kirtie

  8. #8
    Flaggster's Avatar
    New User

    Status
    Offline
    Join Date
    Aug 2005
    Posts
    2

    Re: remote connect to Mysql

    there is a hosting company Fasthosts, that allow remote connection to their MySQL servers. Their MySQL servers are seperate from their web servers.

    http://www.fasthosts.com

  9. #9
    DeadMeatGF's Avatar
    Moderator

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    381

    Re: remote connect to Mysql

    Quote Originally Posted by Flaggster
    there is a hosting company Fasthosts, that allow remote connection to their MySQL servers. Their MySQL servers are seperate from their web servers.

    http://www.fasthosts.com
    I bought my domain names from them, and can recommend their customer service, but I read that they were compromised recently, so before taking on remote SQL access you might want to quiz them on their security procedures.



Tags for this Thread