Setup WordPress with Remote MySQL Database

October 6th, 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', '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)

(Visited 1 times, 1 visits today)

Tags: ,


Comments are disabled