SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    E-business guru Eirik's Avatar
    Join Date
    Nov 2000
    Location
    Oslo, Norway
    Posts
    413
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL connection to another server

    Hi,

    For testing purposes, I want the PHP scripts at my site to connect to the mysql engine located at my local computer. I've tried inserting my computers IP address in stead of localhost in the mysql_connection function call, but that doesn't do it.

    I've heard something about having to alter the mysql.db to accomplish this, but I don't know where to alter, and what to alter to.

    Any insight is greatly appreciated !
    Sincerely,

    Eirik Johansen
    Netmaking AS

  2. #2
    SitePoint Wizard gold trophysilver trophy
    Join Date
    Nov 2000
    Location
    Switzerland
    Posts
    2,479
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Your right - you will need to make updates to MySQLs permissions on the remote db. MySQL distinguishes between local users, on the same machine, and remote users.

    It's all best explained in this article.

  3. #3
    SitePoint Evangelist galt's Avatar
    Join Date
    Apr 2002
    Posts
    461
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You may also find a useful tidbit in the footnote to this article.

    http://www.udzone.com/go?1221


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
  •