Linode Library Home
Linode Library RSS Feed
Home :: Web Applications :: Control Panels :: cPanel
Print View View Source

Managing Domains and Databases

Published: by

cPanel is a commercial web-based control panel that simplifies many common system administration tasks such as website creation, database deployment and management, and more. This guide shows you how to manage your domains and databases with your cPanel user account. All of these instructions pertain to the user login located at port 2082 (2083 for SSL connection).

Contents

Managing Domains

There are three types of domains associated with your cPanel account: main domains, addon domains, and parked domains. Your main domain cannot be changed except by the reseller that owns your account or by root itself. Subdomains, addon domains, and parked domains can be managed in the Domains section.

Note

The Domains section also allows you to add or delete A or CNAME records to your domain. Any of the default entries would need to be modified by someone with the appropriate access (e.g., the reseller that owns your account or the root user).

Subdomains

You can manage subdomains in the cPanel > Domains > Subdomains section. To add a subdomain, enter the subdomain in the Subdomain field, and then click in the 'Document Root' field. A location will automatically be entered for you, as shown below.

cPanel subdomain screen.

After you add the subdomain, you can click the Go Back button to manage your subdomain's redirection or remove it entirely, as shown below.

cPanel subdomain screen.

Addon Domains

If you have the ability to use addon domains, you can manage those through the cPanel > Domains > Addon Domains section. Addon domains allow you to host other domains on your single cPanel account login and serve different content than what is served for your account's main domain. The interface is similar to the subdomains screen with a few extra fields, as shown below. A new FTP account is created for each addon domain as well.

cPanel addon domain screen.

After you add the addon domain, you can click the Go Back button to manage your addon domain's redirection or remove it entirely, as shown below.

cPanel addon domain screen.

Parked Domains

Parked domains allow you to point other domain names at your account. They then serve the contents of the domain you park them on top of:

cPanel parked domain screen.

After you add a parked domain, you can click the Go Back button to manage your parked domain's redirection or remove it entirely:

cPanel parked domain screen.

In the above example, the parked domain 'mynewdomain.com' is serving the content of your primary cPanel domain. You can modify this to serve whatever domain content you like. To instead serve the content of your addon domain "example2.com", click the Manage Redirection button and enter example2.com into the field shown below.

cPanel parked domain screen.

Creating Databases and MySQL Users

The Manage Databases icon under the Databases section of your cPanel will allow you to create databases, create users for those databases, add users to databases, and specify the permissions each user should have. Let's start by creating a database.

cPanel manage databases screen.

Now that you've created a database, you'll need a user to access it. You can add a user below the add database section, as shown below.

cPanel manage databases screen.

After you've created the user, you can add the user to the database at the bottom of the MySQL Databases page, as shown below.

cPanel manage databases screen.

Once you select which users to add to the database, click the Add button. On the next screen you will be able to select what privileges the user will have to the database. You can select them individually, or select the All Privileges checkbox at the top, as shown below.

cPanel manage databases screen.

Managing Databases

Now that you've set up your database and user, you can start managing your database. cPanel includes phpMyAdmin for database management. Here's how to access phpMyAdmin:

  1. Click the Home button at the top of the page then scroll back down to the Databases section of cPanel.
  2. Click the phpMyAdmin icon to open the phpMyAdmin interface in a new window.
  3. On the left side, you'll see a list of your databases. Select the database you want to open, as shown below.
cPanel phpMyAdmin screen.

You can now begin working on your database. If you have an .sql file you would like to use to set up the database and populate it, select the Import tab at the top of the screen. You will be able to browse to your .sql file and upload it to be imported into your database.

More Information

You may wish to consult the following resources for additional information on this topic. While these are provided in the hope that they will be useful, please note that we cannot vouch for the accuracy or timeliness of externally hosted materials.

Creative Commons License

This guide is licensed under a Creative Commons Attribution-NoDerivs 3.0 United States License.

Last edited by Matthew Cone on Friday, June 8th, 2012 (r2922).