Often I have to intervene on sites, with hominium registered on shared hosting server
Unfortunately, just as often the supplied mySql databases cannot be managed remotely (direct manager)
Is there somewhere to have the possibility to create and use external databases, at low cost or free, as long as they are reliable and without surprises?
I seem to have read something about it in the Wappler community, but I can’t remember where
For low-cost database hosting, you can look at service providers like Digital Ocean, Linode or Vultr.
The problem is that as an anti hacking mechanism hosts routinely block access to databases from ip addresses other than their own.
Most providers will provide a mechanism to overide that security either completely or more commonly allow a specified IP address such as your own to be authorised.
Unfortunately that is outside Wappler’s control.
Using a cloud provider such as DO via docker is cheap and includes database services, typically $5 a month
It is a difficult problem to solve
Owners of shared hosting domains often do not agree to transfer to other solutions (cloud vps).
Someone manages to transfer it to Cloud Hetzner, because the monthly cost is accepted, but others on principle do not want to know
After all, using the databases of shared hosting servers, it becomes impossible to manage them optimally and sometimes it is really penalizing
The ideal for me would be to have a single server where to create all the databases needed for the various sites, but of course with an acceptable cost and the necessary reliability over time
Then I don’t know if, as you say, the database is then accepted by the domain hosting server (to be verified)
If you registered a cheap vps with cpanel you could allow access from all severs by using a wildcard as the ip restriction. Then you could do exactly that.
This is, of course, a reduction in security
In my case I use hostinger.com and wiroos.com both with remote mysql and working well.
For shared servers, if using cPanel, there is an option called remote Mysql. There you can put your ip and then access the DB from Wappler or any other DB app.
There would be similar options for other shared hosting interfaces as well.
Actually there are a free hosting services with cpanel with limited features like remote mysql, I confirm. Byethost is one of these
But check if it’s available first, good point
Thanks for the various replies.
However, I don’t have to and don’t want to switch shared hosting for domains that are on servers that I don’t choose (plex or cpannel).
I would just like to have the possibility of using an external server at a reasonable cost, where I can only create databases that are perfectly manageable with the direct database manager.
I could maybe do a test with one of the servers created on Hetzner (ubuntu) creating two or three databases and check if they can be managed by the sites
Take a look at this
He does a lot of development in Flutter Flow, Draftbit, other tools.
But posts a lot about the database backend tools and services.
Here he talks about nocodb which at first glance seems like it is just about an airtable alternative.
But it is far more than that and can be hosted on your own server or you can use their server.
Which link I find provider DO for mysql remote?