The Joomla! Community Magazine™

Installing Joomla 3.0 on local host using XAMPP

Written by | Friday, 01 March 2013 00:00 | Published in 2013 March
Joomla is an open source content management system which based on PHP and MySQL. You can work with it both online or offline. However, managing Joomla offline requires you to install a compatible web server and the Joomla package as well. Below are instructions to install Joomla on XAMPP - a good web server which can work well on local machine. This is an extract from the free ebook "Joomla 3.0 Made Easy".

Installing Joomla 3.0 on local host

Installing Joomla! 3.0.x on local host is straightforward but can be tricky the first time you attempt it. So for this step we’ve provided instructions on how to do it right from scratch.

First, let’s make clarify the meaning of “Localhost”. As you know, any website needs to be hosted on a web server in order to be shown to users. Normally, you would need to buy a hosting package from some hosting provider like Rackspace or GoDaddy. Depended on the package you choose, a hosting provider will install a web server for you on one of their server machines, which is accessible to the public. A localhost is basically the same type of web server but installed on your own computer.

Now, in order to run Joomla!, you need not only a web server, but also 2 more things: PHP script interpreter and MySQL database system. It sounds complicated but thankfully, there is a single package called XAMPP with all the elements included.

Let’s install XAMPP on your computer.

Installing XAMPP

  1. Download the XAMPP installer package at  http://www.apachefriends.org/en/xampp.html
  2. Run the installation file as you do with regular software and follow the step by step instructions.
  3. Open “XAMPP Control Panel Application” and start “Apache” and “MySQL”.

XAMPP Control Panel Application

That’s it, your localhost is now installed. You can check if it works or not by typing the address:

“http://localhost” in your web browser. You should see a page as illustrated below.

XAMPP for Windows interface

  1. Create a database in phpMyAdmin.

From the XAMPP interface, click phpMyAdmin to start creating database.

Click “phpMyAdmin”

  1. Next, click Database in the toolbar as illustrated in the following

Click “Database”

  1. Next, enter the database name and then click “Create”

Create database

Now you are ready to install Joomla!.

Installing Joomla!

  1. Download the Joomla! 3.0.x full package at http://www.joomla.org/download.html
  2. Create a new folder entitled “Joomla30” in folder “htdocs” in XAMPP folder. Normally it will be located at “C:\xampp\htdocs”
  3. Unpack the downloaded package file into the folder “Joomla30”
  4. Go to the URL “http://localhost/Joomla30”
  5. Follow all steps in Joomla! installation:
  • Step 1. Main Configuration
    • Select Language: Choose your own language in the drop-down menu, for example, “English (United States)”
    • Site Name: Enter the name of your site
    • Description: Enter the description of your site
    • Site Offline: Choose status for your website when you access to your site: Click “Yes” for “offline” and “No” for “online
    • Admin Email: Enter your valid email address you want to use for your site
    • Admin Username: Enter “admin” as default
    • Admin Password: Enter your own password
    • Confirm Admin Password: Re-type your password
    • Click “Next” to continue Step 2
  • Step 2. Database Configuration
    • Database Type: Select MySQLi
    • Host Name: Enter localhost
    • Username: Enter “root”
    • Password: let it blank
    • Database Name: enter the name of the database you created Joomla30
    • Table Prefix: let it generate automatically
    • Old Database Process: Click “Backup” to backup tables from former Joomla! installation, or “Remove” to delete these tables
    • Click “Next” to continue Step 3
  • Step 3. Overview
    • Finalization: You can choose installing sample data or not, by clicking on corresponding selection.
    • Overview: This step is to review all information you configured in step 1. After checking, you click “Install”.
    • When installation finishes, you just need to click the button “Remove installation folder” button to complete the installation process. After that, you can either click on “Site” to see your newly created or “Administrator” to access the administration area.

Now you have your first Joomla! site installed successfully! It’s not too hard, right? If you have any trouble with the installation process, you can try in the following sources for the answer:

  • Official Joomla! forum

The Joomla! forum is one of the busiest (and most friendly) support forums in the world, and it is a great place to get help and meet other Joomla! users. There are a lot of questions and answers which are discussed here. Because our topic is Joomla! 3.0 installation, so you can find help in the category “Installation Joomla! 3.0”.

  • Other Joomla! learning resources

