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
Clickjacking – what is it and why does it pose a risk to online security?
Everyone who uses the internet now knows how important cybersecurity is. This is true whether you have a business website, a personal blog or are even just browsing for goods or information online. While common threats like malware or phishing may be well known, clickjacking is another online security danger that you or your business …
Why Dedicated Server Hosting Is Key For A Business
If your company relies heavily on your website, then it’s key that your web hosting is dependable and reliable in similarity. In order for you to gain a better understanding of why dedicated hosting is vital, the skilled team at catalyst2 have united their expertise and experience within the industry so that we can present …
How To Choose The Most Suitable Website Hosting Provider
You have recently created your new website for your business, but now it’s time to ensure that it’s online and secure for your customers to use – which is why it’s vital to begin the search for dependable hosting providers. With many web hosting companies in the UK, there are endless hosting plans available and …
An overview of phishing – one of the most common types of internet fraud
If you’re familiar with the challenges businesses face in their cyber-security, you’re likely familiar with phishing – but a startling number of businesses truly understand how common a threat it really is. With nearly one-third of data breaches in 2018 involving phishing, it pays to understand what it is and what you can do to …
What Should Be Included In A WordPress Hosting Package?
Whether you are using your WordPress website like an online shop, forum, gallery or simply as a brochure website for your business, it’s vital that it’s hosted correctly. With many website hosting agencies in the UK, businesses now have endless options for hosting providers, however not all providers include the same service. Therefore, it is …
cPanel announces price rises
Founded in 1997, cPanel is thought to be used in over 70 countries globally and is one of the most popular control panels around for managing web hosting. Recent news announced by the company though has seen price rises implemented for customers. New licenses renewed or purchased from now on are subject to this new …
Libra Coin: What is it and how does it work
Facebook’s first attempt at cornering the cryptocurrency market has finally been revealed. Sending Bitcoin soaring to new heights of £10,000, Libra enters an already corded market that carries a degree of volatility that the normally pragmatic and calculating Facebook are supremely unfamiliar with. So, what is Libra coin and how will it work for those …
NVMe – the next generation in data storage and handling
What is it? NVMe stands for Non Volatile Memory Express. It is also known as Non-Volatile Memory Host Controller Interface Specification (NVMHCIS). This term may currently seem a little obscure, but it won’t remain so for long as it represents the next generation in memory-based storage technology. This host controller interface and protocol was developed to …
3.2 million people have the right to a .uk domain name – are you one?
Do you currently own a .org.uk, .net.uk, .me.uk, .plc.uk, .ltd.uk, or .co.uk domain name? If so, it’s possible that until June 25th, 2019, the matching .uk domain may automatically have been reserved for you. So, for example, if you own mywebsite.co.uk – until June 25th the corresponding mywebsite.uk domain may have been reserved. If you’d …
The history of knowing that, “I’m not a robot”.
In the early 1990s – before Gmail, Zimbra, Zoho, and ProtonMail came along – Yahoo Mail was king of the hill. It was free, easy to use, you could have any email address you wanted, and access it from anywhere on the planet. Everything was good. Except for one problem: spam. Literally millions of fake …
What our clients say
catalyst2 support people know their environment and how to manipulate it to the customers advantage.