How to grow wealthy with blogging 103 – Building blocks

This entry is part 3 of 3 in the series Blogging Wealth

Last Updated on June 16, 2018 by Memorila

To grow wealthy from blogging, you will need a website to write from. In this post, you will learn how to create a self-hosted WordPress site from scratch using automatic or manual methods.

Normally after creating the foundation of a house, you will need to lay the blocks to build the house from down up. And after the building, comes painting – the icing on the cake.

This real life scenario plays out in our blogging lives too. Just as it is in reality where you have to make architectural design of a house before building, in blogging you also need to make a sketch of how your blog will look like, what functions it will perform, how many menus it will have, how user-friendly it will be, and so on.

And after the sketching comes the actual building and the beautification processes.

In this episode of How to Grow Wealthy with Blogging, I will explain the nitty-gritties of how to build a self-hosted WordPress site from start to finish. Stay glued!


From the previous posts of these series, I mentioned that WordPress is my take when it comes to blogging because of its numerous advantages and scalability. I also mentioned that there are free and self-hosted WordPress sites.

Free WordPress sites are hosted on website and the domain names of your site will mostly be like, unlike Even though you can register your domain name and redirect it to your free WordPress site, the demerits of using a free-hosted WordPress site outweighs the merits. Hence, in my previous post, I adviced you go with the self-hosted WordPress for your blogging.

Someone might ask, “How do I create a self-hosted WordPress site then?” And this will be my answer: There are two ways of creating a self-hosted WordPress. These are:

i) Automatic Installation, and
ii) Manual Installation

Now, there is one thing you have to know. Automatic installation is very smooth and easy. But it has downsides. When you install your WordPress site automatically, you wouldn’t know some of the inner workings of your site.

If peradventure your site develops fault, no matter how minute it might be, you will find yourself running around to get a computer geek to fix it. And most often, these smart guys definitely smile to the bank.

Put this at the back of your mind. Learning to code to fix little or complex problems is one way to accumulate wealth through blogging.

More reasons why you will need to learn simple coding is that at times, your hosting plan might not come with the automatic installation option. If that is the case, what do you do?

Furthermore, let’s say want to test-run WordPress on a local server. If you do not know simple coding, how do you do it. Learning to install WordPress manually will not break your head. And you will be better for it.

As a cliché rightly says, “The hard way is the sure way!”

Even though installing WordPress automatically takes off the hard work from your shoulders, learning to manually install it will surely be of advantage in the long run.

RELATED STORIES  Computer Appreciation 101: The beginning

Before I show you how to install a WordPress automatically or manually, you will need to learn the following terminologies:

Web Terminologies


A server is a computer that has the capability to host websites. There are two types of servers: local and live. A website on a local server can be accessed only through a Local Area Network. But if you want your website to be accessed across the world, you will need to host it on a live server.

Moreover, WordPress and other blogging software use PHP scripts. And most web browsers cannot display php files if they reside on our computers. For the web browsers to be able to run the scripts, they have to reside on a live or local server.

Examples of local servers you can use include XAMPP and WAMP. You can purchase a live hosting package from HostGator or Web4Africa.


As the name implies, it is a storage place for information. Some websites also need databases tostore sensitive data which are called upon from a PHP program. These data could be usernames, passwords, links, addresses, etc.

A database is usually triggered using query languages called the Structured Query Language (SQL). The popular ones are MySQL and MSSQL.

You will need to create a database to keep your WordPress data.


This is the programming language most dynamic and responsive websites use nowadays. Even though there are other web-based programming languages like Perl, Python, and so on, PHP is now ubiquitous because of its short learning curve and connectivity with MySQL.

You may not necessarily need to drip your hands wet with this language. But the little or more you know about it, the better.


As I stated above, databases are queried using structured query languages. MySQL is one of the commonest because it is simple to use and open-source software. Linux servers (not Windows servers) which most local and live servers are built on, use MySQL.

You may not necessarily write a query statement throughout your blogging journey. But the little you know may prove handy as the effects of the trip wears on you.


This is an application suite that enables you to interact with your database easily. It allows you to create or delete fields in a database, import or export a database, and so on.

PhpMyAdmin is usually shipped together with most local and live servers. It will help you in your trip.

Creating a Database

To create a database, you will need to log into your site’s cPanel. The cPanel is a control panel used to create databases, email accounts, manage files, install software and so on.

Most hosting plans come with a pre-installed cPanel and hosting companies usually send the login details including username, password and link to their customers once they purchase a package.

Here I will explain how to use the cPanel to create a database. Please read more on how to create a database with a local server. (If you want me to create a post on it, leave a comment below or inbox me).

How to Create a Database in cPanel

1) Log into the cPanel with the username and password provided by your hosting company.

2) While inside the cPanel suite, locate the Database sub-heading and click on MySQL Databases link.

3)In the new page that displays, locate Create a New Database section and enter a name for the database. The name will be attached to your cPanel username. Next, click on Create Database button.

RELATED STORIES  Computer Appreciation 102: Taking baby steps

4) If everything goes well, a success page will display which means the database has been created. Next, click on Go Back button to go back to the MySQL Databases webpage.

