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
What is CES? Your guide to this Las Vegas tech event!
Next taking place in January 2021, CES is a consumer technology exhibition – the Consumer Electronics Show. More than 4,400 businesses and inventors use this stage to exhibit their products. Meanwhile, those with an interest travel from all over the globe. Spread across some of the biggest venues in Vegas, including The Venetian, Wynn Las …
Windows 7 End of Life and major Windows Server 2016 flaw
Today is there day when Windows 7 reaches End of Life (EOL), this means that Microsoft won’t provide any further updates so should a security issue be uncovered, it will be left open for hackers to exploit. It is therefore strongly recommended that if you do use Windows 7, you should upgrade to Windows 10 …
What is .NET Core?
Allowing easy access to web and desktop development software that is user-friendly, standardised and works across platforms is one of the most important founding principles of the World Wide Web as we know it today. It means that anyone can take a standard framework that is functional and re-form it into anything they want it …
Why Your Business Website Needs An SSL Certificate
Cybersecurity is becoming an increasingly popular topic over the years, after all, almost every business either operates online or has an online presence. One of the most notable presences is through a website, however, not all website owners are aware of the latest approaches that can help with cybersecurity and keeping their website secure. Fortunately, …
The Importance Of Email Hosting For Businesses
Emails are now considered as one of the most used forms of communication, not just for individuals, but also for businesses. However, most users opt for free versions of email hosting services, which are good, but these aren’t ideal if you are looking to boost your business image. Fortunately, several hosting businesses provide email hosting …
5 Common Website Hacking Techniques You Should Be Aware Of
More businesses are looking to take their business online, after all, it can be accessed by almost everyone with an internet connection. However, as more websites are going live, there is becoming an increase in individuals, also known as hackers, who are looking to infiltrate these websites to steal its data and much more. Fortunately, …
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 …
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!