Simple help need: WP Database from different Server

[Monica Owen]

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

[chandan123]

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

[Monica Owen]

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.

[chandan123]

Originally Posted by Monica Owen

no, I would like to run the database from different server 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

[Monica Owen]

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

[chandan123]

Originally Posted by Monica Owen

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

[Monica Owen]

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.

[leprakhauns]

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

[kacangijo]

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

[Nevo]

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?

[thewebhostingdir]

You will have to add the remote IP address of your database server first from the cPanel --> MySQL --> Enter the IP address in the Access Host section and click on Add Host. You can do this if your cpanel theme is set to x2

If your cPanel theme is set to x3 then you can add remote IP address of your database server from the cPanel --> Remote MySQL --> Enter the IP address of the remote database server and click on Add Host.

Once you add the IP address of Remote host then you will have to change the host name to your IP address in your configuration file, username, password and database.

[Monica Owen]

Originally Posted by Nevo

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.

Originally Posted by thewebhostingdir

You will have to add the remote IP address of your database server first from the cPanel --> MySQL --> Enter the IP address in the Access Host section and click on Add Host. You can do this if your cpanel theme is set to x2

If your cPanel theme is set to x3 then you can add remote IP address of your database server from the cPanel --> Remote MySQL --> Enter the IP address of the remote database server and click on Add Host.

Once you add the IP address of Remote host then you will have to change the host name to your IP address in your configuration file, username, password and database.

I did that, and received Error establishing the Database. I contacted HostGator Hosting support, they also couldn't find any solution