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
A Complete Introduction To Business Email Hosting
Being a company in the modern era can be extremely difficult – there are countless obstacles which must be navigated, some easier than others. With the evolution which has taken place in the field of technology, more-and-more firms are having to adapt and conform to the online revolution. This is evident when you observe the …
Changes to SSLs lifespans
At catalyst2 we sell a range of SSLs, however from the 1st September, we will only be selling 1-year SSLs. To learn more about SSLs and the new changes to the certificates, continue reading. What are SSLs? SSL stands for Secure Sockets Layer. It is an internet security protocol which is encryption-based. SSL certificates are …
What Is VPS Hosting? The Guide To VPS Hosting For Beginners
Virtual Private Servers, or VPS hosting, is one of the most modern types of server management in 2020, and is likely to only continue growing in popularity.Many consumers value convenience over all-else; it is for this reason that companies endeavour to ensure that their websites and overall virtual presence is faultless. Unfortunately, there are countless …
catalyst2’s Haiti Clean Water Project
catalyst2 are a managed hosting provider and are known as one of the most trusted names in UK hosting. We pride ourselves on being an eco-friendly company, and this extends far beyond good intentions. As part of our efforts to become more eco-conscious, we are active supporters of many climate positive projects. One of the …
Afforestation and carbon positive projects at catalyst2
At catalyst2 we are concerned about our impact on the environment. The focus on environmentally conscious companies extends to consumers too, with 44% of UK shoppers preferring to buy from companies aware of environmental issues. Recognised as a staple of good practice, organisations are showing that they care about the world outside their immediate concerns …
Everything you need to know about VMware cloud
Using cutting-edge technology, cloud hosting is the latest way to ensure a flexible and high-quality hosting service and is becoming increasingly popular amongst many businesses. How does VMware cloud work? The simple concept of a VM cloud is the creation of a cloud computing platform. This involves several servers being connected to the internet. In …
What is the difference between public, private and hybrid cloud?
If you use an online service like Microsoft Outlook to send emails, for example, you probably haven’t given much thought to what type of cloud computing, if any, is behind it. It is much the same when watching TV online, listening to music, playing games, or storing pictures and files. They have to be stored …
Everything You Need To Know About Magento Hosting
Should you be a company in the retail industry, your chances of success are drastically reduced if you do not have a significant online presence, and this isn’t possible without having a high quality website. However, it is important to note that there is not one web hosting plan which is suitable for everyone – …
What You Need To Know About Managed Dedicated Hosting Servers
In this digital day and age, many people take to the internet whenever they are in need of a product or a service. For this reason, if you own a business, it is more important than ever before that you have an online presence. You can guarantee that if you don’t have a website which …
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 …
What our clients say
We really rate catalyst2. We get a great response from the team… really happy with the service.