How to Install WordPress on CentOS 6.4

wordpressWordPress is free web blogging software and open source content management system (CMS) which based on PHP and MySQL platform. You can run and install WorPress on shared Web hosting service, on virtual private server (VPS) or if you need high performance WordPress blog which can serve many concurrent users at a time, you can choose dedicated server for it. This post covers the steps how to install WordPress on linux CentOS 6.4. It was assumed that this CentOS 6.4 already installed with PHP, apache and MySQL server.

1. Login as a root, download latest wordpress file :

[root@centos64 ~]# wget http://wordpress.org/latest.tar.gz

2. Once downloaded, move yje wordpress file to document root on your web server.

[root@centos64 ~]# mv latest.tar.gz /var/www/html/

3. Enter document’s root directory and extract the wordpress file :

[root@centos64 ~]# cd /var/www/html/
[root@centos64 html]# tar xvzf latest.tar.gz

4. Make wordpress folder readable :

[root@centos64 ~]# chmod 755 /var/www/html/wordpress

5. Create Database name “newwordpress” :

mysql> CREATE DATABASE newwordpress;
Query OK, 1 row affected (0.08 sec)

6. Create user “newwordpressuser” with password “newwordpresspassword” :

mysql> CREATE USER 'newwordpressuser'@'localhost' IDENTIFIED BY 'newwordpresspassword';
Query OK, 0 rows affected (0.07 sec)

7. Grant all privileges to “newwordpress” to user “newwordpressuser” from localhost access :

mysql> GRANT ALL PRIVILEGES ON newwordpress.* to newwordpressuser@localhost;
Query OK, 0 rows affected (0.00 sec)

8. Verify the granted access for user “newwordpressuser” :

mysql> SHOW GRANTS FOR 'newwordpressuser'@'localhost';
+-------------------------------------------------------------------------------------------------------------------------+
| Grants for newwordpressuser@localhost                                                                                   |
+-------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'newwordpressuser'@'localhost' IDENTIFIED BY PASSWORD '*2E824B82B9B162C4283AA039118AD4C5248380DA' |
| GRANT ALL PRIVILEGES ON `newwordpress`.* TO 'newwordpressuser'@'localhost'                                              |
+-------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>

9. Display the created database :

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| newwordpress       |
+--------------------+
3 rows in set (0.00 sec)

10. Copy and rename wp-config-sample.php to wp-config.php:

[root@centos64 ~]# cp /var/www/html/wordpress/wp-config-sample.php /var/www/html/wordpress/wp-config.php

11. Modify the wp-config.php :

[root@centos64 ~]# vi /var/www/html/wordpress/wp-config.php

12. Change below database details such as database’ name, database’ username, database’ password nand database’ hostname.

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'newwordpress');

/** MySQL database username */
define('DB_USER', 'newwordpressuser');

/** MySQL database password */
define('DB_PASSWORD', 'newwordpresspassword');

/** MySQL hostname */
define('DB_HOST', 'localhost');

13. To install, navigate the browser to http://servername/wordpress/.
http://192.168.2.64/wordpress/
1
14. To login, navigate the browser to http://servername/wordpress/wp-login.php :

How to Setup WordPress Blog on CentOS 6.3

WordPress is an open-source blogging platform. It’s a free blogging tool and content management system (CMS) based on PHP and MySQL. This steps covers how to install the WordPress on linux CentOS 6.3. This post assumed that PHP, apache and MySQL server has been setup properly.

1. Login as a root, go to document’ root folder and download latest wordpress file :

[root@centos63 ~]# cd /var/www/html/
[root@centos63 html]# wget http://wordpress.org/latest.tar.gz

2. Extract the lates.tar.gz files to current directory :

[root@centos63 html]# tar xvzf latest.tar.gz

3. Now create wordpress database. Login to your mySQL database :

[root@centos63 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

4. Create Database name “wordpressdb” :

mysql> CREATE DATABASE wordpressdb;
Query OK, 1 row affected (0.08 sec)

5. Create user “wordpressuser” with password “wordpresspassword” :

mysql> CREATE USER 'wordpressuser'@'localhost' IDENTIFIED BY 'wordpresspassword';
Query OK, 0 rows affected (0.06 sec)

6. Grant all privileges to “wordpressdb” to user ” wordpressuser” from localhost access :

mysql> GRANT ALL PRIVILEGES ON wordpressdb.* to wordpressuser@localhost;
Query OK, 0 rows affected (0.04 sec)

7. Check and verify the granted access for user “wordpressuser” :

mysql> SHOW GRANTS FOR 'wordpressuser'@'localhost';
+----------------------------------------------------------------------------------------------------------------------+
| Grants for wordpressuser@localhost                                                                                   |
+----------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'wordpressuser'@'localhost' IDENTIFIED BY PASSWORD '*E62D3F829F44A91CC231C76347712772B3B9DABC' |
| GRANT ALL PRIVILEGES ON `wordpressdb`.* TO 'wordpressuser'@'localhost'                                               |
+----------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.08 sec)

mysql>

8. For higher security, make wordpress folder readable only from browser :

[root@centos63 ~]# chmod 755 /var/www/html/wordpress

9. Go to your web server terminal or ssh to web server. Copy and rename wp-config-sample.php to wp-config.php:

[root@centos63 ~]# cp /var/www/html/wordpress/wp-config-sample.php /var/www/html/wordpress/wp-config.php

10. Modify the wp-config.php :

[root@centos63 ~]# vi /var/www/html/blog/wp-config.php

Change below database details such as database’ name, database’ username, database’ password nand database’ hostname.

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'wordpressdb');

/** MySQL database username */
define('DB_USER', 'wordpressuser');

/** MySQL database password */
define('DB_PASSWORD', 'wordpresspassword');

/** MySQL hostname */
define('DB_HOST', 'localhost');

11. To configure wordpress, navigate the browser to http://servername/wordpress/. Please complete the form Click “Install WordPress”

Site Title : Blog Title
Username : Prefered username
Password, twice : Your password
Your E-mail : Your Email

wordpress

12. To login, navigate the browser to http://servername/wordpress/wp-login.php :
wordpress

How to Install WordPress Blog on Fedora 16

In this post, i will share with you on how to install WordPress blog on Fedora 16 server. WordPress is an open-source blogging platform. It’s a free blogging tool and content management system (CMS) based on PHP and MySQL. Follow this howto guides to install the WordPress on Fedora 16. This post assumed that apache and mysql has been setup on this server. If not, proceed to the following Apache and MySQL installation howto :

1. Login as a root and download latest wordpress file :

[root@fedora16 ~]# wget http://wordpress.org/latest.tar.gz

Enter documentroot “/var/www/html”

[root@fedora16 ~]# cd /var/www/html
[root@fedora16 blog]# pwd
/var/www/html

2. Extract the lates.tar.gz files to current directory. In this post, i will extract wordpress file into documentroot “/var/www/html” :

[root@fedora16 html]# tar xvzf /root/latest.tar.gz

3. Rename extracted wordpress to blog for easier and better naming :

[root@fedora16 html]# mv wordpress blog

4. Now it’s turn to create wordpress database. Login to your mySQl database ;

[root@fedora16 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.14 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

5. Create Database name “wordpressdb” :

mysql> CREATE DATABASE wordpressdb;
Query OK, 1 row affected (0.07 sec)

6. Create user “wordpressuser” with password “wordpresspassword” :

mysql> CREATE USER 'wordpressuser'@'localhost' IDENTIFIED BY 'wordpresspassword';
Query OK, 0 rows affected (0.00 sec)

7. Grant all privileges to “wordpressdb” to user ” wordpressuser” from localhost access :

mysql> GRANT ALL PRIVILEGES ON wordpressdb.* to wordpressuser@localhost;
Query OK, 0 rows affected (0.00 sec)

8. Check and verify the granted access for user “wordpressuser” :

mysql> SHOW GRANTS FOR 'wordpressuser'@'localhost';
+----------------------------------------------------------------------------------------------------------------------+
| Grants for wordpressuser@localhost                                                                                   |
+----------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'wordpressuser'@'localhost' IDENTIFIED BY PASSWORD '*E62D3F829F44A91CC231C76347712772B3B9DABC' |
| GRANT ALL PRIVILEGES ON `wordpressdb`.* TO 'wordpressuser'@'localhost'                                               |
+----------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>

9. For better security, make wordpress folder readable only from browser :

[root@fedora16 ~]# chmod 755 /var/www/html/blog/

10. Go to your web server terminal or ssh to web server. Copy and rename wp-config-sample.php to wp-config.php:

[root@fedora16 ~]# cp /var/www/html/blog/wp-config-sample.php /var/www/html/blog/wp-config.php

11. Modify the wp-config.php:

[root@fedora16 ~]# vi /var/www/html/blog/wp-config.php

12. Change below line to above:

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'wordpressdb');

/** MySQL database username */
define('DB_USER', 'wordpressuser');

/** MySQL database password */
define('DB_PASSWORD', 'wordpresspassword');

13. To configure wordpress, navigate the browser to http://servername/blog/

wordpress

14. Please complete the form Click “Install WordPress”

Site Title : Blog Title
Username : Prefered username
Password, twice : Your password
Your E-mail : Your Email

wordpress

15. To login, navigate the browser to http://servername/blog/wp-login.php

How to Add Post Footer to WordPress

These are a few steps to add post footer in WordPress post:

Steps
1. Go to plugin menu
2. Click Add New and
3. On the search box, type term –> add post footer, then click search plugin
4. It will show you one plugin called “Add Post Footer”, and click install. Then activate the plugin.
5. Once activated, go to setting menu, then click ” Post footer”
6. On these page, you will be able to customize the setting such as below :

  • Add Ad before Related Post: Select Yes/No
  • Add following Ad. code to the end of post: Select Yes/No
  • Add Ad Code Script:
  • Add related post list: Select Yes/No
  • Add Maximum number of post in the list:
  • Add The header text for post list:

How to Create Google Custom Search in Thesis WordPress Theme

This Steps will guide you how to install Google Custom Search on thesis wordpress theme. It will create the Custom Search on the top right of Navigation Menu page.

1. In your browser go to http://www.google.com/cse/

2. Go to AdSense Setup -> Get Ads -> Click AdSense for Search -> proceed to create search code unit until you get “Search Box Code” and “Search Box Code”.

Search Box Code
Paste this code in the page where you’d like your search box to appear.

Search Results Code
Paste this code on http://www.myblogxxxx.com/search or where you would like your search results to appear. This page must manually created by your self.

3. Add “Search Box Code” in custom_functions.php

4. Paste “Search Results Code” into http://www.myblogxxxx.com/search

5. Add this in custom editor, Custom/custom.css

    .custom #custom_search {
    	float:right;
    	margin-right:2em;
    	position:relative;
    	padding:0.818em 0 0.818em 0;
    }
    

How to Exclude Pages from the WordPress Page Menu

There is easy way to exclude certain pages from your wordpress page menu list by using Exclude Pages wordpress plugin.This plugin adds a checkbox, “include this page in menus”, uncheck this to exclude pages from the page navigation that users see on websites or blogs. Go to wordpress plugin directory to download and proceed to install.

http://wordpress.org/extend/plugins/exclude-pages/

Steps:
1. Download the “Exclude Pages” Plugin
2. Upload exclude_pages.php to the /wp-content/plugins/ directoryon your blog
3. Activate the plugin through the ‘Plugins’ menu in WordPress
4. Uncheck ” Include this page in lists of pages” to exclude pages from your page navigation list
5. Click update to finish

How to Automatically Show Thumbnail in Thesis WordPress Theme

