Joomla 3 Pre-install Tasks
Before commencing the actual installation of Joomla CMS on your webhost you have to create:
- A MySQL database
- A MySQL user ( with password based access to the MySQL database )
- 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
The webhosts cPanel’s Login page will be displayed in the Browser as shown in 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.
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.
Creating The MySQL Database
To create the MySQL Database locate the Create New Database section as shown in 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.
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.
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.
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.
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.
|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
|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.
On click of Create User, an Added user <user name > with Password message will be displayed as shown in 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.
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.
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.
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.
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.
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.