Creating a database in cPanel panel with MySQL Database Wizard

Tutorials cPanel | cpanel | database | database | mysql | wizard
In this article we explain the steps for creating databases in the cPanel panel using the MySQL Database Wizard application
by Mihai BobriucViews 44Updated now 3 monthsPublished 13/07/2022

Introduction

In this tutorial we are going to introduce you to the necessary steps for creating MySQL databases in the cPanel panel using MySQL Wizard.

Requirement

The login details of the hosting package.

Steps

Access the cPanel administration panel, log in with the administration data (user/password) provided by Hostico is performed, and after the successful login we go to the Databases section from which we will click on the MySQL Database Wizard.

Sectiune Baza de date

- Getting there, they will have to follow a few steps:

1: Create A Database → fill in the database name (up to a maximum of 54 characters) after the prefix that is automatically assigned according to the cPanel userThe created database will be of the form: prefix_namebase

Creare baza de date

2: Create Database Users

fill in the user name for the database (up to a maximum of 7 characters) after the prefix that is automatically assigned according to the cPanel user

Also here you fill in the password for this database user or you can automatically generate a secure password using the "Password generator" button, password that you will have to copy and save in a safe place → then press the "Create User" button

The user of the created database will be of the form : prefix_username

Creare utilizator baza de date

These three elements (database name, username and password) you will use further for the configuration file of the website in the login section of the website with the database.

 

3: Add user to the database → here you will select all the permissions with the option "ALL PRIVILEGES " that the user will use to communicate with the database, in this way the user will automatically attach himself to that database → then press the button “Next Step”.

Selectare privilegii

4: Complete the Task → we have successfully completed the creation of a database, the user with a password for it, and we have performed their coupling with the related permissions for writing/reading information in the database tables.

Finalizare creare baza de date

→ Also here we can click on the options:

Add another database” → to create another database from the beginning using the same steps;

Add another user for your MySQL database” → to add a second user to the previously created database;

Return to MySQL Databases” → to go back to the viewing section of databases already created;

Return Home” → to return us to the main page of the cPanel panel;

Similar Articles

14
Creating a mailbox in cPanelTutorials cPanel | email | cpanel | add
The cPanel panel allows the creation of an unlimited number of email boxes associated with hosted domains. This tutorial will explain the necessary steps to create and access an e-mail box.
by Mihai BobriucViews 1345Updated now 28 daysPublished 28/06/2017
5
Enabling Cloudflare services in cPanelTutorials Cloudflare | cpanel | cloudflare | protection
This article will describe the steps required to enable Cloudflare services for domains hosted on your cPanel control panel
by Mihai BobriucViews 607Updated now 29 daysPublished 26/09/2017
1
Adding an MX record to the cPanel admin panel, redirecting your mail server to GoogleTutorials Email | mx | mx records | mx registration | dns | email
How to add MX Records and forward mail to the Google mail server
by Mihai BobriucViews 707Updated now 28 daysPublished 21/07/2017
1
Adding an addon domain in cPanelTutorials cPanel | cpanel | domain | addon
The process of adding an addon domain in cPanel
by Ana RednicViews 303Updated now 2 monthsPublished 31/01/2018
1
Enable DNSSEC in ROTLDTutorials Domains | dnssec | domain | rotld
This tutorial will describe the steps required to enable DNSSEC on a .ro domain in the ROTLD panel
by Ana RednicViews 246Updated now 2 monthsPublished 25/10/2018