Tuesday, August 9, 2011

How to Setup reCaptcha Plugin System-Wide/Buddypress

Just to Correct Installation Procedure on:
Wordpress Site

After you Moved the "wp-recaptcha.php"
you have to Edit the file to change Required's Path...
On Unix-like Systems you can simply edit your file with:
pico wp-recaptcha.php
Change 2 lines:
require_once('recaptcha.php') --> require_once('wp-recaptcha/recaptcha.php')
require_once('mailhide.php') --> require_once('wp-recaptcha/mailhide.php')

Now you can proceed to Install the System Wide Plugin :)

Friday, August 5, 2011

How to Setup Wordpress with Remote MySQL Database Access

If you are trying to Develop on Local machine and Use the Remote Hosted MySQL Database try to Follow this Procedure to Enable MySQL Remote Access by Wordpress:

  1. Enable MySQL Remote Access
    • On CPanel Go:
       Databases >> Remote MySQL
      Then Insert your IP
    • On Amazon Ec2:
      On Security Group Open the 3306 Port
      Then Create a User with Credential to Login from Net...
      Example:
      GRANT ALL PRIVILEGES ON *.* TO bob@’%’ identified by “yourpasswordhere”;

  2. Check if you are able to Cnnect to Database from Terminal:

    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)