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
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 …
Managed cloud hosting
Businesses of all shapes, sizes and industries are leaning towards managed cloud services. In January 2020, Gartner predicted that adoption to the cloud will continue to grow, and it is. Moving to the cloud has many distinct advantages, so let’s take a look into the world of managed cloud hosting. First of all, what does …
A Comprehensive Guide To Cloud Hosting For Novices
The technical world is one which is constantly advancing; every year, developments are being made which enhance our computing capabilities. Since the turn of the century, the business landscape is one which has been dominated by digital appliances. What many people fail to recognise is that this does not happen by coincidence – a lot …
All You Need To Know About Your Server Options
Although you may not realise it, getting a website to work is not as simple as simply uploading it to the internet; there are various technical actions which must take place to make this a reality. Arguably the most important of these is enlisting the help of a company which has an array of servers …
Viewing invoices for Dedicated Servers
If you would like to view all your old invoices, you can click on the link in a recent invoice email. This will then take you to a screen that looks like this: If you click on the outstanding bills link at the top that is highlighted, you will then be taken to a screen …
SOC2 hosting versus ISO 27001
In an ever-changing world, the risk of cyber-attacks and threats to data security is in the mind’s eye of every business. Therefore, it makes good business sense to always be on the lookout for the most bulletproof and secure way to manage data, to protect a business’s interests and that of its customers. Globally, there …
How To Buy A Domain Name – What You Need To Know
Whilst you may not be currently aware, one of the most important processes associated with creating a website will likely be conducted a long time prior to the initial coding. The formulation of a domain name is crucial to being successful, as a firm, for many years to come; this is because it will become …
Why should your business use a managed dedicated server?
A dedicated server is a type of website host in which the user has the exclusive use of the entire server. If your business currently uses a shared hosting server, you may have experienced some hosting problems. This is because other websites are using the same server, which means you are competing for limited server …
What our clients say
We really rate catalyst2. We get a great response from the team… really happy with the service.