Is it possible to host wordpress database from oth

Question

I've a problem is that I've to host wordpress database from other server and directory from another server where my domain links, so is it possible to connect wordpress directory from other database which is not on same server, kindly resolve my issue if know the answer. Thanks in advance.

Answer 1

Yes, as long as the MySQL server allows the database to be accessed by external servers. When you set up WP, instead of "localhost", you'll put in the SQL server.

you can export the current database, then you will create a database on another server,

then instead of "localhost" (in the config.php ) you will put the IP address of the server and then the config.php will connect

// wp-config.php

define ( 'DB_NAME', 'yourdbname' );
define ( 'DB_USER', 'yourusername' );
define ( 'DB_PASSWORD', 'yourpassword' );
define ( 'DB_HOST', '111.222.0.1' ); // IP address of the server where MySQL is running 

// make sure MySQL server will listen to the request from your WP server IP !

https://forums.digitalpoint.com/threads/can-i-host-wordpress-database-in-an-other-server.2702115/

Answer 2

In config.php file you just put ip address of other server where your database exist instead of localhost. but remember it's not good idea to run separately database and source files, it will make you in trouble , for more info just view the following link. Thanks for you cooperation.

https://forums.digitalpoint.com/threads/can-i-host-wordpress-database-in-an-other-server.2702115/