This website uses cookies in order to offer you the most relevant information and services online. Please accept cookies for optimal performance.
Learn More

Creating and Managing MySQL Databases with cPanel on Linux

This article provides the detailed information on how to create and manage databases with your Linux cloud control panel.

Type the cPanel access details received from 'Batoi Support' in your browser and press enter. You will find the login screen for your hosting control panel. Type your control panel 'Username' and 'Password' of your hosting to login to the home page.
Note: To know more on how to access hosting control panel follow the steps in our help article here.

Figure 1
Figure 1

After successful login, you will land on the home page of the control panel. From the home page click 'MySQL Databases' under category 'Databases' as shown in Figure 2.

Figure 2
Figure 2

The system will take you to the database creation page as shown in Figure 3. Here, enter the name of the database that you want to create in the 'Create New Database' section and click the button 'Create Database'. The system will create a new database with the name provided by you as shown in Figure 3.

Figure 3
Figure 3

After you create the database, the system will give you a confirmation screen with the name of the database as shown in Figure 4. From the screen you can click 'Go back' button and the system will take you to the database home page.

Figure 4
Figure 4

Now in the database home page you can see your newly created database in a tabular format. At this point no user has been assigned to the database. To add a new user, go to database home page in your control panel. Then go to 'Add New User' section. Give your desired 'User Name' as shown in Figure 5.

Figure 5
Figure 5

Now click the button 'Password Generator' to have a strong password generated for your user as shown in Figure 6. After generating the password, check the checkbox for 'I have copied this password in a safe place' and then click the button 'Use Password' and system will use the password for your user. Alternatively, you can also manually enter a password that you like as per your requirement.

Figure 6
Figure 6

After entering the password click the button 'Create User' and system will create a new user for you and give you a confirmation screen as shown in Figure 7.

Figure 7
Figure 7

After creating a user, it is the time to assign the user to the database. To do so, go to MySQL home in your control panel and then go 'Add User To Database' section as shown in Figure 8. Select the desired 'User' and 'Database' from the drop-down menu and click 'Add' button as shown in Figure 8.

Figure 8
Figure 8

The system will then open a page as shown in Figure 9. Click the checkbox 'All Privileges' and click the button 'Make Changes' to apply all changes made to the page as shown in Figure 9.

Figure 9
Figure 9

Upon doing so, the system will give you a confirmation screen that the user has been added to the database as shown in Figure 10.

Figure 10
Figure 10

Manage databases through phpMyAdmin

Type the cPanel access details received from Batoi Support in your browser and press 'Enter'. You will find the login screen for your hosting control panel. Type your control panel 'Username' and 'Password' of your hosting to login to the home page.

Figure 11
Figure 11

Note: The 'Username' and 'Password' to log into cPanel shall be provided to you by 'Batoi Support' after you sign up for hosting services at Batoi. If you do not have the correct login credentials, please contact 'Batoi Support' via phone or create a support ticket for help.

After successful login, you will land on the home page of the control panel as shown in Figure 12. From the home page click 'phpMyAdmin' under category 'Databases'.

Figure 12
Figure 12

Upon clicking the link, system will open 'phpMyAdmin' in a new tab as shown in Figure 13.

Figure 13
Figure 13

Here you can find the list of all the databases that has been created under your hosting on the left side of the page. Choose the database which you want to download and click 'Export' link from the top menu. After clicking the link, system will open the export database page as shown in Figure 14. Click the 'Go' button and the database will be downloaded to your local system.

Figure 14
Figure 14

Now you can upload the database to another location. To do so, click the database to which you want to upload your database dump file and then click 'Import' link from the top menu as shown in Figure 15. After clicking the link, system will open the import database page as shown in Figure 15. Click the 'Browse' button and select the database dump file that you want to upload. The database dump file should be in the '.sql' format. After choosing the database from your local system click the 'Go' button and system will upload the database to your hosting.

Figure 15
Figure 15

Now when you click the database name from the left side of your 'phpMyAdmin', it will show all the tables that have been uploaded to your database as shown in Figure 16.

Figure 16
Figure 16

Give your feedback to improve the article

Latest Product Updates

Get the latest news and updates about Batoi Products - articles and product releases.

Need our assistance? We are available with you.

Existing Customer?
Get Support
Talk To Consultant?
Get An Appointment
Contact Us

Batoi global offices and contact details

Stay Connected

Join our community, newsletters, and social media.

Batoi's Annual Cloud Conclave is coming soon. Please watch out.