Recently I’ve just install a WordPress on a server while using another server database. So I figure it was good to shows how to do it. I’m working with cPanel, so this is going to be cPanel installation.

First off, go to cPanel and look for “Remote MySQL”. It is to allow a certain IP to access the database. Even your computer, as long as you know your Internet IP address.

When you logged into Remote MySQL, it will ask for a IP address, you can use the installation server IP address. So it allow the installation to access the database.

In wp-config.php file, look for line 28, change it (refer above screenshot) to the cPanel IP address.

Voila! You have used an external database for the new installation. Of course, there are some reasons to use a remote host database. Hope that help