Summer Sale! Save 15%
on any Shared Hosting Plan & Location.
 View More

How to Create and Manage MySQL Databases

Step by Step tutorial on creating and managing MySQL databases from the Client Area

MySQL is an open source relational database management system that utilizes the Structured Query Language (SQL). MySQL Databases are used in almost every web application and provide easy to manage structured data to the applications that use them. They are usually created automatically when an application is being installed via Softaculous or have to be created prior to a manual installation and then be connected within the application’s configuration file.

 

Step 1 Access the MySQL Databases menu

To create a new Database you will need to login to your Client Area and navigate to the Products>My Products menu.

 

 

Now click on the View Details>View Details for the package you want to create the database on.

 

 

Select the MySQL Databases section from the list of options for management.

 

Accessing the MySQL Databases menu via the Client Area

 

Step 2 Create a new Database and User

Find the Create New Database section, input a name for the new database and click on the Create button.

 

Creating a MySQL Database

 

Scroll down to the Add New MySQL User and configure the new user that will be later assigned to the database you just created.

 

Creating a MySQL User

 

Step 3 Connect and Manage your Databases and Users

Now when you have both a database and a user, all you will have to do is to connect the user to the database. Right below the previous section you will find the Add User to Database option, input both values and click on the Add button.

 

Connecting a User to a Database

 

In the Current Databases list you will be able to see all of your existing Databases and the users assigned to them. Users are created with all privileges enabled, so if you wish to restrict a certain privilege for a user, you can do that by clicking on the pencil icon.

 

Opening the User Priviliges option

 

Here, you can remove the option for a user to delete entries from the database or to alter data.

 

Editing the MySQL User Privilleges

 

When you are ready, click on the Save Changes button to apply the modification. If you wish to remove the User from this Database, click on the Remove User Privileges button (not recommended).

 

Note

When you remove a user from an already configured database, it will make the database inaccessible for the application as it is connected to it via 4 factors: Database name, Username, Password and prefix.

 

To completely remove a User, find the Current Users section and click on the trash bin icon corresponding to the user you wish to remove.

 

With this, you now know how to fully manage the MySQL Databases for your websites.