Home » Support » Help Articles » Creating and Managing MySQL Databases with cPanel on Linux

Creating and Managing MySQL Databases with cPanel on Linux

Back to Help Articles Home


This article shall guide you on how to create and manage databases with your Linux cloud control panel.

  1. 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.
  2. Figure One

  3. 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 below.
  4. Figure Two

  5. The system will take you to the database creation page as shown below. 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 below.
  6. Figure Three

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

  9. 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 below.
  10. Figure Five

  11. Now click the button 'Password Generator' to have a strong password generated for your user as shown below. 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.
  12. Figure Six

  13. 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 below.
  14. Figure Seven

  15. 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 below. Select the desired 'User' and 'Database' from the dropdowm menu and click 'Add' button as shown below.
  16. Figure Eight

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

  19. Upon doing so, the system will give you a confirmation screen that the user has been added to the database as shown below.
  20. Figure Ten

Manage databases through phpMyAdmin

  1. 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.
  2. Figure One
    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.

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

  5. Upon clicking the link, system will open 'phpMyAdmin' in a new tab as shown below.
  6. Figure Twelve

  7. 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 below. Click the 'Go' button and the database will be downloaded to your local system.
  8. Figure Thirteen

  9. 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 below. After clicking the link, system will open the import database page as shown below. 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.
  10. Figure Fourteen

  11. 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 below.
  12. Figure Fifteen

Now the whole new world of MySQL databases is open to you to explore!



Updated on Oct 04, 2015

The techReview is an online magazine by Batoi and publishes articles on current trends in technologies across different industry verticals and areas of research. The objective of the online magazine to provide an insight into cutting-edge technologies in their evolution from labs to market.

Visit techReview


English - IN (USD)
New Users? Signup.     Existing Users? Login.