Accessing your database remotely
Last updated: 5 April 2021
By default, you can only access your databases via the server hosting your website. cPanel’s Remote MySQL page lets you enable database access from other 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 plans. 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 allow an IP address or domain under the Add Access Host header.
- You can manage existing allowed 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: allowing an IP address.
Note: You can connect from another website by entering the site’s domain name instead of an IP address.
Managing the allow list
The Manage Access Hosts section lists existing IP addresses and domains. By default, only the IP address of the server is allowed. The below image also shows the office IP address I added.
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 allowing your IP address or domain you can connect to the database straight away. You can either use a graphical tool such as MySQL workbench, or you can connect directly from the command line.
Featured Blogs
Best Practices for Backing Up Dedicated Server Data
For businesses using unmanaged dedicated servers, ensuring data is properly backed up is essential, particularly when automatic backups are not provided. While unmanaged servers offer greater control and flexibility, they also require the server owner to take full responsibility for securing their data. Without a robust backup plan, there is a risk of losing critical …
How to Migrate to a Dedicated Server without Downtime
Over time, many businesses decide to migrate their website to a dedicated UK server to experience benefits such as improved performance, enhanced security, and better resource allocation. However, migrating to a dedicated server independently, can lead to a number of challenges, including technical issues and potential downtime. Downtime occurs when your website becomes temporarily unavailable, …
Dedicated Server Hosting for High-Traffic Websites
For businesses experiencing high web traffic, shared hosting or a VPS can lead to performance issues, such as slow load times, crashes, and potential downtime. These problems can negatively affect user experience and harm a business reputation. Dedicated server hosting provides a robust solution by offering exclusive resources that ensure optimal performance even during traffic …
Dedicated Server Hosting for Startups in the UK
Starting a business in the UK comes with a number of challenges, one of which is building and establishing a strong online presence. For startups, having a reliable and efficient hosting solution is essential to ensure smooth operations and deliver the best possible online experience for customers. The hosting option you choose can significantly influence …
10 Benefits of Managed Dedicated Server Hosting
Choosing the right hosting solution is a key decision for businesses looking to ensure optimal performance, security, and reliability for their online operations. Managed dedicated server hosting offers a comprehensive solution by combining the power of dedicated servers with expert management services. By entrusting server management to experienced professionals, businesses can focus on their core …
Discussing the Benefits of Dedicated Server Hosting in the UK
As businesses in the UK grow and expand, managing an online presence becomes increasingly important. While many companies initially host their websites on shared servers or manage in house, the rising volume of traffic and demand for enhanced performance often calls for a more robust solution. This is where dedicated server hosting becomes essential. Offering …
How to Choose a Dedicated Server for UK Businesses
Dedicated servers offer numerous advantages for businesses, including optimal performance, speed, reliability, and enhanced security. However, choosing a dedicated server provider for a business can be a challenging task, especially if you’re unsure what factors to consider. Dedicated server requirements will differ based on your type of business type, whether you’re in e-commerce, gaming, media, …
Comparing Dedicated Servers with VPS Hosting
Many businesses begin by managing their own websites or using shared hosting, but as their needs grow, they often require a more robust solution to enhance performance, security, and speed. Whether you run an e-commerce store, an online gaming platform, an IT consultancy, or a news website; increased traffic and business growth may lead you …
Why Choose UK Dedicated Server Hosting for Your Business?
As companies scale their operations and seek to maintain a seamless online presence, many consider upgrading to a dedicated server. This option offers greater control, enhanced security, and improved performance; all crucial elements for growing businesses. Given these advantages, it’s no surprise that dedicated server hosting has become a popular choice. Deciding if it’s worth …
Managed Dedicated Server Hosting for eCommerce Businesses in the UK
As more UK shoppers increasingly turn to online platforms to make their purchases, having a good online platform as an eCommerce business is essential. As your eCommerce operation grows, you may encounter challenges such as higher traffic, slower loading times, and potential security issues, all of which can negatively impact the visitor experience on the …
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!
