Search

Reply to comment

Wordpress Setup with Remote MySQL Database

If you are trying to develop on a local machine and use the Database you dispose on Host Server you should: (This is possible only if your Host Allow MySQL Remote Access)

  1. Enable MySQL Remote Access     In CPanel  Databases>>Remote MySQL     Insert your IP
  2. Check you are able to connect to Database:      In Unix-like open a Terminal Session

    mysql -u yourMySQLUser -h xxx.xxx.xxx.xxx -p
  3. Change settings in wp-config.php:

    define('DB_HOST', 'xxx.xxx.xxx.xxx:port');

    OR

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

    (Default port: 3306)

  4. Save and Test :)

The Original Document is here: http://install-climber.blogspot.com/2011/08/wordpress-mysql-database-remote.html

Reply

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer