Absolutely! As a matter of fact, you can configure your mySQL database to be accessed from any Internet-connected computer you wish! However, you need to configure your mySQL database to accept incoming connections from the computer you'll be accessing from. You can do this in cPanel using the steps below:
Step 1: Log into cPanel.
Instructions:
If you’re a developer and want to access the MySQL database remotely from your local system. In that case, cPanel offers Remote MySQL functionality through which you need to allow your IP to get started.
Allow Remote Connections
Log in to cPanel using Username & Password. i.e; (https://yourdomain.com:2083 or https://yourdomain.com/cpanel)
Navigate to Databases ? Remote MySQL®.
Provide the following necessary details,
Host: Enter your static network IP. If you don’t have one, you need to allow connections from all the IPs by putting “%” (wild card) in the Host file. For this article, we will be allowing remote connections from all the IP adderesses.
Comment(optional): To remember the entry, you can write the statement.
To save the configuration ? Click the “Add Host” button.
Note: We recommend you contacting your Host to completely whitelist your static IP in the firewall to avoid further inconsistencies.
Connect To MySQL Remotely
For the remote MySQL connections, there are many free and commercial applications present in the market. For example: MySQL Workbench, HeidiSQL, etc. In this article, we will continue the RemoteSQL connection with the HeidiSQL application.
Download the HeidiSQL application (https://www.heidisql.com/) and Open.
Now click on “+ NEW” for Remote MySQL Connection.
Next, select Network Type, Library and provide the required information,
Hostname/IP: Enter the MySQL server IP address or hostname.
User: Enter MySQL username.
Password: Enter a password of your MySQL username.
Port: Enter the Port of MySQL.
Database Name: Enter the MySQL Database name.
Now click on Open to initiate a remote connection to the MySQL server.
- 0 משתמשים שמצאו מאמר זה מועיל
מאמרים קשורים
Powered by WHMCompleteSolution
