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
Top ten tips for video calling whilst you work from home
The need for social distancing during the coronavirus pandemic has meant that as many as one in four of us now work remotely. Of course, the need to communicate effectively is still incredibly crucial, and video conferencing has played a vital role in ensuring working teams are all on the same page – even when …
The Hosting Options That Everyone Is Talking About In 2021
It is the start of a new year, and with that comes a renewed desire for companies to push on and improve the amount of success that they are privy to. Some believe that the best way to make this a reality is to upgrade their existing operating systems, so that their technical capabilities are …
Why Have Disaster Recovery Services Seen Their Popularity Soar?
The world of online operations is incredibly complex, and this should come as no surprise – there are various moving parts, and for things to be working smoothly, they all need to align. Whilst, for the majority of the time, operations take care of themselves, it is not impossible for things to go awry. Over …
Cloud Hosting – The Solution Of The Future?
For those of you that are experienced website builders, it will come as no surprise to hear that getting your page online is not as simple as clicking a button. There are various processes which have to be taken care of in order for a successful outcome to come to fruition. Web hosting companies are …
Which Server Solution Is Best For High-Traffic Websites?
When you come to catalyst2, you have the opportunity to collaborate with a company that, thanks to twenty years of experience, has a keen understanding of this particular field. Being providers of top-tier UK dedicated servers means that unlike some of the other data centres in the country, we can offer insightful advice on the …
Hosting Myths That Have Been Proven To Be False
When you are looking to get the website live for your company, you may not be aware of the fact that there are various different options available. If you are not someone that is particularly familiar with these operations, it can sometimes be tough to decide the appropriate course of action. These types of decisions …
Hosted Exchange Platform – TLS changes
In December 2017, Microsoft announced that in October 2020 they would disable older versions of their Transport Layer Security (TLS) in Hosted Exchange and Office/Microsoft 365. This means that following this change, users must use version software that uses version 1.2 of TLS or above to connect to Hosted Exchange. catalyst2 will be applying this …
And the 2020 Best Customer Service Award goes to… catalyst2!
Last week, The Internet Services Providers’ Association (ISPA UK), an esteemed British body representing internet service providers, held its renowned Annual UK Internet Industry Awards ceremony, also known as the ISPAs. For the past 22 years, the awards have brought together a plethora of companies within the ISP industry in the UK – regardless of …
What Hosting Options Can catalyst2 Help You?
To many people, hosting services are a foreign concept; even if you work for a multinational corporation, the chances are that you leave the technological side of things to those who have a well-rounded understanding of this niche field. Whilst there is certainly nothing wrong with this, it could be worth your time to learn …
Which Tech Solutions Should You Invest In Before 2021?
Regardless of whether or not you are familiar with the goings-on in the world of technology, the chances are that, at the very least, you will recognise that there have been countless advancements made in recent years. Thanks to the equipment that we have available, the software and services which are now available are simply …
What our clients say
catalyst2 support people know their environment and how to manipulate it to the customers advantage.