What is a database?

A database is an organized collection of data that is accessed, managed and updated electronically by a computer system. A database is basically made of database objects such as tables, indexes, stored procedures etc. Read more about databases here.

phpMyAdmin is a free web based MySql database administration tool written in Hypertext Preprocessor (PHP) language.

This tutorial assumes that you’re already logged into your cPanel.

How to create a database

1. Clink on MySql Databases option under DATABASE section.
2. In the Create New Database section, type the name of the database.
3. Click on Create Database button.

Create Database user.

1. Type database user’s username in the username section.
2. Type a password for this user. You can also use the inbuilt password generator option.
3. Click on create user.

Add user to database.

1. Scroll down to Add User To Database section.
2. Select the user created above.
3. Select the database created earlier.
4. Click on Add button.
5. Select all the privileges you wan this user to have on the database.
6. Click on Make changes to Fish the process.