Setup WordPress With Remote MySQL Database

October 6, 2011 | By Regaz.

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)

QuickChic Theme • Powered by WordPress