Simple help need: WP Database from different Server

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.

 

some hosts block access db via ips so u need to look permissions first

 

How to check that ? Should I ask our hosts to enable that permission, or can we check from cpanel ?

 

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.

 

Your going to need to allow offsite connections going to your MySQL database.

 

I think you should consult this to your hosting support. Not all hosting allow this kind of tricks

 

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