Reseller Web Hosting Offers:

How do I Access Remote Mysql Database from 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 have the facility to access the remote database from this server . For this we need to allow the certain port in the server firewall. Once it is allowed we have to allow that remote server IP in the server to access the database.


                          Share This Now: [addtoany]

                          Watch Reseller Hosting Video Tutorial



                          Procedure

                          Access Remote Mysql Database from Dedicated Server

                          To Access the MySQL Database from remote server need to do some setting in our server, please follow the below procedure,

                          1. Login to the Dedicaed Server WHM as root user.

                          2. To access the MySQL Database as remote we need to enable the port 3306 in the firewall of that server, after that you can allow the IP address of remote server in the cPanel of that domain.

                          3. Go to the path,

                          Home » Plugins » ConfigServer Security & Firewall

                          4. Here you can able to see the option ” Firewall Configuration ”

                          5. Click that option and allow the port 3306 in both the options “TCP_IN =” and ” TCP_OUT = ” .

                          6. After allowing click “change” and restart the firewall. Now you can able to connect to the remote database from your server.

                          Screen Shots

                          Refer Screen Shots

                          Troubleshooting FAQs

                          Dedicated Server WHM Troubleshooting FAQs

                          Getting Connection Error- Host ‘hostname’ is blocked in my Database Connection

                          Error :

                          Connection Error- Host ‘hostname’ is blocked 

                          Reason :

                          When more than max_connect_errors may occur successively for a given host while connecting to the MySQL server, MySQL assumes that something is wrong and blocks the host from further connection requests.

                          Solution:

                          If you are trying to connect to the remote hosts then you will be getting such error. We advise you to try connecting to the local database with different user name

                          Downloads

                          Related Downloads

                          Related Articles

                          Dedicated Server Support Articles

                          How do I Restart My Database Service in Dedicated Server ?
                          How do I Change the Root Password of MySQL Server ?
                          How can I Access All the Database in Dedicated Server ?
                          How can I Repair the Database in Dedicated Server ?