SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru kgtrip's Avatar
    Join Date
    Jun 2003
    Location
    Karplakistan
    Posts
    804
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    access MySql on server from local machine?

    hi there,

    I wanna my scripts running on my local machine could access the remote MySql DB, how can I do it?
    Compare Hundreds of Web Hosting Plans

  2. #2
    ********* wombat firepages's Avatar
    Join Date
    Jul 2000
    Location
    Perth Australia
    Posts
    1,717
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you would need extended (GRANT ?) priviledges to get into the mysql DB and edit the mysql hosts table , that said you can then give your (hopefully static) IP privileges on the server, or ask your host nicely!

  3. #3
    SitePoint Guru kgtrip's Avatar
    Join Date
    Jun 2003
    Location
    Karplakistan
    Posts
    804
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok I can do that,

    but how can I refer the DB from my local php scripts

    how do I tell the php on the local machine to go to a DB that is on "http://www.mysite.com/" and work with the server over there?
    Compare Hundreds of Web Hosting Plans

  4. #4
    SitePoint Member
    Join Date
    Oct 2001
    Location
    United Kingdom
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    just set your host to www.myhost.com instead of localhost

  5. #5
    SitePoint Guru kgtrip's Avatar
    Join Date
    Jun 2003
    Location
    Karplakistan
    Posts
    804
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by rw22
    just set your host to www.myhost.com instead of localhost
    GREAT haven't thought about it

    Thanks...
    Compare Hundreds of Web Hosting Plans


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
  •