How to create a database in cPanel

What is a database?

A database is a place where your website stores data. Think of a filing cabinet for names, posts, orders and settings. Apps like WordPress need one to work. cPanel is the control panel for your hosting account. You can make databases there with a few clicks.

You need three things: a database, a user, and a link between them. The user is like a key. The link gives the key permission to open the cabinet.

Step 1: Create the database

1. Log in to your client area. Open your hosting service and log in to cPanel.
2. Under Databases, click MySQL Databases. (Or try MySQL Database Wizard, which walks you through every step.)

   

3. Under Create New Database, type a name. Keep it short and simple.
4. Click Create Database.

   

   

5. Click Go Back.

cPanel adds your account name and an underscore in front of the name. So "shop" may become "account_shop". Note the full name.

Step 2: Create a user

1. Scroll to MySQL Users, then Add New User.
2. Type a user name.
3. Type a strong password. Use the Password Generator if you like.

   

4. Save the password somewhere safe. You will need it for your site.
5. Click Create User.

Step 3: Link the user to the database

1. Scroll to Add User To Database.

   

2. Choose your user in the first list.
3. Choose your database in the second list.
4. Click Add.
5. Tick ALL PRIVILEGES. Privileges are the actions the user may do.

   

6. Click Make Changes.

   

Your database is ready. Use the full database name, full user name and password in your app's settings. The host is usually localhost, which means "this same server".

Quick recap

• You need a database, a user, and a link between them.
• Use MySQL Databases in cPanel.
• Note the full names, including the account prefix.
• Keep the password safe.
• The host is usually localhost.