{"id":764,"date":"2024-03-15T12:05:35","date_gmt":"2024-03-15T12:05:35","guid":{"rendered":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/?p=764"},"modified":"2024-03-15T12:05:54","modified_gmt":"2024-03-15T12:05:54","slug":"how-to-access-the-cpanel-database-remotely-html","status":"publish","type":"post","link":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/381\/How-to-Access-the-cPanel-Database-Remotely.html","title":{"rendered":"How to Access the cPanel Database Remotely?"},"content":{"rendered":"
\n

There are several scenarios for the webmaster where accessing the cPanel database remotely becomes necessary, as they need to perform database-related tasks from external locations. Some common cases include development and testing, data migration, backup & restoration, third-party integrations, remote administration, or collaborative work.<\/span><\/p>\n

Accessing the database remotely through cPanel might require a bit of technical know-how. This detailed guide will explore the steps to access the cPanel database remotely, allowing you to perform database-related operations from external locations.<\/span><\/p>\n

Before we jump on to the steps, find out something useful.<\/span><\/p>\n

\n

Also Read: <\/strong>How To Change Your Website\u2019s Content In cPanel?<\/strong><\/a><\/span><\/p>\n

\n

Things to Know Before Enabling Remote Database Access<\/strong><\/span><\/h2>\n

When establishing a remote connection from your home computer, it is essential to employ database management tools such as MySQL, MariaDB, Oracle, PostgreSQL, MSSQL, SQLite, MongoDB, Navicat, phpMyAdmin, Workbench, or any other tool on your PC.<\/span><\/p>\n

To authorize your computer as an access host, it’s crucial to recognize that all IP addresses are initially blocked and need to be added to a list for server access. <\/span><\/p>\n

Therefore, before connecting to MySQL from a different computer, the connecting computer must be granted access as an Access Host.<\/span><\/p>\n

If your IP address changes regularly because of a dynamic IP from your Internet Service Provider (ISP), remember to update the IP in Remote MySQL whenever it changes.<\/span><\/p>\n

\n

Also Read: <\/strong>How to Change PHP Version in cPanel?<\/strong><\/a><\/span><\/p>\n

\n

Steps to Access the cPanel Database Remotely<\/strong><\/span><\/h2>\n

Firstly, you have to manage your IP address as an Access host. Find out how.<\/span><\/p>\n

\u27a2 How To Manage IP Address as an Access Host<\/strong><\/span><\/h3>\n

\u2794 Log in to cPanel.<\/span><\/p>\n

\"Log<\/span><\/p>\n

\u2794 Next, in the cPanel, go to the <\/span>\u2018Databases\u2019<\/strong> section and click the <\/span>\u2018Remote MySQL\u00ae\u2019<\/strong> icon.<\/span><\/span><\/p>\n

\"click<\/span><\/p>\n

\u2794 On the Remote MySQL\u00ae page, you have to add the connecting IP address in the <\/span>\u2018Host\u2019<\/strong> section.<\/span><\/span><\/p>\n

\"add<\/span><\/p>\n

\u2794 In that section, you have to add the IP address of your PC. To know the IP address, search in the browser <\/span>\u2018What is my IP\u2019 <\/strong>& you will get the IP address in the search results. Just copy & paste the code in the<\/span> \u2018Host\u2019<\/strong> section<\/span><\/span><\/p>\n

\u2794 Once you have added, click the <\/span>\u2018Add Host\u2019<\/strong> button<\/span><\/span><\/p>\n

\"click<\/span><\/p>\n

Your IP address has been added to the cPanel. You can see the added IP address under the <\/span>\u2018Manage Access Hosts\u2019 <\/strong>section.<\/span><\/span><\/p>\n

\"added<\/span><\/p>\n

\n

Also Read: <\/strong>How to Clear the Website Cache in cPanel?<\/strong><\/a><\/span><\/p>\n

\n

\u27a2 How to Access Database on Your PC After Add Access Host? <\/strong><\/span><\/h3>\n

There are various free and commercial applications available for remote database access in the market. For example, MySQL Workbench, HeidiSQL, and so forth. <\/span><\/p>\n

In this article, we will continue our RemoteSQL connection to the MySQL Workbench. You may use HeidiSQL to connect remotely to a database created on another hosting server or your base server. <\/span><\/p>\n

\u2794 Download the MySQL Workbench application on your desired operating system from their official website. We have installed it on the Windows operating system. <\/span><\/p>\n

\"Download<\/span><\/p>\n

\u2794 Now click the <\/span>\u2018+ Plus\u2019 <\/strong>icon on the left for Remote MySQL database access.<\/span><\/span><\/p>\n

\"Remote<\/span><\/p>\n

\u2794 A box will open with the form. Here, fill in the required information:<\/span><\/p>\n