Connect to remote database using Localhost install

I think s_ha_dum is in the right track, but I think he got it backwards.

You want to:

  1. develop/design locally
  2. connect to the REMOTE database and work with his content?

You need a remote (staging) installation of WordPress, where the client can create/enter his content.

You need your local WordPress site (localhost) to point to the remote database, to grab the content he is using.

So, you would have your http://example.com/wordpress set up for the client to edit – just even with a vanilla WP install. This site would be connected to it’s own database.

Your localhost site would have the REMOTE site’s database credentials, with the DB_HOST set to http://example.com, or whatever the mySQL path is if it’s accessed another way through your hosting provider.

On your local site, keep the WP_SITEURL and WP_HOME set to localhost. Otherwise, you’ll get redirection loops.

Related Posts:

  1. Connect to live db whilst working locally
  2. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  3. Search and Replace in Windows XAMPP site
  4. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  5. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  6. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  7. Best way to move live site local
  8. Why can’t I swap a DB in a WP install? [closed]
  9. Import live site to local setup without access to live site
  10. Moving online website to MAMP or dumb idea?
  11. Moving minor updates between local and live sites – just database?
  12. Connect to a remote database for wordpress in my own hosting server
  13. Difficulty importing my live site to local
  14. Problem migrating to localhost
  15. Design problems when exporting remote database for local development
  16. How to transfer from localHost to live but use the already existing database on the server?
  17. Installing local to live WP into subdirectory
  18. Database migration issues – Error #1046 No database selected
  19. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  20. Cloning blog to localhost via WAMP
  21. Recovery – Restore Database after moving folder location locally
  22. Cloned site not connecting to database – MAMP
  23. Locally installing wordpress. Database problem
  24. I have my full special database from xampp how can i use this on wordpress?
  25. Local Content different from Remote Content
  26. Check if a database is well installed
  27. How can I work on a database along side a client?
  28. Restoring .sql backup results in “Error establishing a database connection”
  29. Theme Options – localhost to new url
  30. Can I connect WordPress website with an external database?
  31. Connection refused on locahost after importing database?
  32. Setting up a local copy from a production site
  33. When to use custom DB tables or add_option?
  34. Have working sql query… trying to adjust it to use $wpdb
  35. Best host for running large mem and processor intensive WordPress sites?
  36. creating new field on mysql
  37. Does WordPress store the username as a primary key in the database?
  38. Strange characters added to the database
  39. $wpdb->query can’t insert data
  40. WSOD 3.9.1 – Tried Everything so far
  41. Database Update Required – Update from command-line
  42. Can you refresh ONLY the wordpress adminbar and not the whole page?
  43. Sending posts from Python to WordPress
  44. SQL query to set posts in bulk based on the post content
  45. Automate WordPress website setup with prefilled data
  46. How can I detect right db type?
  47. Add search bar to Custom Database Table in WordPress Dashboard
  48. Custom search query by category id
  49. How do you render posts from outside wordpress?
  50. Image link issues after importing a database backup to my local web server
  51. multiple wordpress installs w/shared user database but separate content databases
  52. A change in URL slug in database returns 404, how can I do auto-redirect?
  53. Second ezSQL initialization for MSSQL
  54. Fetch a single row from a custom table for to a given ID
  55. Database create or redirect
  56. Updating seperate database when post attachment is changed
  57. add featured image dialog box disappear
  58. Database structure cheatsheet
  59. White Screen in Home Page
  60. WordPress Database – wp_usermeta and the correct number of session_tokens rows
  61. Continuous SQL query errors from outside source
  62. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  63. How to get a list of articles related to a particular category from my other WordPress website?
  64. Migrate Users From laravel to wordpress
  65. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  66. how add more field to wp user and save it to database
  67. How do I cleanup my database with data that is no longer being used?
  68. Malware in old website – how to migrate?
  69. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  70. error establishing database connection (WAMP + filezilla)
  71. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  72. How do I update a WordPress wp_postmeta meta_value that contains many options
  73. How can I get $wpdb to show MySQL warnings?
  74. About wp database hooks (error establishing connection)
  75. How to display $wpdb->insert_id; value on redirected page
  76. Should I Use only wpdb Class to Write Custom Queries?
  77. Auto populate form fields based on serial input or pull listings from other websites?
  78. How to extract some part of WordPress full source code
  79. Create Tables in WordPress
  80. Error establishing a database connection for some files
  81. Hash user emails in database?
  82. WordPress Failed to Login (DB Error)
  83. Sending WordPress database information to cross domain the safe way?
  84. Database Name Change
  85. Weird characters in title if it contain “ ”
  86. Share WordPress Database
  87. Where To Find bb_profile_data(); In bbPress?
  88. DB access blocked when initializing WP externally
  89. Saving data to database and exporting to excel
  90. Site does not work right, pages not showing up, even for root admin
  91. One information repeated on multiple locations on one site [closed]
  92. WordPress: Interact with Database Query Data and Login
  93. Showing Error(TAble already exist)
  94. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  95. Cant Connect to Database
  96. WordPress database connection failed, while mysql client is working [closed]
  97. update_post_meta returns ID, but nothing in the database
  98. Configure WordPress to use MariaDB over SSL?
  99. Combining two select posts from mysql – to get least viewed posts
  100. DB table creation on reactivation – dbDelta errors on CONSTRAINTS

Leave a Comment