SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Evangelist Mr. Tech's Avatar
    Join Date
    Feb 2003
    Location
    Australia
    Posts
    562
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Connecting to remote MySQL Database with CPanel

    Is it possible for a remote server or even another account on the same server to access the MySQL Database of an account?

    The reason I ask this is a I have a client who wants to set-up a second website but wants to pull a lot of the data from his existing website which is in a MySQL Database.

    How would I go about doing this?

  2. #2
    SitePoint Enthusiast
    Join Date
    Nov 2008
    Posts
    56
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yes it possible.

    you can do this in tow ways.

    1. you can make data base connection through Cpanel to remote DB
    2. you can make data base connection directly to your desired remote DB by connection script

    i am not sure either those information enough or not.

  3. #3
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    this is only possible if the host where the DB is allows it. many web hosts do not.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  4. #4
    SitePoint Wizard bronze trophy Kailash Badu's Avatar
    Join Date
    Nov 2005
    Posts
    2,561
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    My host, hostgator, allows you to specify (in cPanel) the remote host from where you want to connect with the database. As longneck said, it's upto the host to allow or disallow it. Just reach out to their support and ask them.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •