What Configuration Settings Are Needed?
The following configuration settings are required for setting up a remote MySQL access connection to your database: Host name = (use the server IP address) Database name = (cpanelUsername_databaseName) Database username = (cpanelUsername_databaseUsername) Database password = (the password you entered for that database user) MySQL Connection Port = 3306 You can use TCP or UDPHow to Allow a Remote Server to Access Your Database?
Before you check how to connect to MySQL from a different computer, you need to enable the connecting computer as an Access Host. Here are the steps to do so:- Log into the cPanel and click on the Remote MySQL icon available under the Databases segment.
- Type in the connecting IP address and click on the Add Host button. You can find and add your IP address directly from this tool. Look for your IP and click on the Add link to input it into the field box.
- Now that your IP address has been added, you will be able to connect MySQL remotely to your database.
How to Remove access to a Remote Server for Accessing Your Database?
If you wish to remove a host from accessing the databases on your server, you need to take the following steps:- Click on the X icon next to the IP address.
- Click on Yes to confirm that you wish to prevent the server from accessing your remote databases.
Write A Comment