How to Create and Manage MySQL Databases

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.

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.

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

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.

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.

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

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).

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.