You can grant access to a MySQL database from an external location by adding a domain name or an IP address to a list of acceptable hosts list to allow access to the database remotely. Furthermore, if you use an application to manage your database, you would need to add the IP address that the connection is made from as an allowed access host.
The first step is to log into your cPanel account. If you are unsure on how to do this, please view the following help article - 'How to log into cPanel'.
Scroll down to the 'Databases' section and choose 'Remote MySQL'.
Enter the domain name or the IP address where the remote database access connection will be established from - you can use % as a wildcard for an IP range if need be.
Select 'Add Host' to allow the access.
You should now see visual confirmation that the new host has been added. To review, select the 'Go Back option.
You can now see under the 'Access Hosts' list that the new host is present.
If more remote database connections are required, you can repeat the process again by entering another host.
Creating a MySQL remote database connection is now complete.
HostPresto will be launching a European point of presence in the coming weeks, specifically in Amsterdam. For customers needing their data located within the EU still please contact support to request migration to this location with ticket subject ‘EU Migration’. We will ensure this is actioned well before the Brexit...
Should the UK leave the EU without a deal, or should a deal be agreed that does not include a provision for .eu ownership by UK entities, it’s highly likely that the EU will revoke any .eu domain names unless you can provide an EU address. While this won’t happen...
If you own a .co.uk domain name and you have not registered the equivalent .uk version, you have until the 25th June 2019 to register the domain and secure your brand. After this date any unregistered .uk domain will enter public availability – meaning anyone can register the domain. You...