cPanel: How to manage your Database

Here, you’ll be guided how to use cPanel’s database management features. 1Byte will show you how to accomplish that in this post.

The majority of current websites would not function without a database discreetly operating behind the scenes and managing the website’s data. In other words, the database stores all of your website’s content, including all of its pages, posts, and user data. As you may think, cPanel has a rather comprehensive module for creating and managing databases.

1) Creating a new Database

If you want to set up any modern website using a CMS, you’ll need to create a database for it first.

The “DATABASES” section of cPanel has a handful of options available:

databases

Notably, cPanel supports both MySQL and PostgreSQL databases. For the sake of this post, we’ll use MySQL, however the process is essentially same with PostgreSQL.

To establish a new database, in the “DATABASES” section, click on “MySQL Database Wizard” (see above).After that, you may begin configuring your new database.

  • Set a name for your database

database name

  • Create a database user that will be used to access the database (this is required in order to work with the database later on):

database user

  • Assign the required privileges to that new database user; it’s best to select the option labeled “ALL PRIVILEGES”, like so:
database privileges
 
 

At this stage, your new database has been set. To see it, go back to the main page of cPanel and click on “MySQL Databases”.

2) Managing your Databases

To see all your databases, go to “MySQL Databases” from the “DATABASES” section of cPanel.

current databases

Each database can be renamed or deleted through the links to the right.

Additionally, you can also manage your database users there, a bit further down the page.

current database users

With this post, you’ve learned how to set up and maintain a database in cPanel, so congratulations!

END!!!