Create MySQL/MariaDB database in cPanel


EXPERIENCING PROBLEMS WITH OUR SERVICES? RUN A DIAGNOSE FIRST TO SAVE YOURS AND OUR TIME

Added: 10.03.2014 23:26:29     Last updated: 13.01.2017 16:24:16

This guide details how to proceed to create a MySQL/MariaDB database in cPanel using database wizard.

Step 1:
Click on the icon for "MySQL database Wizard" as shown in the screenshot below:

MySQL database Wizard icon in cPanel


Step 2:

  1. Type desired name for the database.
  2. Go to the next step.
Type the name of database

Step 3:
To use a database there must be a user connected to it, and the user must have the correct rights.

  1. Type desired username.
  2. Type desired password twice.
  3. Click to create the user.

Create database user in cPanel


Step 4:

  1. Tick off if the user should have all rights to the database. In most cases, this will be the best choice. Unless you have specific requirements, you can pick this.
  2. Certain accesses can be added/removed from the user if needed.
  3. Click to move on.
Add database user to database in cPanel

Step 5:
The screenshot below will show when the last step has been completed, and recaps which database has been created and which user you have given access to. Click on "Go back to MySQL databases".

Completed adding user to database in control panel


Step 6:
Under the main menu for MySQL databases you will now see the database we have created, the user which is associated with it, and you can change names and delete the database directly from here.

List of database and users in cPanel


Step 7:
If you need to create more users and/or add users to the database, this is done on the same page.

  1. Add new user with name and password, like we did under "Step 3", and click "Create user".
  2. Choose which user to add to which database.
  3. Click "Add". Next window will be the same as under "Step 4", and there you can set the desired rights the new user should have to the database.

 

Adding MySQL database users in control panel


Done
We have now been through how to create a new database with associated user, as well as how to make changes in these via cPanel.