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
Choosing The Right Domain Name Ending
Whenever you’re creating a website, there are lots of different things you will need to consider to ensure that everything is exactly as you’d hoped. It is fair to say that one of the most important things you should think about is your domain name and choosing the right name is absolutely essential. Many people …
ISPA Awards Shortlist 2020: Double honours for catalyst2
We pride ourselves at catalyst2 on the quality of both our products and our customer service, so we are thrilled to announce that we have once again been shortlisted for the 2020 ISPA Awards in both categories! Our team has been an ISPA winner or finalist every year for the past nine years, highlighting the …
7 steps for creating a podcast
So you want to start your own podcast? In this article, we’ll give you everything you need to learn how to create your own podcast. Decide on the Topic Chances are that if you have already decided that you want to start a podcast, you know what you want the topic to be about. But …
What To Look For When Choosing A Web Hosting Provider
When deciding to create a website and finally bring your business online, you will want to ensure that you have the best web hosting provider to assist you with everything you need to get started. These days, there are so many different web hosting companies offering a range of web hosting services that it can …
Google wants you to speed up your site, and we can help
What’s your page load speed? Not only is a slow website bad for customers and sales, now it’s bad for SEO too! A page that loads slowly is a big no-no if you want users to convert. Customers are unlikely to wait around for a page to load…especially when most people these days are browsing …
The Benefits Of Email Hosting For Businesses
When you run a business it goes without saying that you will be juggling so many different things. Many people are often searching for ways that they can make life easier for themselves and one thing that businesses should all consider is email hosting. Emails play such a huge part in the day-to-day life of …
Everything You Need To Know About WordPress
These days, having an online presence is essential for businesses and there are numerous undeniable benefits to making your business accessible to everyone online. If you don’t already have a website then this is one of the first steps to building your virtual presence. Of course, when creating a website for your business there are …
The remote services we offer at catalyst2
As technology becomes more a part of the way we work, remote working becomes a more considerable requirement for all manner of businesses. The benefits are numerous – it allows you to operate your business more on your terms, and on your schedule. Whether you’re an entrepreneur, a medium-sized local business, or a large multinational, …
Why You Should Choose VPS Hosting Over Shared Hosting
Choosing the right web hosting package for your website is no easy task, after all, there are several options available to choose from. Fortunately, there are several helpful guides, such as this one, that will help you to make the right choice – and to make your search for a web hosting package a little …
Proud to be working with FareShare
At catalyst2, we’re proud to support the local and global community when it comes to the companies we work with. That’s why FareShare choosing to work with us was such a fantastic honour. As a company that we respect and wholeheartedly support, we were happy to hear that our services could be an invaluable part …
What our clients say
Everything is fine, thank you. The queries I had were dealt with in a prompt, professional and truly friendly manner! I have never experienced such superb service from any other supplier!
You guys and Catalyst2 are awesome!