1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Hey all,
    I was wondering something. Ok, heres the scenario. My host is 1.) fixing to change and 2.) the new one might not let me use their mySQL server. so heres the question. If i have a friend that has a host that lets him use mySQL is it at all possible to connect to his mySQl server from my server? I am going to look into this further my self(have a little already) so i might figure it out b4 i get a reply but thank you.

  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Hey, that's no problem.

    Right now I have a host running MySQL at work and can access it thru ODBC from home. I can run an Access application, or access it from my Linux server at home.

    What's important is your security settings in MySQL. Be sure to read the security portion of the manual. There are some pretty good examples of setting priviledges.

    Normally the default MySQL installation is setup for access only from the local host. You will need to add a new user that can access the database(s) from any host, or a specific host.
  4. #3
  5. No Profile Picture
    Devshed Newbie (0 - 499 posts)

    lets see, ok, if i get my friend to ask his admin to do this what would be the syntax to tell my PHP3 script to connect to his server and stuff?

    thank you very much.
  6. #4
  7. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Ahh the beauty of TCP/IP - it doesn't care where the assorted parts are located.

    All you gotta do is change the parameters of your 'mysql_connect' statement:

    mysql_connect("<your friend's hostname or IP", "<login name set up for you>", "<login password>");

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. mysql connect issue
    By slen in forum MySQL Help
    Replies: 1
    Last Post: February 17th, 2004, 04:33 AM
  3. Replies: 1
    Last Post: February 5th, 2004, 12:50 AM
  4. how to connect the oracle server
    By arihandro in forum Oracle Development
    Replies: 1
    Last Post: February 4th, 2004, 09:30 AM
  5. From Access to remote MySQL
    By TimMatthews in forum Database Management
    Replies: 0
    Last Post: February 3rd, 2004, 10:54 AM

IMN logo majestic logo threadwatch logo seochat tools logo