Results 1 to 5 of 5
  1. #1

    Configure your script to use remote MySQL host?

    I sent in a ticket asking my hosting provider how I would be able to upload config files with the DB info of my VPS MySQL, and still haev all the correct tables showing up.

    On my VPS I'm hosting a private server, so I use a program called Navicat to edit stuff in the MySQL database, and site files to htdocs in XAMPP, files you can view by going to

    Now, the all the files I upload to that IP site have the VPS MySQL info in it(DB name, username, pass, host) so they're all connected to the MySQL (the register page, ranking page, and UserCP).

    If I upload those files to my .net site via FTP, it shows up all messed because in the config files, the database isn't matching my actual .net database, so it doesn't show up properly (this is expected).

    I contacted my hosting provider asking if I could do this, and if it would put stress on the server, and they said no, you just need to 'configure your script to use remote mysql host'.

    Then I asked they how, and they pointed my towards

    Can anyone here tell me how I can make it so if I upload files with the info in config.php matching my VPS MySQL database?

    For examples of my pages:

    But, I'd like those to be:

    I've done it with the UserCP before, but I had to point my name servers towards my VPS's, and according to my hosting provider it ended up messing my site (only certain people can view it... not even I can).

    So, I need to know how to 'configure your script to use remote mysql host' so I can upload the same config files in XAMPP to my FTP and still have them connected.



  2. #2
    Join Date
    Apr 2005
    The remote access to the mysql must be enabled first. Once done, simply change your host Ip to the VPS server and it would be connected .

    You can have your technical guys check this manually from the web server to make sure remote connection is actually working
    Sam - Expertise in Windows/Linux server support, IaaS and PaaS Management - Custom Software Development
    Email: exec @ | Skype: unni_active

  3. #3
    Join Date
    Jul 2007
    If you are using cPanel then go to cPanel >> Remote Host section there you can add your mysql server ip in Access list.

    Once that is done, In config file add your host value as mysql server ip and rest database details thats it.

  4. #4
    Join Date
    Jul 2009
    Yes I agree if cPanel server then need to add in cPanel > mysql remote host and then it will work.By default it will not allow remote connections.

  5. #5
    Join Date
    Aug 2009
    Remote MySQL access is a combination of username, password, and host location. You need to be sure that your username is allowed to access MySQL from the remote IP of your web server.

Similar Threads

  1. Configure remote domains in exim
    By Tomcatf14 in forum Hosting Security and Technology
    Replies: 4
    Last Post: 11-04-2008, 03:51 PM
  2. looking for a good remote mysql host
    By berlin in forum VPS Hosting
    Replies: 2
    Last Post: 04-24-2008, 02:11 PM
  3. remote mysql hosting script
    By Jikson26 in forum Programming Discussion
    Replies: 2
    Last Post: 04-18-2004, 04:09 AM
  4. Secure Remote Mysql Database Host
    By myadhan in forum Web Hosting
    Replies: 0
    Last Post: 10-30-2001, 08:05 AM

Posting Permissions

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