Reseller Web Hosting Offers:

How to Create MYSQL Database in Linux Dedicated Server ?


Error: Your Requested widget " bcn_widget-2" is not in the widget list.
  • [do_widget_area colormag_advertisement_above_the_footer_sidebar]
    • [do_widget id="custom_html-10"]
    • [do_widget id="custom_html-11"]
    • [do_widget id="custom_html-13"]
    • [do_widget id="colormag_125x125_advertisement_widget-2"]
    • [do_widget id="text-15"]
    • [do_widget id="custom_html-9"]
    • [do_widget id="custom_html-12"]
  • [do_widget_area colormag_contact_page_sidebar]
    • [do_widget_area colormag_error_404_page_sidebar]
      • [do_widget_area colormag_footer_sidebar_four]
        • [do_widget id="custom_html-3"]
        • [do_widget id="text-7"]
      • [do_widget_area colormag_footer_sidebar_full_width]
        • [do_widget_area colormag_footer_sidebar_one]
          • [do_widget id="custom_html-6"]
          • [do_widget id="custom_html-7"]
          • [do_widget id="custom_html-8"]
          • [do_widget id="text-38"]
          • [do_widget id="text-3"]
          • [do_widget id="text-4"]
        • [do_widget_area colormag_footer_sidebar_one_upper]
          • [do_widget_area colormag_footer_sidebar_three]
            • [do_widget id="custom_html-4"]
            • [do_widget id="text-6"]
          • [do_widget_area colormag_footer_sidebar_three_upper]
            • [do_widget_area colormag_footer_sidebar_two]
              • [do_widget id="custom_html-5"]
              • [do_widget id="text-5"]
            • [do_widget_area colormag_footer_sidebar_two_upper]
              • [do_widget_area colormag_front_page_area_beside_slider]
                • [do_widget_area colormag_front_page_content_bottom_section]
                  • [do_widget_area colormag_front_page_content_middle_left_section]
                    • [do_widget_area colormag_front_page_content_middle_right_section]
                      • [do_widget_area colormag_front_page_content_top_section]
                        • [do_widget_area colormag_front_page_slider_area]
                          • [do_widget_area colormag_front_page_top_full_width_area]
                            • [do_widget id="text-17"]
                          • [do_widget_area colormag_header_sidebar]
                            • [do_widget id="custom_html-2"]
                            • [do_widget id="text-8"]
                            • [do_widget id="text-27"]
                            • [do_widget id="text-23"]
                          • [do_widget_area colormag_left_sidebar]
                            • [do_widget id="text-19"]
                          • [do_widget_area colormag_right_sidebar]
                            • [do_widget id="text-13"]
                            • [do_widget id="search-2"]
                            • [do_widget id="colormag_300x250_advertisement_widget-3"]
                          • [do_widget_area widgets_for_shortcodes]
                            • [do_widget id="breadcrumb_navigation_widget-5"]
                            • [do_widget id="text-16"]
                            • [do_widget id="text-20"]
                            • [do_widget id="text-24"]
                            • [do_widget id="text-25"]
                            • [do_widget id="bcn_widget-2"]
                            • [do_widget id="text-28"]
                            • [do_widget id="text-29"]
                            • [do_widget id="text-30"]
                            • [do_widget id="text-31"]
                            • [do_widget id="text-32"]
                            • [do_widget id="text-33"]
                            • [do_widget id="text-34"]
                            • [do_widget id="text-35"]
                            • [do_widget id="text-37"]
                          • [do_widget_area wp_inactive_widgets]
                            • [do_widget id="text-12"]
                            • [do_widget id="colormag_300x250_advertisement_widget-4"]
                            • [do_widget id="recent-posts-2"]
                            • [do_widget id="recent-comments-2"]
                            • [do_widget id="archives-2"]
                            • [do_widget id="meta-2"]
                            • [do_widget id="pages-3"]
                            • [do_widget id="text-22"]
                          Dedicated Server hosted domains have the same procedure to create the database under the domain via cPanel as like Reseller Hosting .  It is a simple method and also we can able create multiple Databases in the dedicated server.


                          Share This Now: [addtoany]

                          Watch Reseller Hosting Video Tutorial



                          Procedure

                          Databases Creation In Dedicated Server cPanel

                          To create a Database in the domain which is hosted under the dedicated server, Please follow the below procedure:

                          1. Login to the cPanel of that domain .

                          2. Go to the path,

                          cPanel » Databases » MySQL@ Databases

                          3. Here you can able to create the database by giving the databse name in the option “Add Database” and click create. To create the user for the database you have to use “Add User” and create the user with password then map that user with the database.

                          4. Once you created the database you can able to access that via cPanel itself using the “phpMyAdmin” option under Databases.

                          5. In phpMyAdmin you can able to create the table, perform all functions related to table and also you can use queries for all the operations.

                          Screen Shots

                          Refer Screen Shots

                          FAQs

                          Dedicated Server WHM Troubleshooting FAQs

                          Not able to access the newly created database

                          Reason :

                          1. Check  whether you have created the user and you have mapped that to the database properly.

                          2. Check the privilage of that user , whether the user have the insert, read , modify and write permission to make changes.

                          3. Check whether the proper user has been mapped to this database.

                          Getting the error used maximum allocated database for this domain

                          Error :

                          You are using your maximum allotment (X) of MariaDB/MySQL databases. If you want more, contact your service provider.

                          Solution :

                          The number of allocated email id which you can create under this domain has been finished. If you wnat to create more databases then you have to increase the count in the corresponding package.

                          Home » Packages » Edit a Package

                          Choose the package which is allocated for that package and click edit and increase the database count. Since you are having the dedicated server you can able to create unlimited databases also .

                          Downloads

                          Related Downloads

                          Related Articles

                          Dedicated Server Support Articles

                          How to Host a domain in my Dedicated Server ? 
                          How to Uplod files in the Domain which is hosted in my Dedicated Server ? 
                          How to Access Cpanel of my  Domain which is hosted in my Dedicated Server ? 
                          How to Host a domain in my Dedicated Server ?