2022 TUTORIAL: HOW TO INSTALL LAMP AND THE ADMINER MYSQL DB MANAGEMENT TOOL ON UBUNTU 20.04 LTS
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. It is a tool for managing content in MySQL databases and distributed under Apache license in a form of a single PHP file. Its author is Jakub Vrána who started to develop this tool as a light-weight alternative to phpMyAdmin, in July 2007. It supports most of the common open database engines such as MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB and others via plugin. In this tutorial you will learn HOW TO INSTALL LAMP AND THE ADMINER MYSQL DATABASE MANAGEMENT TOOL ON UBUNTU 20.04 LTS. The installation will be done on a cloud hosted ubuntu server on AWS LIGHTSAIL. You will also learn how to set a static IP address on an AWS LIGHTSAIL instance, how to download the keypair file for the instance and connect via SSH, how to install UBUNTU 20.02 updates and the LAMP stack (Linux, Apache, MySQL, and PHP).