Simple help need: WP Database from different Server

Discussion in 'Databases' started by Monica Owen, Nov 3, 2009.

  1. #1
    I would like to have domain and files from one server and only the wordpress database from another server.

    When I changed the wp-config.php with Database username and password.
    It showing error establishing the database.

    What should I put in Host Name: instead of "localhost" ?


    Please help me.

    Regards,
    Owen
     
    Monica Owen, Nov 3, 2009 IP
  2. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #2
    u created a new db in new host ? u need to import that db to new host first

    also u need to update user , database name , password in wp-config.php no need to change localhost
     
    chandan123, Nov 3, 2009 IP
  3. Monica Owen

    Monica Owen Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    no, I would like to run the database from different server. Instead of local host I tested with my IP of the existing database server. That too showing error.
     
    Monica Owen, Nov 3, 2009 IP
  4. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #4
    some hosts block access db via ips so u need to look permissions first
     
    chandan123, Nov 3, 2009 IP
  5. Monica Owen

    Monica Owen Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    How to check that ? Should I ask our hosts to enable that permission, or can we check from cpanel ?
     
    Monica Owen, Nov 3, 2009 IP
  6. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #6
    i think in cpanel db link u can see i remember such option because i was trying to add access from other hosts for db last time
     
    chandan123, Nov 3, 2009 IP
  7. Monica Owen

    Monica Owen Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    When we create USER for database, we'll give all access for the user. But I'm not sure how this will work for other server access. Let me ask our hosts.
     
    Monica Owen, Nov 3, 2009 IP
  8. leprakhauns

    leprakhauns Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Your going to need to allow offsite connections going to your MySQL database.
     
    leprakhauns, Nov 3, 2009 IP
  9. kacangijo

    kacangijo Peon

    Messages:
    475
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #9
    I think you should consult this to your hosting support. Not all hosting allow this kind of tricks
     
    kacangijo, Nov 3, 2009 IP
  10. Nevo

    Nevo Peon

    Messages:
    24
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    You have to config cPanel (if your using linux) to allow Remote MYSQL.


    Just a question, but why would you want a WP DB to be 3rd Party... Its so small, why not have it on the hosting where the site is hosted?
     
    Nevo, Nov 4, 2009 IP
  11. Monica Owen

    Monica Owen Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    i wanted to have a Big database of files for all my websites in a single space.

    I did that, and received Error establishing the Database. I contacted HostGator Hosting support, they also couldn't find any solution :(
     
    Monica Owen, Nov 5, 2009 IP