Create a REST API for mysql database with authentication

Create a REST API for mySQL database.

API must require authentication.

API must be able to interact with to database with tables like...

CREATE DATABASE IF NOT EXISTS `testapi` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `testapi`;

CREATE TABLE `my json table` (
id int not null auto_increment primary key,
`JSON_00` json not null
);

...writting to specific parameters that are part of each json of column `JSON_00`