Webhosting with remote MySQL access

Started by rajan, Aug 11, 2022, 12:17 AM

Previous topic - Next topic

rajanTopic starter

Hi there!

I'm looking for a hosting provider that supports PHP and MySQL with the option to remotely access MySQL. This is necessary for my C# application to be able to use the database.

While there are several companies that offer remote access to DBMS, there is one issue - the need to explicitly specify IP addresses allowed to access the database through the hosting panel. However, our organization has employees in different French cities, with some using dynamic IP addresses, which makes it impractical to add new IPs to the allowed list.

Is there a hosting server that doesn't require specifying IP addresses in order to use MySQL? I'd greatly appreciate any recommendations on this matter.
  •  

Travelpayouts

In my opinion, VDS would be a more suitable option for your needs. However, if you prefer a hosting service, I recommend Zomro as their servers located in the Netherlands offer high quality at a good price.

Alternatively, I can offer to rent out my Dedicated server located in any country worldwide with direct IP access to SQL, or MySQL/iptables configured for IP address filtering using standard Linux/MySQL tools if there is root access. I can also help in choosing the best price/performance solution, data center selection and Apache/MySQL compilation.
  •  

Deepak1

www.db4free.net/ web service a couple of years ago. However, as expected from a free service, there are no guarantees for stable uptime or data retention. For this reason, I have since switched to storing my data on my VDS.

In general, it is best to opt for a reliable hosting service or pay for a VDS to ensure data security and uptime. While free services may seem tempting, the risks involved may not be worth it in the long run.
  •  

Arkanello

You need to choose a hosting provider whose data center is geographically close to your target audience.
I believe centohost.com and also kvchosting.net are flexible enough to meet all your specific hosting needs.
Compare their hosting solutions and choose the best for your requirements.
  •  

Hostingsource

What is your monthly budget? How much money are you planning to spend?
Hostingsource Inc -  the best VPS and dedicated servers in industry.
We will serve your any web hosting demand.
  •  

Parados

Why not give Exmasters.com web host a try?
Excellent Hosting provider! They've helped me to launch a number of blogs and I'll use it for any website I ever host.
  •  

Dodger

Very swift and accurate support. Hosting speed & uptime at NetShop ISP web host get 11 out of 10 for me!
They offer a superb personal service with exceptionally quick response times.
  •  

Torreako

Just choose the host that suits your needs and provides constant and uninterrupted services and support.
Nice feature-rich hosting solutions you can get from:
1) hostrocket.com
2) libertyvps.net
3) cloudarion.com
The stability, reliability and reputation go outside the bounds in every aspect of the question.
  •  

cnacer

Most hosting providers will use a whitelist system for granting remote access to their MySQL databases for the sake of maximum security. However, there are workarounds and solutions to address the issue you're experiencing.

Generally, remote MySQL connections marked as unsafe because they leave the database open to various threats. Therefore, while it's theoretically possible to permit remote connections from any IP, it's not recommended.

For your specific situation, consider these possible solutions:

Virtual Private Network (VPN): Widely adopted for secure remote access, a VPN assigns the same IP address to anyone connected to it regardless of their geographical location. Hence, you'd only need to allow the VPN's IP in your hosting panel.

Web Service: Instead of connecting your C# app directly to the MySQL database, you can build an intermediary web service, secured with HTTPS, through which your application can perform operations on the database. This method is commonly used and is often considered more secure.

Cloud-based Database: Providers like Amazon Web Services (AWS) and Google's Cloud SQL do not require specific IP addresses to connect to MySQL databases. You might consider switching to a cloud-based database if these workflows align with your organization.

However, if you still feel that your organization requires a hosting provider that doesn't require specifying IP addresses, you might look at providers like:

Cloudways: While they do require an IP address whitelisting initially, they also offer a VPN service that could help streamline the process for your varied locations.

A2Hosting: A2Hosting allows unrestricted remote MySQL access. However, you may need to explicitly request this feature when setting up your service, and security precautions are recommended.

Hostinger: They allow unrestricted remote MySQL connections, but access is not enabled by default and must be requested.

If your organization has a higher budget and scalability and performance are concerns for you, you may also want to consider some premium database services that offer a fully managed experience, along with more favorable access rights:

Amazon RDS: Amazon's Relational Database Service (RDS) provides an easy to administer, highly scalable, and robust database service platform that supports various database instances including MySQL. It allows connections from any IP address, provided you set the correct security groups in your AWS VPC.

Google Cloud SQL: Similar to RDS, Google's Cloud SQL also provides a fully managed database service for MySQL and does not restrict access based on IP addresses if you configure the firewall rules accordingly.

Azure Database for MySQL: This is a fully managed database service provided by Microsoft. Configuring the firewall setting appropriately allows connections from any IP.

These services usually also offer ways to set up VPN tunnels or VPC peering so you can have a secure and controlled network connection to your database.

Regardless of the option you choose, remember that while allowing any IP address access provides practical ease of access, it does come with disadvantages in potential security risks. Therefore, always make sure you have robust security measures in place, such as SSL for encrypted connections, and regular monitoring and auditing of access logs.
  •