I made an app that works locally and wanted to expand it in order to use a hosting service for its Database. I have created an InfinityFree account with the free plan and created a new database. Using phpadmin I created the tables like the ones I had in my local workbench database.
Now the issue is that when I try to connect it gives me multiple errors of access and I dont know if its because I’m in a free plan or something else
iFastNet does support remote MySQL on all their plans.
However, I would like to clearly state that connecting a mobile app to a database is a very bad idea. Anyone who has access to the mobile app can extract your database credentials, and use that to read and write any data they want. Premium hosting has the option to create database users with limited permissions, but those are not so fine grained that you can limit access to specific data.
That’s why it’s more common to have a server side application in between. The server side application can expose a HTTP API that your app can talk to, and that server application stores the data in the database. And in that server application, you can implement whatever authentication or access controls are needed for your app.