OpenSourceVarsity

pdf icons

Joomla 3 Pre-install Tasks

Before commencing the actual installation of Joomla CMS on your webhost you have to create:

  1. A MySQL database
  2. A MySQL user ( with password based access to the MySQL database )
  3. Grant the MySQL user Super User privileges on the MySQL database created

This is done using the webhosts – cPanel.

Just enter the URL for your website followed by /cpanel in the address bar of your favorite browser and hit GO or the Enter Key, as shown in diagram 1
Eg: http://<www.mywebsiteurl.con>cpanel

Browser Diagram 1

The webhosts cPanel’s Login page will be displayed in the Browser as shown in diagram 2.

Login Screen Diagram 2

Enter the Username and Password given to you by your webhost ( or created by you at the time when you set up your new hosting account ) in their respective textboxes and click Log in.

The webhost’s cPanel, user interface, will load in your Browser as shown in diagram 3.

Panel Home Page Diagram 3

Diagram 3 is a typical cPanel user interface, via which a website owner can access a ton of tools which automates a host of website creation and maintenance processes.

NOTE: Locate the Databases section in cPanel as shown in diagram 3. Then look for the MySQL Databases icon within this section. Click MySQL Databases icon to access the MySQL Database GUI as shown in diagram 4.

MySql Database
Diagram 4

Creating The MySQL Database

To create the MySQL Database locate the Create New Database section as shown in diagram 5.

Create New Database Diagram 5

In the textbox associated with the prompt New Database enter the database name for the Joomla installation. Click Create Database to create the MySQL database as shown in diagram 6.

NOTE: The database name must be alphanumeric characters.
Example: j3

NOTE: When creating a MySQL database in cPanel, cPanel automatically adds a prefix bound to the database name using an underscore ( _ ). The prefix is basically the username used when accessing cPanel.

eg: If your cPanel username is name1. The MySQL database name will be name1_j3.

Create Database Diagram 6

On click of Create Database, a message Added the Database <database name> is displayed indicating that the database was successfully added as shown in diagram 7.

Successfully created Diagram 7

Click Go Back to go back to MySQL Database screen as shown in diagram 7.

In the Current Database section you will see the newly created database as shown in diagram 8.

Database Diagram 8

Milestone 1 is complete. A MySQL database has been successfully created.

Creating The MySQL User And Password

Now we need to create a MySQL user.

For creating MySQL User, locate the MySQL Users section in the MySQL Databases User interface as shown in diagram 9.

MySql Username Diagram 9

Username: Enter username of your choice
( We suggest using the database name itself i.e. j3)
Password: Enter password ( Keep the password at least 8 alphanumeric characters )
Ensure that there is at least one Upper case character and one numeric
eg: joomLa31
Password Again: Re-Enter the password

NOTE: Password cannot be left empty.
Passwords must be at least 5 characters long ( We strongly recommend using at least 8 )

NOTE: If your password is not strong you can click Password Generator as shown in diagram 9, which auto generates a strong password. Then copy / paste this as the password.

NOTE: Please note down the user password created carefully as this is needed when actually installing Joomla.

After filling in all the fields appropriately, click Create User as shown in diagram 10.

Username Password Diagram 10

On click of Create User, an Added user <user name > with Password message will be displayed as shown in diagram 11.

Created Diagram 11

Click Go Back to go back to the MySQL Databases screen.

In the Current User section you will see the newly created MySQL user as shown in diagram 12.

MySql User Diagram 12

Milestone 2 is completed. The MySQL User and Password has successfully been created.

Granting The MySQL User Super User Permission On The Database

Now this user has to be granted all privileges on the newly created MySQL database i.e. Super User level access.

For granting the MySQL user, super user privileges, on the MySQL database, locate the Add User To Database section as shown in diagram 13.

NOTE: If there are multiple databases created select the appropriate MySQL database name and MySQL user from the dropdown and click Add as shown in diagram 13.

Add User To Database Diagram 13

On click of Add the screen as shown in diagram 14 is displayed in your Browser.

Check / Select the checkbox adjacent to All Privileges to grant all rights and privileges on the MySQL database to the MySQL user selected as shown in diagram 14.

All Previleges Diagram 14

Click Make Changes as shown in diagram 14.

On click of Make Changes the MySQL username chosen will be added to the MySQL database with all database privileges granted to the user as shown in diagram 15.

Granted Diagram 15

Click the Go Back link to go back to MySQL Database screen.

Now locate the Current Database section and you will see the username has been bound to the MySQL database as shown in diagram 16.

Confirm Diagram 16

Milestone 3 is completed. The MySQL User has been granted all privileges on MySQL Database successfully.

Once completed an empty xxx_J3 database is ready and available for use.

The database can only be accessed by a registered MySQL user named xxx_j3, who has all rights and privileges on the xxx_j3 database.

All the pre-install Joomla CMS steps are now complete.

The installation of Joomla CMS can now begin.

April 5, 2016
Design by Ivan Bayross and Meher Bala © 2016 All Rights Reserved
X