How to add, delete or rename database in cPanel

by WPChase Editorial

A database or databases are very important when running some functions of your website, especially if you are using a content management system CMS like WordPress, Joomla, Magento, Drupal just to name a few. CMS often offers several key features, these may vary from CMS to another, but the core functions are often common and include; indexing, search and retrieval, format management, revision control, and publishing.

They all depend on databases, and the biggest is MySQL. Databases are thus a collection of information that is organized so that it can be easily accessed, managed and updated.

If you are using a tool that needs a database, your hosting company would give you the cPanel which has several advantages including the database wizard.

This wizard guides you through the setup of a MySQL® database, user accounts, and user privileges. We recommend that you use this wizard to create your first database and user.

How to create or add a new database

To create additional databases or users, you can also use the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases).

How to Fix WordPress Error Establishing a Database Connection

To set up a database, perform the following steps:

  1. In the New Database text box, enter a name for the database and click Next Step.

    Note:

    The system limits the database name to 64 characters. However, due to the method that cPanel & WHM uses to store MySQL database names, each underscore character requires two characters of that limit. Therefore, if your hosting provider enabled database prefixing, the maximum length of the database name is 63 characters, which includes both the database prefix and the underscore character. Each additional underscore requires another two characters of that limit.

  2. In the Username text box, enter a name for the user who you wish to allow to manage the database.
  3. Enter and confirm the new password in the appropriate text boxes.

    Notes:

    • The system evaluates the password that you enter on a scale of 100 points. 0 indicates a weak password, while 100 indicates a very secure password.
    • Some web hosts require a minimum password strength. A green password Strength meter indicates that the password is equal to or greater than the required password strength.
    • Click Password Generator to generate a strong password. For more information, read our Password & Security documentation.
  4. Click Create User.
  5. Select the checkboxes that correspond to the privileges that you want to grant the user, or select ALL PRIVILEGES.
  6.  Click Next Step.

The system displays a message that states that you successfully set up the database and user account.

After the database setup process is complete, select one of the following options:

  • Add another database — Click to return to the beginning of the MySQL Database Wizard interface to add more databases.
  • Add another MySQL Databases User — Click to open the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases) to create additional user accounts and assign them to a database.
  • Return to Home — Click to return to the cPanel Home interface.

Note:

When you use the MySQL Database Wizard interface to add a user and a database, the system automatically grants the user access to the database. You do not need to use the Add User to Database feature in the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases).

How to rename a database in cPanel?

1. Log into your cPanel account.
2. In the “Databases” section, click on “MySQL Databases” Icon.
3. Under “Current Databases“, You can see a list of your all databases. Locate the Database and then click on “Rename” Icon.
4. Change the database name and then click on the “Proceed” button.

How to delete a database in cPanel?

1. In the “Databases” section, click on “MySQL Databases” Icon.
2. Under “Current Databases” you can see a list of all your databases. Locate the Database you wish to remove and then click on the “Delete” icon.
3. Click on the “Delete Database” button.
4. When you see a warning, click on the “Delete Database” button.

How to add a new user to a database and add privileges?

Once logged into your cPanel account.
1. In the “Databases” section, click on “MySQL Databases” Icon.
2. Scroll down to the end of the page and under “Add User to Database“, select a user from the dropdown list, and then choose a Database from the list.
3. Click on the “Add” button.
4. On “Manage User Privileges“, mark the box “ALL PRIVILEGES” and click on “Make Changes“.
These are just some of the basic steps to manage databases using the cPanel database wizard. Hope you found this helpful.

We have tonnes of other tutorials and notes for you.

Wonderful!, just before you go: Please subscribe to our website for the latest tips, ideas, and recommendations to make your WordPress site wonderful.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 152 other subscribers

%d bloggers like this: