How to edit Joomla configuration file

This is just a quick guide on how you can edit the configuration file in Joomla. This is useful when you have recently changed your mysql database password. And whenever you access Joomla in your localhost, it says that it cannot connect to the database.

To edit the Joomla configuration file, just open up the folder where you have installed Joomla. Mine is in:


Then open up the configuration.php file on a text editor.


We are only interested in the final parts of the file. I’ve already commented the important parts that you may need to modify:

var $db = 'joomladb'; //this is the database where all the data used by joomla is stored
var $dbprefix = 'jos_';
var $mailer = 'mail';
var $mailfrom = '';
var $fromname = 'JoomlaTesting';
var $sendmail = '/usr/sbin/sendmail';
var $smtpauth = '0';
var $smtpsecure = 'none';
var $smtpport = '25';
var $smtpuser = '';
var $smtppass = '';
var $smtphost = 'localhost'; //host, its usually called localhost. Since the Joomla CMS is hosted on your local computer
var $MetaAuthor = '1';
var $MetaTitle = '1';
var $lifetime = '60';
var $session_handler = 'database';
var $password = '1234'; //password, this is the one that you may want to change depending on your current mysql database password.

How to install Drupal

In this guide I will show you how you can install Drupal on your localhost.

First, you need to download Drupal from their site:

Extract the tar.gz file to your web accessible folder. Make sure you have the index.php on the root of the drupal folder.


Second, you need to make sure that Drupal is really compatible to run on your current web server. In this case, the apache Webserver which came with the installer of wampserver. Which you can download for free at:

At the time of writing of this guide, I have:

    • php –version 5.3.0
    • mysql –version 5.1.36
    • apache –version 2.2.11

Be sure that your wampserver installation complies with the requirements of the Drupal Content Management System. Because it won’t really work properly if it doesn’t meet the requirements.

As a summary for the requirements:

    • MySQL 3.23.17 or higher. MySQL
    • PHP version 4.4.0 or higher for Drupal 5 and Drupal 6, PHP 5.2.5 or higher for Drupal 7
    • Apache 1.3 or Apache 2.x hosted on UNIX/Linux, OS X, or Windows.

The wampserver installer will do, so you won’t have to install other versions of php, mysql and apache to make this work.

Next thing that you need to do is to open it up on your browser by typing:


or whatever name you gave to the folder. Just choose Standard and click on Save and continue


Select the default English. Then click save and continue.


Enter your database server credentials. The defaults would be:

username: root


Before you put in a database name. You first need to create one. To do that, launch MySql Console from the Wampserver tray icon found at the bottom right corner of the screen.


Input these commands on the mysql console:

create database drupal_db

You can change the drupal_db to whatever you want, it doesn’t  really matter if you use another name.


You’re now ready to input the database name you have just created. This is where the installer is going to put the tables.


After you click on the save and continue, this is what it will look like. Just wait for it to finish. It won’t take long.


All you have to do now is to configure the site name and other settings


Scroll down a bit, and then set the options applicable to you. Then click save and continue.


After that, just click on visit your new site and the installer will bring you to the newly created drupal site of yours. Installed on localhost.


So you won’t really see this on google search results or on any search engine if you try to search it.




That’s how you install drupal. A nice and free content management system just like Joomla. I might make another tutorial like this on how to use Drupal so stay tuned. Thanks for readingSmile