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. Difference between partition key, composite key and clustering key in Cassandra?
  32. How SID is different from Service name in Oracle tnsnames.ora
  33. What is a relation in database terminology?
  34. Why WordPress choose data serialization over json_encode?
  35. Relaunch 4.2 utf8mb4 database upgrade
  36. Reset Post IDs to less than 64bit integer
  37. Does WordPress use the InnoDB engine for MySQL by default?
  38. $wpdb->prepare() warning in WordPress 3.5
  39. Best way to import users, post and categories from an external database
  40. Performance tips for a large user base [closed]
  41. Saving Metadata from the Gutenberg Editor Sidebar to the Database
  42. Prevent changing the length of post_name column on WordPress Update
  43. Migrate a Non WordPress database to wordpress [closed]
  44. Moving an entire wordpress site from one domain to a new domain and database
  45. error importing localhost export file to server
  46. Custom DB_COLLATE (collation) value not working on fresh install?
  47. What causes the “max_user_connections” warning on WordPress frontend?
  48. Get Database Credentials from within the themes file
  49. How does WordPress create its database during installation?
  50. Subscribers to posts
  51. $wpdb->update has finished saving trigger?
  52. WordPress site uses MyISAM, should I switch to InnoDB necessary?
  53. WP Database Table to CSV file
  54. For WordPress is there content in the database which I can safely ignore?
  55. How can I UN-orphan media files?
  56. Does WordPress always create unique passwords?
  57. Merge two WordPress installations into one, and keep posts separated?
  58. Export / import WordPress database
  59. WordPress choose wrong database
  60. How can I (semi) automate a database export and import to a different location?
  61. WordPress on a local machine redirecting to xampp dashboard page [closed]
  62. Is it safe to delete unnecessary user metadata?
  63. Improve performance by removing unnecessary database queries
  64. WordPress Relational Database
  65. Unable to set a default serialized array using dbdelta()
  66. Importing 10 Years of Media into the WP Database
  67. Is there a way to execute a php script outside WordPress?
  68. Make changes of wp-db.php file persistent against updates
  69. Change the default data installed when setting up WordPress
  70. $wpdb->get_var – What value is returned when zero records are found?
  71. SymmetricDS in dev + prod workflow?
  72. Fixing YARPP plugin FULLTEXT MySQL indexing
  73. Error establishing a database connection in wordpress site , website not opening
  74. Counting post and changing roles in mysql database. Query not code
  75. wpdb Insert unknown post data dynamic foreach loop
  76. How do I use a database in a custom theme?
  77. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  78. Migrating meta_key and meta_value from old theme to new one
  79. How do you enable scripts on a WordPress installation in Softaculous?
  80. How to rerieve comments and their replies from DB
  81. Inserting data with Geometry field
  82. Export only a part of the database for migration
  83. Page 404 Error on Localhost
  84. Why am I being prompted to reinstall wordpress?
  85. What’s the easiest way to connect external database and display data on wordpress?
  86. database error WordPress move from one hosting to other
  87. Select data from foreach loop and send it to wordpress database
  88. Same DB for live and dev versions
  89. update multiple user meta field based on another meta field
  90. After renaming MySQL database, I can no longer access my Blog page
  91. execute custom function on database connection error
  92. Call to a member function insert()
  93. Create a new table on the database and save parameters from a contact form
  94. not saving post in wp_post wordpress database table
  95. How to add data from wordpress tables to new database tables you have created
  96. Creating Tables in WordPress Database
  97. Calling update_user_meta inside of another function doesn’t work
  98. How to back-up a database on IIS
  99. Where are database files of a WordPress website?
  100. SQL query to rewrite all media URLs to end with .webp

Leave a Comment