In the thesis theme, we can customize the post image and thumbnail but it need manual work. It is easy if all these things can be done automatically using existing wordpress plugin and modified a bit in custom.css file. Please follow below steps to enable this feature automatically on your blog post.

1. Install the “Thumbnails for Excerpt” Plugin

  • Login to Dashboard, on the plugin menu, click Add New. Search for “Thumbnail For Excerpts”. Then Install the Plugin


2. Configure the “Thumbnails for Excerpt” Plugin

  • Login to Dashboard, on the Setting menu, “Click Thumbnail Excerpts”


3. Add code to Custom File Editor under Thesis Menu Item

  • Login to Dashboard, on the Thesis menu, Click Custom File Editor. It will show you the currently editing: custom/custom.css then add below code at the bottom.
    /* Teaser Thumbnail Image Styling */
    .custom .teaser img {
    
    /* Add Frame to the thumbnail Image, use "border:none;" to disable border. */
    border:5px solid #F2F2F2;
    
    /* Specify the height of the Thumbnail Image*/
    height:150px;
    
    /* Adds margin space to the thumbnail Image. */
    margin:2px 10px 0 0;
    
    /* Specify the width of the Thumbnail Image. */
    width:150px;
    
    }

How to Submit Sitemap to Google Webmaster Tools

Before we start to submit the sitemap to google using webmaster tools, please make sure that you already installed the Google XML Sitemaps plugin in your wordpress blog and already been registered to Google webmaster tools account. Please refer to below pictures and steps:

1. Please make sure that your wordpress blog sitemaps has been generate automatically by Google XML Sitemaps generator.

2. Please log in to Google Webmaster tools account and go to dashboard.

3. Click Submit a Sitemap.

4. Enter sitemap.xml at the provided form then click Submit Sitemap.

5. The message sitemap.xml has been added as a Sitemap will appear at the top of the dashboard and please make sure that the status column is success.

The Most Popular WordPress Plugins for New Blog Installation

After completely installed the new WordPress blog, there are few more steps before you start blogging. You can extend the WordPress blog with the plugins that can be downloaded from wordpress plugin directory. To make your life easier, i would like to recommend you the most popular wordpress plugin that i ever used.

1. Akismet
Akismet checks your comments against the Akismet web service to see if they look like spam or not.

    http://wordpress.org/extend/plugins/akismet/

2. Google XML Sitemap Generator
This plugin will generate a special XML sitemap which will help search engines to better index your blog.

    http://wordpress.org/extend/plugins/google-sitemap-generator/

3. All in One SEO Pack
Automatically optimizes your WordPress blog for Search Engines (Search Engine Optimization).

    http://wordpress.org/extend/plugins/all-in-one-seo-pack/

4. WordPress Related Posts
This WordPress plugin provides multiple options to show the via tags related posts of a post (for example via a sidebar widget).

    http://wordpress.org/extend/plugins/related-posts/

5. AskApache Search Engine Verify
This plugin Adds Site Authorization meta tags to your home page, to allow search engines to authoritate your ownership.

    http://wordpress.org/extend/plugins/search-engine-verify/

6. Add to Any
Help people share, bookmark, and email your posts & pages using any service, such as Facebook, Twitter, Google Buzz, Digg and many more.

    http://wordpress.org/extend/plugins/add-to-any/

7. WP-DB-Backup
On-demand backup of your WordPress database.

    http://wordpress.org/extend/plugins/wp-db-backup/

8. WordPress.com Stats
You can have simple, concise stats with no additional load on your server by plugging into WordPress.com’s stat system.

    http://wordpress.org/extend/plugins/stats/

9. Contact Form 7
Contact Form 7 can manage multiple contact forms, plus you can customize the form and the mail contents flexibly with simple markup.

    http://wordpress.org/extend/plugins/contact-form-7/

10. WP Security Scan
Scans your WordPress installation for security vulnerabilities.

    http://wordpress.org/extend/plugins/wp-security-scan/