Accessing a database (Mysql) from devices created on the knee?

Question

Do it yourself

There is an idea for a device, an access control system that will exchange information with the database, but I'm going to do it from scratch (I took such a task at the university), it's clear about readers, but how to transfer data over the Internet? What do you need to buy, study?

Answer 1

screw the simplest web page and drive on http

Answer 2

Communication protocols, ports, e.g. mysql

Answer 3

you will not work directly with the database (man "three-tier architecture")
you will have "business logic". then make api (man rest/jsonrpc/mqtt/younameit)
and in the device "on your knee" do work with api according to the selected protocol

Answer 4

free hosting, washed down the page there and everything, it seems to me the easiest way