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" section, click on "MySQL® Database ".

Step 2 

Here, you must type the database name, then click at "Next Step".

Step 3 

NOTE: If everything worked so far, you will see a success message in the upper corner of your screen.

Now, you need to create a database user. Fill in the username and password (it needs to meet the security requirements), you may also use the "Password Generator" if you want to.

Then, click on "Create User".

Step 4 

Now, you need to assign access privileges to your newly created user, or grant him all privileges by clicking on "ALL PRIVILEGES".


When you are done, click on "Make Changes".



A success message should be displayed.

• Related Articles

• How to upload a firebird database to your hosting acount

  If you already have a Firebird database and want to host in our host account, just follow these steps: 1- Save/export your local firebird database with your cpanel username and password (the first one that was sent to your email) as the owner ...

• 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: ...

• How to change the charset of MySQL server

  To change the MySQL charset, follow the steps below: 1. Access the phpMyAdmin option in the Database section of your cPanel 2. Check the current server charset  3. Go to Settings, select Features and then Database tab, change the server charset in ...

• Import a CSV file to MYSQL via PHPMYADMIN

  I was given access to an existing instance of MySQL via phpMyAdmin. My task was to import a CSV file using the import feature on phpMyAdmin. First, I went to the the main phpMyAdmin page. Next, I clicked on the database instance that I am interested. ...

• JetBackup 5 - Database Users : How to restore a database user

  Jetbackup 5 has a new interface, with better usability and new options, making it easier to search for specific items. In this article we will see how to restore a database user from a cPanel account. First we must access cPanel and navigate to the ...