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. Help required with local wordpress setup
  32. What is an ORM, how does it work, and how should I use one? [closed]
  33. What is the difference between an ORM and an ODM?
  34. What is this JavaScript “require”?
  35. Rename a table in MySQL
  36. How should I tackle –secure-file-priv in MySQL?
  37. What is this JavaScript “require”?
  38. How do I use MySQL through XAMPP?
  39. What is “Advanced” SQL?
  40. What’s the difference between identifying and non-identifying relationships?
  41. What are the differences between B trees and B+ trees?
  42. MySQL SELECT increment counter
  43. Cannot access to localhost/xampp/index.php
  44. Localhost is not working
  45. localhost/xampp/ or http://localhost/index.php can’t be accessed
  46. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  47. Example of a strong and weak entity types
  48. How do I run a file on localhost?
  49. Oracle SQL query for Date format
  50. phpMyAdmin – Error > Incorrect format parameter?
  51. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  52. Difference between partition key, composite key and clustering key in Cassandra?
  53. How SID is different from Service name in Oracle tnsnames.ora
  54. What is a relation in database terminology?
  55. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  56. Database vs File system storage
  57. Can I have multiple primary keys in a single table?
  58. Exclude Statement in SQL
  59. How do you query for “is not null” in Mongo?
  60. What is a file based database?
  61. Is it fine to have foreign key as primary key?
  62. Storing Images in DB – Yea or Nay?
  63. Using wpdb to connect to a separate database
  64. how to Optimize WordPress database for 10 million post? [duplicate]
  65. MySQL Database User: Which Privileges are needed?
  66. Why is my database import losing text widget data?
  67. Database synchronization between dev/staging and production
  68. Keeping WP database synced across multiple developers using git
  69. WPDB Insert or if exists Update
  70. Multiple developers / editors working on a site in progress
  71. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  72. get_results using wpdb
  73. Will it break my site if I delete all transient records in wp_options table?
  74. Checking if Database Table exists
  75. Why WordPress choose data serialization over json_encode?
  76. What’s the simplest way to backup my WordPress database?
  77. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  78. $wpdb won’t insert NULL into table column
  79. Relaunch 4.2 utf8mb4 database upgrade
  80. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  81. Safest way to bulk delete post revisions
  82. Please explain how WordPress works with MySQL character set and collation at a low level
  83. Solution for database version control and deployment?
  84. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  85. How many users can WordPress handle?
  86. Get error messages when $wpdb->insert() returns false?
  87. Detecting errors generated by $wpdb->get_results()
  88. Staging sites, how do you manage synchronising updates in the DB?
  89. Does dbDelta delete columns as well?
  90. How to get the post publish date outside the loop?
  91. MariaDB as a backend database
  92. wpdb update add current timestamp not working
  93. Site stuck in “Database Update Required” loop
  94. How to fetch Data in WordPress using MySQLi or $wpdb
  95. WordPress Database lost auto increment
  96. Count & Display Database Queries
  97. Connect to database using wordpress wp-config file
  98. How can I make a WordPress database portable and url independent?
  99. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  100. wpdb->insert multiple record at once

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)