Adminer

Database management tool based on Adminer.

Supports MySQL, MariaDB, PostgreSQL, and SQLite.

Usage

Clone

git clone https://git.paucapo.com/server/adminer.git

Serve the directory with any PHP 8.4 web server and open index.php.

Docker

docker run -p 8080:80 git.paucapo.com/server/adminer

Then open http://localhost:8080.

Docker Compose

services:
  adminer:
    image: git.paucapo.com/server/adminer
    container_name: adminer
    restart: unless-stopped
    #network_mode: host
    ports:
      - 8080:80
    #environment:
    #  - UPLOAD_MAX_FILESIZE=2G
    volumes:
      - ./servers.php:/var/www/html/servers.php

Then open http://localhost:8080 (or http://localhost:80 if using network_mode: host).

Warning: When using network_mode: host, PHP's MySQL driver treats localhost as a Unix socket path, which fails inside the container. Add this to the end of servers.php to force TCP connections:

if (isset($_POST['auth']['server']) && ($_POST['auth']['server'] === 'localhost' || $_POST['auth']['server'] === '')) {
    $_POST['auth']['server'] = '127.0.0.1';
}
if (isset($_GET['server']) && ($_GET['server'] === 'localhost' || $_GET['server'] === '')) {
    $_GET['server'] = '127.0.0.1';
}

Environment variables

Variable	Default	Description
UPLOAD_MAX_FILESIZE	2G	PHP upload_max_filesize and post_max_size

docker run -p 8080:80 -e UPLOAD_MAX_FILESIZE=512M git.paucapo.com/server/adminer

Server configuration

To restrict which database servers can be accessed, mount a servers.php file:

docker run -p 8080:80 -v ./servers.php:/var/www/html/servers.php git.paucapo.com/server/adminer

Example servers.php:

<?php
$allowed_servers = [
    'database',
    'localhost',
];

Build

./build.sh

Builds a multi-platform image (amd64, arm64) and pushes to the registry. Requires being logged in:

docker login https://git.paucapo.com/