MySQL Database

MySQL Database

MySQL databases are required to run many web-based applications, such as information dashboards, content management systems, and online shopping carts.

Step 1 

Logged into your cPanel, in the DATABASE tab, locate the item “Manage My Database”

note: The item is also called "MySQL Databases" in older versions of cPanel



Step 2

Now let's create a bank. Just choose a name for this database and then click on “Create database”.

A success message should be displayed.


Step 3 

Now you must create a user to be able to use this database. Scrolling down the tab you will find the option to create a user as in the image, fill in all the spaces with the necessary information.


After clicking create the success message should be displayed again.

Step 4

Now we have to link the user to the bank. To do this, go to the bottom of the page and find the option “Add user to database”. Select the user and bank you want to link, be careful when choosing if you have more than one user or bank.



When you click add you will be redirected to the screen below, where you will choose the user's privileges.


You can change privileges in the future, just go to your databases and click on the name of the user you want to change the permission.



    • Related Articles

    • Creating a MySQL Database

      The MySQL database allows you to store a lot of information with ease of access. Before using the database, first you must create one. Also, you need to create at least one MySQL user to access the database. Step 1 At your cPanel, in the "Databases" ...

    • Establishing remote connection to the MySQL database

      Note: In this tutorial, we will be using DBeaver. 1.Open DBeaver Launch DBeaver. 2. Create a New Connection Click the "New Database Connection" button or press Ctrl + Shift + N. In the list that appears, select MySQL (you can type "MySQL" in the ...

    • How to change database charset - MySQL

      To change the MySQL charset, follow these steps: 1. Access the cPanel: Log in to your cPanel account. 2. Access phpMyAdmin: In cPanel, find the "Databases" section and click on "phpMyAdmin". 3. Select the Database: In phpMyAdmin, on the left panel, ...

    • How to upload a firebird database to your hosting acount

      If you already have a Firebird database and want to upload it to your hosting account, just follow these steps: Step 1 1. Save/export your local database with the user that accesses your hosting. The password must contain exactly 8 characters, you ...

    • How to import/export a MySQL database

      1 - In cPanel, go to “PhPMyAdmin”; Import: 2 - Click on "Import"; 3 - Click the "Choose File or File" button and select your database (.sql); 4 - Click the "Execute" button; Export: 2 -Choose the database you want to export from the list on the left; ...