Accessing your database remotely
cPanel’s Remote MySQL page lets you enable database access from locations, such as your home or another website. For security reasons we don’t allow remote connections on our shared hosting, premium and reseller hosting packages. However, we can enable the feature on our VPS and dedicated hosting plans.
How to connect remotely
The Remote MySQL page has two sections:
- You can whitelist an IP address or domain under the Add Access Host header.
- You can manage existing whitelisted IP addresses or domains in the Manage Access Hosts section.
Adding an IP address or domain
To access your database(s) from your home or office you first need to know your IPv4 address. You can check your IP address via findip.co.
In the below example I added the IP address 84.18.210.139. I also added a comment, which is purely for my own reference (you can leave the field blank).
Image: whitelisting an IP address that should be allowed to connect to my database.
Note: You can connect from another website by entering the site’s domain name instead of an IP address.
Managing the whitelist
The Manage Access Hosts section lists existing whitelisted IP addresses and domains. By default, only the IP address of the server is whitelisted. In the below image you also see the office IP address we whitelisted.
Image: the office IP address is now allowed to connect to our databases.
If you need to revoke access for an IP address or domain name, simply click on the Delete link.
Connecting to the database
After whitelisting your IP address or domain you can connect to the database straight away. You can use a graphical tool such as MySQL workbench, or you can connect directly from the command line.
Featured Blogs
How Web Consultancy Can Benefit Your Business
If your business isn’t looking to continuously expand and advance, what is the purpose of being in operation? As more and more businesses are establishing an online presence, it’s vital that your website and related aspects are in time and updated with your business plan, which is where a consultancy firm can assist. What is …
Why You Need A Web Application Firewall
Having an online presence is vital for almost every business, more so for a website that handles personal data regarding staff, clients and finances. Not just that, but several businesses operate solely online, making their website their primary point of contact for customers, making it vital that it’s safe, operational and protected at all times. …
What Is Private Cloud Hosting?
When people think of cloud hosting, they often presume that all hosting is shared and all users are within the same network, though as we are about to explain, there is an alternative solution – private cloud hosting. What is private cloud hosting? Private cloud hosting essentially follows the same fundamental cores as a public …
Proudly continuing our support for The Royal British Legion
The catalyst2 team is delighted to be once again providing managed hosting for The Royal British Legion as we approach another Poppy Appeal, but we probably shouldn’t have told you that, because there are spies everywhere! Operation Poppy This year sees the centenary year of Government Communications Headquarters, more commonly known as GCHQ. The intelligence, …
What is auto-scaling, and why should you let catalyst2 help you implement it?
As cloud computing becomes a more widely implemented solution for businesses looking to manage their server load, auto-scaling is growing in importance. Enlisting the help of a specialist service provider, such as Catalyst2, can allow you to ensure a reliable and professionally managed auto-scaling implementation. What is auto-scaling? Before you can know why you need …
What is an MSP, and what can they do for you?
If you’re in the world of business, then it is likely that you have come across the term “Managed Service Provider” (MSP). Depending on your area of expertise, although you may have heard the term, it may mean nothing to you. Unless you’re in the field, it’s unlikely that you’ll know what an MSP does. …
High Touch Hosting
Whether you are creating a brand new website or expanding your current one, you’ll have a long list of items to consider. There will be content requirements; design features; integrated tools or software; maybe an e-commerce store, but will you have researched your hosting needs? As a website grows, so does the need for resources …
What is web hosting?
At a very basic level, web hosting is the home for your website. Just like your business might have an office, a shop or a warehouse, your website needs somewhere to call home. All of the content – images, files, databases and software – that power your website is stored on a server. This server …
The Importance Of Disaster Recovery Planning
If your business operates either online or on computers, then you are bound to comprehend the inconveniences that can be caused by system or web issues. Although not all incidents are major or damaging, some issues can still occur which may be irreversible, however, with a data recovery plan in place, you can prevent the …
What our clients say
Great real person support – direct phone number, usually the same individual so any problems are handled by the same people. Excellent.