Remote database connection and local development

I would like to develope locally meanwhile using a wp remote database.

I've been searching for a long time in google and trying some configurations (wp-config.php) without success.

I achieve to make it work, but without satisfaction (I have looping redirection, revolution slider not working, etc)

I customize this values, and get the remote connection, but maybe there is something about the server path that needs to be configured ¿?:

define('DB_NAME', 'db_name'); // remote
define('DB_USER', 'db_user'); // remote
define('DB_PASSWORD', '123456'); // remote
define('DB_HOST', 'xxx.yyy.com'); // remote

define('WP_HOME','www.aaa.dev'); // local
define('WP_SITEURL','www.aaa.dev'); // local

Thank you very much for your attention, I would like to know if someone have done this set up.

PD: I already try this here: Connect to remote database using Localhost install

Topic workflow remote database Wordpress

Category Web


In most cases, the database server is not open to remote connections by default, meaning that you can connect to it locally (web server and database server are on the same machine). By default, MySQL is binding to the localhost or 127.0.0.1. Here is one tutorial on how to grant remote access to specific IP and user account: Enable Remote Access for MySQL.

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.