I'm usually able to set this up very easily.
In my local wp-config.php file I just add the following lines:
define('WP_HOME','http://example.local'); define('WP_SITEURL','http://example.local'); define('LIVE_SITEURL', 'http://example.com');
Trying to set this up with a live Ubuntu server, I'm running into issues where I get a database error connection after a long wait time.
I have also edited the bind-address directive in my /etc/mysql/mysql.conf.d/mysqld.cnf
Is there anything else I should be looking out for with my local setup?
Edit: also as require, I change the DB_HOST line to:
define( 'DB_HOST', 'remote.ip.here.yeah' );