Joomla is a dynamic CMS and so it needs a database to install Joomla. To create a database refers to create the actual database (which holds the data) and to create a database user (which accesses the data). After creating these two, we need to give permission to communicate them. This tutorial represents the database creation on the cpanel of your web hosting account.
Note: When you create database, make sure to record the database name, the database username and the database user password because we must have to type them as part of the Joomla installation process.
To create the database and the database user using webhosting cPanel:
Follow the following steps to create the database and the database user:
Step 1: Login to your web hosting's cPanel account, using the cPanel username and password.
Step 2: After successful logged in, go to Databases section and click the MySQL Databases link to start creating database for your Joomla website. See the following figure for details.
Step 3: At the top of the MySQL Databases dialog page, there is a box for creating a new database. Type the name of the database that you would like to create. For example, we name the database as “joomla” and click the Create Database button.
When you have completed to create the database, make sure that you write down the name of your database. Note that for this web host, the actual database name is not “joomla”, instead it is “hidemytips_joomla,”. Here “hidemytips” being the cPanel username for this hosting account. You will see, your own account name here.
After you have created the database, click the Go Back button at the bottom of the page to go to the MySQL Databases page.
Step 4: Now, we would create a database user via the boxes further down the MySQL
Databases dialog. Just type a username and password and then click the Create User button to create a user with a password.
When you have completed the above tasks then write down the username and password as these information will be required Joomla installation time. Moreover, note that the cPanel username is placed in front of your username, separated by an underscore. In this case, the database username becomes hidemytips_admin. For your hosting account, it just replaces the cPanel login name.
After you have created the database, click the Go Back button at the bottom of the page to go to the MySQL Databases page.
Step 5: We have completed the creation of a database and a database user. Now, we must associate the user with the database. To do this, just further down on the MySQL Databases dialog, in the Add User to Database section, select the username (hidemytips_admin) and database name (hidemytips_joomla) from the drop-down list boxes and click the Add button. All the steps are depicted in the following figure.
Step 6: After completing the above steps, we will be the page of MySQL Account Maintenance page which is used to Manage User Privileges. Here, you must have to select All Privileges. Again, I am mentioning you that select all the privileges as we will use the user as the main user of our database during Joomla installation. Now, click on Make Changes button to apply all the privileges to the database user to the corresponding database.
Click the Go Back button at the bottom of the page and this will return us to the MySQL Databases dialog.
After the above step, you will see the database table which confirms that you’ve created the database and the user and associated them.
