#1
  1. No Profile Picture
    dbh
    Guest
    Devshed Newbie (0 - 499 posts)
    We've co-located two machines with our ISP. we would like to use one machine as the MySQL database server and the other machine as a web server. The web server would use PHP/Apache to request the data from the database server.

    Has anyone out there done something like this?

    Dave

  2. #2
  3. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    Sure, that is definately possible.

    You just need to make sure that MySQL's permissions are setup to allow connections from the other computer, and when you do a mysql_connect you put the mysql servers's adrress in rather than localhost.

    Hope that helps.
  4. #3
  5. No Profile Picture
    dbh
    Guest
    Devshed Newbie (0 - 499 posts)
    Thanks. I'll try it.
  6. #4
  7. No Profile Picture
    cybernaut
    Guest
    Devshed Newbie (0 - 499 posts)
    It works well across the Internet as well
    I recently setup queries to servers at remote property locations (other states) using the method above and the Internet for a backbone.

Similar Threads

  1. mysql connection
    By cindyqz in forum Java Help
    Replies: 0
    Last Post: August 25th, 2003, 07:33 PM
  2. mysql database help!
    By TweetyPie in forum MySQL Help
    Replies: 2
    Last Post: August 1st, 2003, 06:20 AM
  3. How to update MYSQL from multi row form
    By direwolf in forum PHP Development
    Replies: 7
    Last Post: July 22nd, 2002, 06:05 PM
  4. Converting multi pass SP to MySQL
    By kyle in forum MySQL Help
    Replies: 1
    Last Post: November 7th, 2001, 06:50 PM
  5. Update multi entries to mysql
    By myangel in forum MySQL Help
    Replies: 4
    Last Post: April 13th, 2001, 06:16 AM

IMN logo majestic logo threadwatch logo seochat tools logo