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 "Manage My Databases ".
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 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 ...
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: ...
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 create a PostgreSQL database
Here is a step-by-step guide to creating a PostgreSQL database on your hosting. 1. Login to cPanel: Access cPanel using your user credentials and password provided by your hosting provider. 2. Locate the “Databases” section: In the main cPanel ...