How to create a database using cPanel [video]

→ Are you a new visitor? Please visit the page guidance for new visitors ←

Databases are used by many scripts to store a lot of information simply and easily. Instead of using thousands of files, a script can use a single database with multiple tables.

Creating the database using cPanel

1. Login to your cPanel account
2. Click on MySQL Databases
3. On Create New Database, write your new database name (ex. forum)
4. Then click on Create Database

A new database will be created with full name cpaneluser_database and is ready for use.

Creating a mysql user and assign it to your database

  1. Login to your cPanel account
  2. Click on MySQL Databases
  3. On Mysql Users, write your new user (ex. forum) and enter a password for it
  4. Then click on Create User
  5. Now on Add User To Database select your database and the user and click Submit
  6. On the new page add the privileges of the user to your database and click Make Changes

A video tutorial about all this is here:

Deleting a database

1. Login to your cPanel account
2. Click on MySQL Databases
3. On Current Databases there will be a list with your existing databases.
4. Click Delete Database from Actions column to delete the database

Removing a database means total removal of this database, so before deleting any database you should always have a backup.

Request an article ←