There are many other websites which you can use a s your Joomla! learning resources:

>>> The next step

Installing Joomla! 3.0.x on your local host is the first thing you need to do successfully before getting started with your Joomla! site. Now, when your website is ready, let’s fill it with content. You can get more details of how to fill it with content by downloading the 108-page ebook "Joomla 3.0 Made Easy".

If you have feedback or suggestions, feel free to leave your comments below.

Read 189620 times
Tagged under Book Reviews, English
Tuan Bui

Tuan Bui

Tuan is the Joomla Fan lover at www.JoomlaShine.com. In spare time he blogs about Online Marketing from the concept to concrete case studies. Exploring his blog posts you will see truly the meaning of the "Quality Content".

Follow @joomlashine

avatar
Hey Tuan,

Had no issues installing Joomla 3 but I cant install any template extensions. Joomlas display install message but nothing displays in my template manager
VOTES:10
avatar
Hi Tuan,
Great post and very helpful. I managed to get past all the steps only to get stuck on the last one.
I now get a screen which hangs at the step that creates database tables - the blue bars just keep going.
Do you know why that is happening and how I can fix this?
Thanks
Daman
VOTES:24
avatar
i having the same problem
VOTES:4
avatar
Just INSTALL older version xampp-win32-1.8.2-5-VC9-installer instead of newer version and NO PROBLEM with installations !!!:D
VOTES:0
avatar
Hey Tuan,
I will write you later. Because First time I need to work myself.
then I will write you.

Thanks,
Hasib
VOTES:-1
avatar
very helpful for especially beginners and i felt very good in terms of installation and overall on site building

Thank you so much for sharing the information!!!
VOTES:3
avatar
How to convert Joomla 2.5 template to Joomla 3.0 template.
VOTES:0
avatar
Having the same problem as Daman, I get a screen which hangs at the step that creates database tables - the blue bars just keep going.
Do you know why that is happening and how I can fix this?
VOTES:8
avatar
mine also just hangs at that step :/ left it going all night
VOTES:3
avatar
i did run my xampp successfully everything shows the green signal of ok. when i try using http://localhost/joomla30, i keep getting this message.
Warning: require_once(C:xampphtdocsjoomla30/includes/defines.php): failed to open stream: No such file or directory in C:xampphtdocsjoomla30index.php on line 28

Fatal error: require_once(): Failed opening required 'C:xampphtdocsjoomla30/includes/defines.php' (include_path='.;C:xamppphpPEAR') in C:xampphtdocsjoomla30index.php on line 28
what should i do???????
VOTES:3
avatar
Daman wrote:
Hi Tuan,
Great post and very helpful. I managed to get past all the steps only to get stuck on the last one.
I now get a screen which hangs at the step that creates database tables - the blue bars just keep going.
Do you know why that is happening and how I can fix this?
Thanks
Daman
Same thing here and this is driving me crazy. Any idea?
VOTES:3
avatar
if your joomla is installed locally (with xampp) just run xampp as an administrator. It worked for me ((right click on the exe, properties, then click on comptatibility then at the bottom, "run as an admin")
VOTES:0
avatar
If you have trouble with joomla installation (getting stuck when you choose language or when you click next) just run xampp as administrator (right click on the exe, properties, then click on comptatibility then at the bottom, "run as an admin"
VOTES:3
avatar
http://localhost shows blank page..what should i do now??
VOTES:0
VOTES:0
avatar
Thanks for this post. After I fill in the information on the first page at localhost/joomla30, when I click next the loading bars just keep going endlessly... I am using the latest versions of both XAMPP and Joomla! (since I'm keeping this site offline). Any ideas? Thanks in advance :)
- First time building a website through Joomla!
VOTES:1
avatar
I had the same problem with XAMPP 1.8.3. After I installed XAMPP 1.8.2 and cleared the browser cache it worked.
Hope thats helps you too
VOTES:0
avatar
display_errors must be otherwise you are not able to install Joomla.
VOTES:0
avatar
saying thank you won't need to very likely try to be sufficient for the extraordinary clearness
VOTES:0
avatar
Unable to install Joomla 3.x version,
I am using windows 7 with Xampp.
plz help me
VOTES:5
avatar
I am using Joomla 3.1 and developing on my localhost using WAMP. I am puzzled. Since I am developing my site in a local server, why is that whenever I disconnect from the internet (sometimes I am in a non-wifi spot) I get the following error when accessing my joomla backend:

"An error has occurred.

0 String could not be parsed as XML "

Here's another weird thing, while I cannot access the backend (the above error shows) I can still access the front end (which I think is logical since even if I am disconnected from the internet my local server is the one rendering the front end pages).

Any ideas why my backend isn't working when I am not connected to the net? Thanks in advance.
VOTES:0
avatar
Thanx for the explanation,great post.............
VOTES:0
avatar
I successfully installed the joomla ..Thnak u very much.
VOTES:1
avatar
please help having issues with loading joomla 3 onto xampp it install and then reverts back to the overview page
VOTES:-1
avatar
hey,
if i already have a database.
i mean that i get a joomla site from a friend that want some changes..
i want to run this site local on my computer so i dont need to create a new db just to connect to exist one..
VOTES:0
avatar
I Followed Every Step And It worked,but m stuck at the last step .
Creating database tables blue lines r not going :(
Can you tell me whats the problem??
VOTES:1
avatar
Hi Swapnil. I think you're describing the same problem I had. I hit the Install button in Step 3, and then the page reverted to Step 1 after 30 seconds.

How I fixed this:

Open /xampp/php/php.ini in WordPad. Find Line with - max_execution_time=30 Change 30 to 300.

That's the first step. But then you must restart the XAMPP server! Very important. I changed the php.ini file without doing that and thought it hadn't worked. Restarted and the installation worked.

To me this is just silly. Joomla engineers should know or at least warn us to modify that php value knowing that the installation would take longer than 30 seconds. I love Joomla and the work that those engineers have accomplished, but that's an hour of my time that I'll never get back.
VOTES:8
avatar
This worked for me, my install was hanging up on the 'creating databases' phase too. Thanks for the fix Brad!!
VOTES:1
avatar
Awesome! This did the trick
VOTES:1
avatar
Thanks a lot, works just fine..... I was stuck in that step too...
VOTES:0
avatar
hi Taun Thanx for such valuable information
VOTES:0
avatar
Thanks Brad! for the solution!
VOTES:0
avatar
"Open /xampp/php/php.ini in WordPad. Find Line with - max_execution_time=30 Change 30 to 300."

This resolved the problem. Thank you Brad!
VOTES:-1
avatar
That does not solve my problem Brad...still the @#@#! installation stalls when creating database tables
VOTES:2
avatar
im in trouble to instal joomla in xampp using in windows8. still creating database tables
VOTES:1
avatar
Hi there, I'm installing joomla 2.5 using xampp 3.2.1 and I'll follow this step but I can't move to step 5. I'm stuck in step 4 database configuration,what's the problem? btw I'm new to joomla. Thanks
VOTES:1
avatar
Hi Tuan,
Great post and very helpful. I managed to get past all the steps only to get stuck on the last one.
I now get a screen which hangs at the step that creates database tables - the blue bars just keep going.
Do you know why that is happening and how I can fix this?
Thanks
VOTES:1
avatar
hola. tengo windows vista. Tengo el siguiente problema... todo bien hasta en el segundo paso (BD) en la parte que tiene que ver con Creación de tablas de la base de datos lleva más de 40 minutos trabajando y no pasa nada... qué hice mal.... tendrá que ver con la versión de windows o con la instalación de XAMPP...
VOTES:0
avatar
Love the instructions, wish I'd found them sooner. They confirmed I was installing correctly. However, I am having the same issue with the data base table creation hanging at install, at least it seems to be. I have tried two separate Db in one a total of 6 tables loaded in the other Db about 11 loaded,
1. so how many tables total should load?
I am running Xammp as administrator, Anti virus disabled, clean install.
I know when I had installed a previous version it took about an hour and half to totally install.
I am in Win 7, 12Gb RAM, 64 bit, I7 Intel core, 2.3GHZ, and a 1TB drive so I think I have enough to handle this install. Regular maintenance and not a lot of junk so wondering why the install would be so slow?
2. Any thoughts on how to get the install to complete other than more than the 2 and 3 waits I have already done?

VOTES:0
avatar
Hello Tuan,
Left a post last night- I was stuck at database creation. Today I opened Note Pad and opened the installation folder PHP ini file and changed the "max_execution_time = 30" to "max_execution_time =300
and then went into the sql file in the installation folder and replaced all instances of "ENGINE=InnoDB" with "ENGINE=MyIsam". Deleted my browser history and deactivated the anti virus and installed the Joomla 3.3 in just under 15 minutes.
VOTES:0
avatar
Hi:
Thanks for the directions Tuan and all. And to Icegirl. I am a noob. I changed the max exec time to 300 secs in the php ini file.
Also I get an sql error on step 4. please view below:

Welcome to phpMyAdmin


Error
MySQL said: Documentation

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.


Can some one advise about this?
I see a few entries like: innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
Are all these innodb instances to be changed to myisam?(These are from the my.ini file from the config button of the MySQL under XAMPP control panel)

Many thanks...:D
VOTES:0
avatar
I am trying to install Joomla 3.1 on my localhost using XAMPP v3.2.1 and the system hangs when it tries to install the sample data that came with the Purity iii template. It will install if you choose not to install sample data. Can anyone suggest a solution?
VOTES:0
avatar
Yes it worked 4 me!!! thanks a ton to Mr. Tuan and Mr. Brad!
VOTES:0
avatar
Great post!But have trouble to install Joomla! on XAMPP using in windows7 64bit. Still creating database tables and not moving...
VOTES:0
avatar
hi!
I've installed my first Joomla site (J-site) on my lap
I've used XAMPP
but...
when I launch my site - there is site's name like this: localhost/(site name).com.ua
but I think I can make it like this: (site name).com.ua (without localhost)
I'm a beginner in this questions
what should I do if I really want to change it and make it normal: (site name).com.ua (without localhost)?
thank you for your support!

VOTES:0
avatar
any one please help me!!!
i got error of "object not found" when installing joomla
i followed each step and after entering "localhost/joomla30" url in browser
i got error of object not found
so please help!!!!
i want to work with joomla!!
please!!
VOTES:0
avatar
Brad, you are a prince. Why Joomla doesn't hire you to fix the problem of the inability to load all the tables is beyond me. But, anyway, many thanks -- php.ini to 300 and restart xampp. You are the man.
VOTES:0
avatar
Hello, I am having same problem in installation of Joomla step 3. Installation does not goes any further and the status remain same as Creating Database Tables. I have started XAMPP as adminstrator, and also changed xampp/php/php.ini file and changed 30 into 300.
VOTES:0
avatar
I am facing similar issue as Imran . Please help me to resolve this.
VOTES:0
avatar
:(
I did everything as you wrote (describe) ,but Joomla stuck on Installation -3-rd step : @
"Overview: This step is to review all information you configured in step 1. After checking, you click “Install”." - Installing-Creating database tables ???
My configuration : xampp 1.8.3 -Joomla 330
VOTES:0
avatar
Hi Brad....
I changed max_execution_time 30 to 300 and it worked for me... thanks alot...
Brad, I just wanted to know how did you debug.. and how you got to know... I know, you might be a very experienced person but how is it that you debug.. do you go through each and every file... how it is..? how can I, a beginner in joomla become good at it..
Thanks in advance...
VOTES:0
avatar
after editing the php.ini it keeps redirecting to the overview page
VOTES:0
avatar
Hi Tuan,
Your job is great. A big hug for you:D
VOTES:0
avatar
I had the same problem with the blue lines when installing the databases. I stopped MySQL, changed the timeout to 300 as described above, set the config to delete the old databases, and then went for a coffee. When I got back it had worked.
Oh, just to be on the safe side I ran both XAMPP and the XAMPP control panel as administrator
VOTES:0
avatar
The installation gets stuck on creating databases
VOTES:0
avatar
Wow what an easy guide. Thank you so much Tuan for this wonderful contribution. I really appreciated your work. *Stay Smily*
VOTES:0
avatar
XAMPP control panel mysql and apache start but "http://localhost" not start. when typing "http://localhost" in Firefox display this masseg "unable to contact"
VOTES:0
avatar
please help me anybody joomla is not install in my localhost only 41tables are stored in my database..... how to solve this problem (my o.s are windows 8.1 xampp 3.2.1)
VOTES:0
avatar
nice explanation...
VOTES:0
avatar
pls having some problem with installing joomla am on d second step it says could not connect to the database connector returned number:could not connect to mysql
VOTES:0