Knowledge Base

Manage MySQL Database on Linux-Based Hosting

This article explains how databases are used and managed in Linux-based hosting environments, including when manual database creation is required and how to perform basic database management tasks.

In Linux-based hosting environments, websites and applications like WordPress rely on a database system — MySQL — to store and retrieve data.

When do you need to create a database manually

In many cases, databases are created and configured automatically during the installation of applications such as WordPress and Joomla. However, there are situations where manual database setup and management are required.

You create a database manually in situations like the following:

The application or website does not include an automatic database creation process during installation (e.g. manual WordPress installation).
The website requires an existing database to be imported, restored, or rebuilt from a backup (e.g. WordPress site migration).

How to create MySQL database manually

Our Current Linux Hosting plans allow you to create a MySQL database using either the Linux Control Panel or cPanel. Classic hosting plans support database creation through cPanel only.

Go to your Linux Control Panel.
Select any of your websites and click on SETTINGS. This opens the Linux Website Manager.
Click on the Advanced tab.
Look for the Databases and click on MANAGE.
Click on ADD DATABASE.
Enter a database name and click on ADD DATABASE. The new database will appear on the database list.
In the Users column, click Add User. This opens the Add user panel.
In the Select user option, select + Create a new user.
Enter a username and password for your database user.
Select all User privileges.
Click ADD USER to save the changes.

Your database is now created. You can now use it to your application installation, or you can import a database backup file to it.

Log in to your cPanel.
Scroll down to Databases section.
Click on MySQL Database Wizard.
Enter a database name, then click Next Step.
Enter a username and password for your database user and click Create User.
Select all privileges and click Next Step.

Your database is now created. You can now use it to your application installation, or you can import a database backup file to it.

Accessing your database using phpMyAdmin

The phpMyAdmin is a web-based tool used to view, manage, and modify your database content.

Go to your Linux Control Panel.
Select any of your websites and click on SETTINGS.
Click on the Advanced tab.
Look for PHPMyAdmin and click MANAGE. This will open the phpMyAdmin.
On the left side, click the database that you want to manage.

Here, you'll see your database content.

Log in to your cPanel.
Scroll down to Databases section.
Click on phpMyAdmin. This will open the phpMyAdmin.
On the left side, click the database that you want to manage.

Here, you'll see your database content.

Importing a database

The import function is used to restore, or transfer databases between environments. You must have the database backup file to do this.

Go to your phpMyAdmin.
On the left side, click on the empty database that you want the backup database file imported.
Click on the Import tab.
Click Choose File and select the database backup file on your computer.
Once done, scroll down and click on Import.

There you go, you can now use the database to your website.

Exporting a database

Export your database and download it to your computer as a backup.

In your phpMyAdmin, click on the database that you want to export.
Click on the Export tab.
Keep the format in SQL.
Click on Export.

Your database file is now downloaded on your local computer.

Did you find this article helpful?