$schemamarkup = get_post_meta(get_the_ID(), 'schemamarkup', true); if(!empty($schemamarkup)) { echo $schemamarkup; }

Setup WordPress With Remote MySQL Database

October 6, 2011 | By Duchateaux.

WordPress Website with Remote MySQL Database

The Tip Simply Shows How to Set-Up WordPress with MySQL Database on a Remote Server.

First, Step Involved is to Grant Remote Access to the Database for the WordPress MySQL User…

How to Setup WordPress with a Remote MySQL Database - Featured

  1. Granting MySQL Remote Access.

    • By CPanel: go Databases >> Remote MySQL Authorize your IP

    • How to Grant MySQL User Remote Access on Shell

      Enabling MySQL Remote Connection

  2. Edit wp-config.php.

    For example with the nano editor:

    sudo nano wp-config.php

    Set up:

    define('DB_HOST', '16.32.64.128:port');

    Or

    define('DB_HOST', 'db.domain.com:port');

    Ctrl+x to Save & Exit from nano Editor :)
    (The ‘:port’ Parameter it is Not Needed if MySQL use the Default port: 3306)