Setting up WordPress in your Provider

WordPress is an open source blog tool and publishing platform powered by PHP and MySQL. (see http://en.wikipedia.org/wiki/WordPress). It's often customized into a Content Management System (CMS) wherein one can do their own personal publishing, add their own aesthetics yet still aligned to web standards. It is a free but very essential and priceless blogging software.

If you already have a domain account with PHP and MYSQL support then you should be able to get your WordPress up and running. Follow the following steps below:

PART I "WordPress Package"

1. Download WordPress from http://wordpress.org/download/


2. Unzip the package in one of your temporary directory

PART II "Your MYSQL Database"

1. Access your Administration Panel on your Domain


2. Create a Database and take note of its name


3. Record the username and password

PART III “WordPress Configuration”

1. Go back to the temp folder where you unpacked WordPress


2. Open the file wp-config-sample.php with a notepad or Dreamweaver


3. Edit the following:
   
   define('DB_NAME', ‘NameOfYourDatabase’);
   
   define('DB_USER', 'DatabaseUserName');
   
   define('DB_PASSWORD', 'DatabaseUserNamePassword');
   
   define('DB_HOST', '127.0.0.1');


4. Save the edited file as wp-config.php

PART IV "Uploading WordPress to your Web Server (Externally hosted)

1. Using your favorite FTP program connect to your website.


2. At the html level directory create a blog folder.


3. Example: /var/www/html/blog/


4. upload the WordPress files to that blog folder.

PART V "PHP Configuration"

1. Using your web browser, access http://www.yourdomain.com/blog/wp-admin/install.php to initiate the installation process.


2. Once WordPress comes up click “First Step”


3. Enter the title of your Web Log and enter your email address


4. Click continue to Second Step


5. Note the password generated


6. Click on the login address wp-login.php to access your WordPress Account.

Sponsored by: www.cartizgis.com

MySQL Admin on XAMPP

Introduction

XAMPP is a very cool package that integrates Apache, MYSQL and PHP all at once without you going into the hassle of the individual installation configuration of PHP, Apache and MYSQL. There are some issues though for those who are used to using the MySQL Admin in administering the MYSQL Database. When you install XAMPP the MySQL Admin gui is not included in the installation. Although most of the time you can use the PhpMyAdmin with your database, there are times where in you need more refined administration of the database through MySqlAdmin. In order for the MySqlAdmin to work with the XAMPP configuration you need to do the following.

Procedures:

1. Download the MySql GUI Tools from http://dev.mysql.com/downloads/gui-tools/5.0.html
   Find the appropriate GUI based on your system. With my installation I have the Windows x86. Save and install the program.
2. To install the MySql GUI Tool you need to install using the custom installation. Then place its directory under the directory of XAMPP mysql installation. In my case the XAMPP mysql is in D:\xampp\mysql. So for the installation of the MySql GUI Tools I had to use: D:\xampp\mysql\MySQL Tools for 5.0
   The purpose of this installation is to help MySqlAdmin to locate the MySql Database without you tampering the configuration file.
3. Start your MySqlAdmin from the All Programs Menu and just enter the information needed to start the MySQL Database. User: root. For the password there should be no password if you haven't changed anything in http://localhost/security/index.php

For more information contact jnoel@cartizgis.com

Url: http://www.cartizgis.com