Adminer

Presentation

• Adminer is a lighweight, open-source tool to manage databases.
• It supports MySQL / MariaDB, PostgreSQL, SQLite, Oracle, CockroachDB, .. and non-SQL (Elastic, MongoDB, ...) through plugins
• Allows to CRUD databases, execute SQL queries, import / export data, manage users and privileges
• Alternatives : phpMyAdmin.

Benefits

• lightweight (500ko)
• secure
• ux

Installation and setup

• download and save in a server root directory

configuration

• use the interface to enter DB, server, username, password infos
• secure the installation
  • rename adminer file
  • protect folder
  • restrict access to IP

Sources

https://www.adminer.org/en/

https://www.youtube.com/watch?v=aq540Cegc_o https://www.cloudways.com/blog/adminer-vs-phpmyadmin/