How to access MySQL server?

I know my MySQL server IP address, database name , login ID and password. How can i setup the connection in AppGyver?

I want to be able to connect to MySQL database, not via a REST interface, is it possible in AppGyver?

Eric

1 Like

in general, tools like this don’t connect “directly” to the database.
there middleware that connects to the db to serve your requests.
in your case, you’d probably have a PHP program to provide the REST endpoints, query the server and send the JSON back to AG.

What Jaymer says is correct but you can also use a tool like DreamFactory to generate an API for you from your database tables. It uses the information you mentioned above your DB IP, user and password and it will assess the tables in your DB and create an API directly from it. This will save you a lot of work on how to create the API yourself.
There are other solutions and I haven’t used them yet. I have an upcoming project where I am planning on using the free version of DreamFactory to generate the APIs so I can’t vouch for them 100% but it looks positive from my research so far.

in Bubble.io it has a free plugin called “SQL database connector” to access a db directly. I am disappointed that there’s no such function in AppGyver …

1 Like

I have been using Nocodb as api for MySQL.
I put it on Heroku and I’m very satisfied.