That is it! You have created your first database. Next, you will need to add a user and give it privileges to access the created database.

How to Create a Database User in cPanel

1) Locate the MySQL Users section and enter a new Username in the textbox provided.

2) Generate a Password by clicking on the Password Generator button. Copy the password to a safe place, tick the checkbox besides “I have copied this password to a secure location” and click the Use Password button. This will fill up the password textboxes.

3) Click on Create a User button;a success page shows that the user was created successfully. Next, click on Go Back button.

Steps in Linking a Userto a Database

1) In the MySQL Database page, scroll down to the Add a User to a Database section.

2) In the Users combo box, select the new user you created and select the database name from the Database combo box. Next, click on Add button.

3) The next page will show privileges. Tick the checkbox beside ‘ALL PRIVILEGES’to grant the user all privileges. Next, click on Make Changes button.

That is it! You have done it again!!

Well done! Can we proceed….? NO!!!! Take a break.

Grab a cup of coffee, drink, take a quick exercise of five minutes and then relax a little while.When you are done, you can come back so we continue our blogging wealth journey…

And now let’s dive into the installation process.

But last in, first out!We will take the automatic installation process first.

How to Install a WordPress Site Automatically

Installing a WordPress site automatically is the same way you will install other software like Joomla, OpenCart, phpList, Drupal and so on.

Most hosting sites have software for automatic installations, like Softaculous, Fantastico, and QuickInstall. The processes for automatic installation in any of these software are almost the same. Here is how you install WordPress automatically using Softaculous:

1) Log into the cPanel of your site. From the subheadings of cPanel page, check for Software and Services and click on Softaculous(or Fantastico or QuickInstall).

2) In the left hand column of the new webpage that will display, click on Blogs category and underneath it,click on WordPress.

3) A new webpage will display. Click on Install tab at the top menu and enter the following information in the textboxes provided:

Database Name: Enter the name of the database you created.

Choose Domain: You can install WordPress on your main domain or as a sub-domain. So choose the domain to install the WordPress into.

In Directory: Leave this blank if you are installing on your domain directly. But if you are installing in subdomain, specify the folder where to install into. For example if you created a sub-domain, just enter /blog in this space.

Admin Username: Enter an admin username for the WordPress administrator.

Admin Password: Create a strong password for the administrator login.

Admin Email: Enter any real email which will be linked to the site. The system might have generated a random email here. Remove it and put a real one.

Crosscheck the information you entered. If you are sure of what you have entered, click on Install button.

RELATED STORIES  How to grow wealthy with blogging 102: Laying foundation

4) Softaculous or whatever software you are using will submit and examine the information you supplied. If there is no problem, it will install it. But if there is a problem, it will notify you to correct it.

Automatic WordPress installation normally don’tlast more than 3 minutes if there are no bottlenecks. And when this is done, you can now visit your site by typing your URL on the web browser’s address bar.

How to Install a WordPress Site Manually

  1. Download the latest version of WordPress from its official site. It will normally be in a zip format.
  2. Upload the zip folder in the root folder (public_html)of your site. In the case of a sub-domain, upload it into the folder you created for it.

You can use the File Manager of your cPanel (Log into your site’s cPanel and under File section, click on File Manager) or any FTP program like FileZilla to upload the zip folder.

  1. Next, extract all the contents of the zip folder. You should now be seeing WP-Admin, WP-Content and other files in the root folder or sub-domain.
  2. Next, type your site’s URL on the address bar of your browser. A welcome page will display. Click on Let’s Go button.
  3. In the next page, enter theDatabase name, User name, Password you created earlier on. Leave the Database host as localhost except otherwise specified by your host. Change Prefix to something else. Finally, click on Submitbutton when you have finished crosschecking what you entered.
  4. If the database information is valid, a success page displays. Click on the Run the install button to continue with the installation process.
  5. Next, type information regarding your site like its name, admin username, password, email address in the next page. Copy and store the username and password in a secure location. You will need them to operate your site. Finally, click on Install WordPress button.

And that is it!! You have done the magic!! You have installed a WordPress site on your own. Hmmm, you don dey become a professional.Visit your home page to see your installation.

And here is the kulikuli. This is where you can grow wealthy from blogging by creating websites for others for a fee. But wait, don’t rush! You will still need to know more.

So what next? You will need to install a WordPress theme and some plugins to beautify and enhance the working of your site.Topics for next episode right? Yes, you go it.

That is it exactly!Installing a WordPress isn’t a big deal anyway. But it is a stepping stone to our dreamland: blogging wealth.

Stay tuned to to get more informative and educative posts.

If you wouldn’t want to miss out on any episode ofHow to Grow Wealthy with Blogging, submit your email now to get them once they are published.

And don’t forget to leave a comment below. Your comments motivate me to write more. They show that my effort is not in futilityJ

Love you!


Series Navigation<< How to grow wealthy with blogging 102: Laying foundation

Faruk Ahmed

Faruk Ahmed is the founder of Having previously worked with National Review magazine, he is a keen watcher of political events.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.