[ad_1]
[ad_2]
After taking advice from this sub the other day, I requested my team to set up a remote database for us so we can all work with the same database. They acknowledged its importance, and provided us with the credentials after setting up the database.
But, I can't figure out how I could incorporate the remote database into my workflow. I am using Local WP to develop an Elementor website and I don't see an option to connect to a remote database instead of the local instance provided by Local WP itself.
If anyone has dealt with this before, I'd appreciate some pointers.
In your root directory, there will be a `wp-config.php` file.
In WordPress, the database credentials are stored in that file.
You have to update the database details like DB name, DB user, Password & DB host.
Default code will look like below one.
define(‘DB_NAME’, ‘your_database_name’);
define(‘DB_USER’, ‘your_database_user’);
define(‘DB_PASSWORD’, ‘your_database_password’);
define(‘DB_HOST’, ‘localhost’);
We have to update these details with new details.
Change in DB_HOST – Replace localhost with the IP address or hostname of our remote database server. If our database server uses a non-standard port, we can specify it like below one.
define(‘DB_HOST’, ‘remote_host_ip:3306’);