Adminer is a full-featured database management tool written in PHP. It consist of a single PHP file which is ready to deploy on the target server. Adminer supports MySQL, PostgreSQL, SQLite, SQL Server, and Oracle, and runs under PHP4 or PHP5. Adminer can modify tables, indexes, foreign keys, views, stored procedures, functions, and triggers. It’s easy to browse or update data, and run your own SQL queries.
Connect to a database server with username and password
Select an existing database or create a new one
List fields, indexes, foreign keys and triggers of table
Execute any SQL command from a text field or a file
Show processes and kill them
Export database, data, structure, views, routines to SQL or CSV.
You can download lastet version of adminer from Adminer official website. Alternatively you can also download adminer using following command:
# cd /tmp
# wget https://www.adminer.org/static/download/4.2.2/adminer-4.2.2.php
Move the adminer php file into DocumentRoot.
# mv adminer-4.2.2.php /var/www/html/adminer.php
Finally, open and point to your browser at ‘adminer‘ directory.
List of Database supported by Adminer: