List of Help Articles
Overview of Batoi Hosting Renew Your Domain Name with Batoi Protect or Lock Your Domain Name with Batoi View Action History of Your Domain Name Manage Name Servers for a Domain Name Forward a Domain Name to a Different Website Handle Privacy Protection for a Domain Name Domain Name Whois Data Reminders from Batoi Modify the Contact Details of Your Domain Name Backup Your Website with cPanel on Linux Managing DNS Records in Linux Hosting via cPanel: A Comprehensive Guide Create FTP Accounts in Your Linux Hosting using cPanel Backup and Restore Your Linux Hosting Account via cPanel Effortless 301 and 302 Redirects in Linux Hosting: A Detailed cPanel Guide How to Seamlessly Manage DNS Records with Batoi's Premium DNS Service through Your Domain Control Panel Mastering Contact Management within Batoi's Domain Control Panel Step-by-Step Guide: Managing Business/Enterprise Email via My Domain Control Panel How to Efficiently Manage Users and Assign Administrative Roles in Google Workspace A Complete Guide to Purchasing and Managing Google Workspace through Batoi Hosting Control Panel Effortless Migration from cPanel Email to Google Workspace: Your Step-by-Step Guide Setting Up Google Workspace Using cPanel: A Comprehensive Guide How to Add an SPF Record to Your DNS Settings for Email Security Setup of Microsoft Office 365 Using cPanel: A Comprehensive Guide Reviewing Your Linux Hosting Resource Allocation and Usage in cPanel Creating and Managing Sub-domains with cPanel on Linux How Do I Emulate DNS Change on My PC? Effortless Migration from cPanel Email to Microsoft Office 365: Your Step-by-Step Guide How to Set up MFA for Your Microsoft Office 365 Outlook Account Setting up POP or IMAP Email on an Apple iPhone Creating and Managing MySQL Databases with cPanel on Linux How to Fix the Error '0x800CCC1A' in Microsoft Outlook? How to Fix the Error '0x800CCC78' in Microsoft Outlook? Setting up Email Account on Your Mac Mail Application Installing WordPress within Your Hosting Account with cPanel on Linux Setting up POP or IMAP Email on an Android Phone Setting up Mozilla Thunderbird as Your Email Client in Windows PC Setting up Microsoft Outlook as Your Email Client in Your Windows PC Setting up Mozilla Thunderbird as Your Email Client in Mac Creating Email Accounts with cPanel on Linux Creating More FTP Accounts with cPanel on Linux Accessing cPanel and Webmail on Linux Generate a Certificate Signing Request (CSR) Generate the Domain Secret or the Authorization Code for Your Domain Name How to Fix the Error '0x800CCCDD' in Microsoft Outlook with IMAP Server? Comprehensive Guide to Managing PHP Settings in cPanel on Your Linux Hosting Account Integration of Google Analytics on Your Website My Emails Are Bouncing Back. What Should I Do? What should I do when I cannot access my email or website on My Windows PC? Password Protect Files and Folders with cPanel on Linux Transfer Your Domain Name from your Current Registrar to Batoi Uploading Your Files with an FTP client (FileZilla)

Creating and Managing MySQL Databases with cPanel on Linux

Back to Help Articles
This article provides 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.

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

Back to Help Articles