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
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
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.
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
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.
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?
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