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" ...
    • How to upload a firebird database to your hosting acount

      If you already have a Firebird database and wish to upload it to your hosting account, simply follow the following steps: 1. Save/export your local bank to hosting. 2. After sending, set a password with exactly 8 characters. The password must be ...
    • 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 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; ...
    • How to export your database in phpMyAdmin?

      To export your database on phpMyadmin, you must access phpMyadmin through cPanel.  - You must choose the database you want to export.  - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...