SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Jun 2004
    Location
    adfs
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Sharing Databases?

    I have a current site that uses an SQL database, and I would like to make another site that connected to this same database, I enter the IP of where the database is, but it still wont function

    $mysql_host = "66.45.23x.xx";

    Of course the x's are numbers

    when it gets to my site it shows this

    [1045] dbconn: mysql_connect: Access denied for user: 'b21s@osaka.clanch.net' (Using password: YES)

    osaka.clanch.net is the current server, i dont know why its doing that when i set it to 66.45.23x.xx

  2. #2
    SitePoint Enthusiast
    Join Date
    May 2004
    Posts
    87
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I believe most webhosts do not allow for remote connection to their databases. This would mean that all queries inbound from anywhere else then their own server would be denied.
    However, it might be that someone else has a solution to this.

  3. #3
    SitePoint Enthusiast Cinders117's Avatar
    Join Date
    Apr 2003
    Location
    Kent, OHio
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I share a database between 2 sites. We use the domain name instead of localhost to connect though and it works fine.

    I did have to add the non-local host to an ok list of Access Hosts before it would work. That was done through the MySQL part of the cPanel. Maybe you have to do something similar?
    ~Rebecca

  4. #4
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Claymore is spot on. Make sure remote connections are allowed before trying to conect remotely.

    Aaron
    Aaron Brazell
    Technosailor




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
  •