Setup WordPress with Remote MySQL Database

October 6, 2011 | By Regaz | Filed in: Uncategorized.

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', '');


    define('DB_HOST', '');

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

Tags: ,