{"id":1629,"date":"2015-12-17T03:55:41","date_gmt":"2015-12-17T09:55:41","guid":{"rendered":"http:\/\/www.supportpro.com\/blog\/?p=1629"},"modified":"2026-05-29T00:51:11","modified_gmt":"2026-05-29T06:51:11","slug":"adminer","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/adminer\/","title":{"rendered":"How to Install and Use Adminer on Linux Servers"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Managing databases through a lightweight and simple interface can save administrators a lot of time. Adminer is a popular PHP-based database management tool that offers an efficient alternative to phpMyAdmin. It supports multiple database systems and provides a clean interface for managing databases, tables, users, and SQL queries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this guide, we\u2019ll explain what Adminer is, its key features, prerequisites, and how to install and access Adminer on a Linux server.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is Adminer?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Adminer is an open-source database management tool written in PHP. It allows administrators and developers to manage databases directly from a web browser.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Unlike traditional database tools that focus mainly on MySQL, Adminer supports several database engines, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MySQL<\/li>\n\n\n\n<li>MariaDB<\/li>\n\n\n\n<li>PostgreSQL<\/li>\n\n\n\n<li>SQLite<\/li>\n\n\n\n<li>Oracle<\/li>\n\n\n\n<li>MongoDB<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Because it is lightweight and easy to deploy, Adminer is widely used for quick database administration tasks.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Features of Adminer<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Adminer includes several useful database management features, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create, modify, and delete databases and tables<\/li>\n\n\n\n<li>Manage views, triggers, procedures, and permissions<\/li>\n\n\n\n<li>Execute SQL queries directly from the interface<\/li>\n\n\n\n<li>Import and export databases<\/li>\n\n\n\n<li>Export database structures and data to SQL or CSV format<\/li>\n\n\n\n<li>Manage users and database variables<\/li>\n\n\n\n<li>Lightweight single-file installation<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before installing Adminer, ensure your server has the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Apache or another web server<\/li>\n\n\n\n<li>PHP 5 or later with sessions enabled<\/li>\n\n\n\n<li>A supported database server such as MySQL or PostgreSQL<\/li>\n\n\n\n<li>Access to the server through SSH<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Installing Adminer on Linux<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Download Adminer<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Navigate to your web server document root and download the latest Adminer package.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wget http:\/\/downloads.sourceforge.net\/adminer\/adminer-4.0.2.zip<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Extract the Package<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Unzip the downloaded file.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>unzip adminer-4.0.2.zip<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Set Proper Permissions<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Assign the correct ownership to the extracted directory.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chown -R nobody. adminer-4.0.2<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Accessing Adminer<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once the installation is complete, open your browser and access Adminer using your server hostname or IP address.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>http:&#47;&#47;localhost\/adminer-4.0.2\/adminer<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">or<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>http:&#47;&#47;your-server-ip\/adminer-4.0.2\/adminer<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You will see the Adminer login page.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Enter your database server details, username, and password to log in.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.supportpro.com\/requestquote.php\"><img fetchpriority=\"high\" decoding=\"async\" width=\"780\" height=\"356\" src=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer1.jpg\" alt=\"login page of adminer\" class=\"wp-image-1630\" srcset=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer1.jpg 780w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer1-300x137.jpg 300w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Creating a Database in Adminer<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.supportpro.com\/requestquote.php\"><img decoding=\"async\" width=\"700\" height=\"348\" src=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer2.jpg\" alt=\"Creating a database in adminer\" class=\"wp-image-1631\" srcset=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer2.jpg 700w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer2-300x149.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After logging in:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Select the database server<\/li>\n\n\n\n<li>Click on \u201cCreate Database\u201d<\/li>\n\n\n\n<li>Enter the database name<\/li>\n\n\n\n<li>Save the changes<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">The new database will now be available for use.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Adminer is a lightweight yet powerful database management tool for Linux servers. Its simple setup process, support for multiple database systems, and user-friendly interface make it a great alternative to phpMyAdmin. Whether you need to manage databases, execute SQL queries, or export data, Adminer provides an efficient solution for database administration tasks.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you require help, <a href=\"https:\/\/www.supportpro.com\/requestquote.php\">contact SupportPRO Server Admin<\/a><\/p>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\"><span id=\"hs-cta-wrapper-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-node hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\"><a href=\"https:\/\/www.supportpro.com\/requestquote.php\"><\/a><\/span><\/span><\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide has-media-on-the-right is-stacked-on-mobile is-vertically-aligned-center has-white-background-color has-background\"><div class=\"wp-block-media-text__content\">\n<p class=\"has-large-font-size wp-block-paragraph\">Facing issues? <\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">Our technical support<br>engineers can solve it. <\/p>\n\n\n\n<!--HubSpot Call-to-Action Code --><span class=\"hs-cta-wrapper\" id=\"hs-cta-wrapper-3350a795-db50-482f-9911-301930d1b1be\"><span class=\"hs-cta-node hs-cta-3350a795-db50-482f-9911-301930d1b1be\" id=\"hs-cta-3350a795-db50-482f-9911-301930d1b1be\"><!--[if lte IE 8]><div id=\"hs-cta-ie-element\"><\/div><![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/2725694\/3350a795-db50-482f-9911-301930d1b1be\" ><img decoding=\"async\" class=\"hs-cta-img\" id=\"hs-cta-img-3350a795-db50-482f-9911-301930d1b1be\" style=\"border-width:0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/2725694\/3350a795-db50-482f-9911-301930d1b1be.png\"  alt=\"Contact Us today!\"\/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(2725694, '3350a795-db50-482f-9911-301930d1b1be', {\"useNewLoader\":\"true\",\"region\":\"na1\"}); <\/script><\/span><!-- end HubSpot Call-to-Action Code -->\n<\/div><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" width=\"904\" height=\"931\" src=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup.png\" alt=\"guy server checkup\" class=\"wp-image-12943 size-full\" srcset=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup.png 904w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup-291x300.png 291w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup-768x791.png 768w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2022\/09\/Free-server-checkup-585x602.png 585w\" sizes=\"(max-width: 904px) 100vw, 904px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Managing databases through a lightweight and simple interface can save administrators a lot of time. Adminer is a popular PHP-based database management tool that offers an efficient alternative to phpMyAdmin.&hellip;<\/p>\n","protected":false},"author":5,"featured_media":17269,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[6],"tags":[],"class_list":["post-1629","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux-basics"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/1629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/comments?post=1629"}],"version-history":[{"count":5,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/1629\/revisions"}],"predecessor-version":[{"id":17270,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/1629\/revisions\/17270"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/media\/17269"}],"wp:attachment":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/media?parent=1629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/categories?post=1629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/tags?post=1629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}