Joomla/C2/Installing-Joomla-on-Windows/English-timed

Time	Narration
00:01	Welcome to the Spoken Tutorial on Installing Joomla on Windows.
00:07	In this tutorial, we will learn to: obtain Joomla, create database and install Joomla.
00:16	To install Joomla in your system, you should have a system supporting: Apache 2.x or IIS 7 (or any higher version), MySQL 5.0.4 (or any higher version) and PHP 5.2.4 (or any higher version).
00:38	Please note that MySQL 6 and higher versions are currently not supported.
00:45	Web server distributions give you Apache, MySQL/MariaDB and PHP bundled in one.
00:53	You can either install these separately or use a web server distribution like XAMPP, WAMPP or LAMPP.
01:02	To record this tutorial, I will be using: Windows 8 OS, Joomla 3.7.2, Apache, MySQL and PHP obtained through XAMPP 5.6.28.
01:19	First of all, let us check if XAMPP is installed on our machine.
01:24	Click on the Windows icon on the keyboard and type: XAMPP.
01:29	If you do not get any result, XAMPP is not installed.
01:34	You have to do the XAMPP installation.
01:37	Refer to the XAMPP installation tutorial in the PHP & MySQL series on this website.
01:44	Follow the instruction given in this tutorial to install the latest version.
01:50	While recording this tutorial the latest version is 5.6.28.
01:56	I have already installed XAMPP on my machine.
02:00	Click on XAMPP Control Panel.
02:03	Start the Apache and MySQL services by clicking on START button on the respective services.
02:11	To stop the services, we have to click on STOP button.
02:16	You may get some error messages like:
02:19	“Apache shutdown unexpectedly”.
02:22	Or, “Port 80 in use for Apache Server'”.
02:26	Or, “Unable to connect to any of the specified MySQL hosts for MySQL database.”
02:34	This is because the default ports allotted for Apache and MySQL is taken by other software.
02:42	Default port number for Apache is 80 and for MySQL is 3306.
02:51	To change these ports, refer to the XAMPP Installation tutorial in the PHP & MySQL series on this website.
02:59	Allot proper port numbers before proceeding further.
03:04	Once you have installed and started XAMPP, switch to the browser.
03:09	In the address bar, type: localhost to see your XAMPP home page.
03:15	In the menu on the top right of the page, click on phpinfo().
03:21	Now, press CTRL+ F key and search for DOCUMENT underscore ROOT.
03:28	It will be something like C:/xampp/htdocs depending on where XAMPP is installed in your machine.
03:37	Please make a note of this because we will need to install Joomla in this particular folder.
03:44	Now, let us download Joomla.
03:47	Go to Joomla official website: http://www.joomla.org.
03:54	Click on Download & Extend in the top menu.
03:59	Click on Joomla Downloads and then click on “Download Joomla 3.7.2 Full Package, ZIP”.
04:10	Immediately, a small dialog box will open.
04:14	Here click on Save File option. Then click on OK button.
04:22	This will download Joomla.
04:25	At the time of making of this tutorial, latest stable version is 3.7.2.
04:32	I have already downloaded this file and it is in my Downloads folder.
04:37	Let us go to the Downloads folder. Here, is the file which we downloaded.
04:44	Right-click on the zip file and select Extract All.
04:49	Then click on ‘Browse’ to choose the destination.
04:53	Now, we have to paste the folder in the webservers root directory.
04:59	Browse to the location C:\xampp\htdocs.
05:06	Click on ‘Make a new folder’ and type: ‘Joomla’.
05:12	Click on OK. Then click on ‘Extract’.
05:18	This will create a new folder by name Joomla and extract the contents of the zip file.
05:26	Before we go ahead with the installation, we need to create a database for Joomla.
05:33	We will do this in phpmyadmin.
05:37	Phpmyadmin is the graphical user interface for MySQL.
05:43	And it comes along with XAMPP installation.
05:47	Switch to the browser and go to the XAMPP homepage.
05:52	On the top right of the XAMPP page, you can see a link to phpmyadmin. Click on that.
06:00	Click on User accounts in the top menu. Scroll down and then click on Add User account.
06:10	Enter a username, say, Joomla hyphen 1
06:15	From Host dropdown list, select Local.
06:19	Enter a password in the Password text-box, say joomla123.
06:25	You can enter any password of your choice.
06:29	Enter the same password in the Re-type textbox.
06:33	Please do not respond to Generate Password prompt for now.
06:38	Under Database for user account, we can see the option,“Create a database with the same name and grant all privileges.”
06:49	We will check that option and scroll down to the bottom of the page.
06:55	Click the button Go at the bottom right of this page.
07:00	This will create a new database with the name Joomla hyphen 1 and with a user Joomla hyphen 1.
07:08	Make a note of the username, password and database names.
07:13	These will be required later to complete the Joomla installation.
07:18	Please note: Database name and username need not be the same.
07:24	To have different names, you can first create the database and then create a user for that database.
07:32	Also, as per naming convention, username should not have any spaces in between.
07:39	We are now ready to install Joomla.
07:42	We have XAMPP running and our database is ready.
07:47	And we have extracted Joomla into the folder joomla, in DOCUMENT underscore ROOT.
07:54	Go to the browser.
07:56	In a new tab, type: localhost slash Joomla.
08:01	Please note that Joomla is the folder into which we extracted.
08:06	Press Enter and you will see the Joomla installation page.
08:11	By default, we are in step number one, that is, Configuration.
08:17	Joomla can be installed in multiple languages.
08:21	We will select English (United states) here.
08:26	Scroll down to see the Main Configuration section.
08:30	Enter the Site name that you want your website to have.
08:34	I will have it as "Digital India".
08:38	We will leave the description blank.
08:41	Email-id is a compulsory field. Please enter a valid email-id here.
08:48	I will give the id as "priyanka@spoken-tutorial.org".
08:55	Next, enter the username that you want for the Joomla Administrative page.
09:01	I will enter the username as admin.
09:05	Enter a password for the Joomla Administrator.
09:09	I will enter admin123 as my admin password.
09:14	Re-type the password in the confirmation box.
09:19	In Site Offline (Yes/No), please select No.
09:24	Now, click on the Next button at the bottom-right.
09:29	So, we come to the Database Configuration page now.
09:33	Select "MySQL" as the Database Type.
09:37	Enter "localhost" as the Host Name.
09:41	Now, we have to enter the username, password and database names.
09:47	These are the ones we created earlier, in phpmyadmin.
09:52	I will enter Joomla hyphen 1 as the username.
09:57	Note capital letter J in joomla.
10:01	Then joomla123 as the password
10:05	and Joomla hyphen 1 as the database name.
10:09	Leave the Table Prefix as it is.
10:13	In Old Database Process, select Backup.
10:17	This is to take backup of tables with identical names as in the database, when Joomla is upgraded.
10:25	Click on Next button at the bottom right.
10:29	We are now in the Finalisation and Overview page.
10:34	In the Finalisation section, locate Install Sample Data.
10:39	By default, one of the radio buttons will be selected.
10:43	The options listed here, will install some sample articles, menus, plugins etc. on the site.
10:52	These are useful for a beginner to understand Joomla.
10:56	You may choose one of the options, when you are installing Joomla for the first time.
11:00	I do not wish to do so. So, I will choose the None option.
11:06	Scroll the page below and check the Overview information displayed here.
11:12	Now click on the Install button on the bottom-right.
11:17	This step may take some time.
11:20	Once done, we will see the message "Congratulations! Joomla is now installed".
11:27	Scroll down and see, there is a Remove Installation Folder button.
11:32	Click on it to remove the installation folder.
11:36	If we get an error in this step, we must remove the folder manually.
11:41	After successful removal of the installation folder, click on site button.
11:47	We have reached our website!
11:50	Since I did not install the sample data, I do not see menus, articles etc., right now.
11:57	Let's go to the administrator page.
12:00	In the URL, type: localhost slash Joomla slash administrator.
12:07	Press Enter.
12:09	Login with the administrator login and password.
12:13	I will type: admin as username and admin123 as password.
12:19	Click on ‘Log in’ button.
12:21	As our website is installed, we have the administrator access.
12:27	Let us summarize.
12:29	In this tutorial, we learnt to: download Joomla from Joomla website, create database in phpmyadmin and install Joomla on a Windows machine.
12:42	The video at the following link summarizes the Spoken Tutorial project. Please download and watch it.
12:49	The Spoken Tutorial Project team conducts workshops and gives certificates.
12:56	For more details, please write to us.
13:00	Do you have questions in THIS Spoken Tutorial? Please visit this site http://forums.spoken-tutorial.org.
13:06	Choose the minute and second where you have the question. Explain your question briefly. Someone from our team will answer them.
13:16	The Spoken Tutorial forum is for specific questions on this tutorial.
13:21	Please do not post unrelated and general questions on them. This will help reduce the clutter.
13:29	With less clutter, we can use these discussion as instructional material.
13:35	Spoken Tutorial Project is funded by NMEICT, MHRD, Government of India. More information on this mission is available at the link shown.
13:47	The script is contributed by priyanka. This is Nirmala Venkat, signing off.

Contributors and Content Editors

PoojaMoolya, Sandhya.np14, Venuspriya