At the First Click
Charly's Column – Adminer

Sys admin columnist Charly freely admits that he doesn't like SQL and phpMyAdmin any more than he does COBOL. Instead, meet his new best friend; the slim, attractive database tool known as Adminer.
When I was young and AIX 4 was in its infancy, we had a full-time database administrator at the data center who could not only recite the whole SQL command set forwards, but could also type it backwards. Behind his back, the trainees called him GRANT
[1] father. Fortunately, I didn't inherit his job, because on my popularity scale, SQL ranks at about the same level as COBOL – I learned both once, and I try hard not to use either.
But unlike Cobol, SQL often sticks to the sole of my shoe like a piece of old chewing gum. So, I was looking for a tool that makes the most common SQL operations easier for me and isn't called phpMyAdmin, because I don't like that much either. I hit the bullseye with the tool I found: Adminder [2]! To my mind, this tool gets just about everything right.
First, there is the size. The variant with more than 40 languages gets by with about 470KB. If I limit myself to German or English for the program interface, this drops to hardly more than 300KB. The next surprise: I didn't have to unpack anything, because Adminer consists of a single PHP file. I copied it to a management server on the internal LAN. Adminer users need to go through LDAP authentication just once. Its maker, Jakub Vrána, does not recommend installing the tool directly on the database server.
Minor Interventions
The selection of databases that Adminer understands should be sufficient for most admins: MySQL, MariaDB, PostgreSQL, SQlite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch, and MongoDB. Plugins are available from third-party sources, for example for managing Moodle or WordPress databases.
However, I don't need anything like that. I'm usually just doing annoying everyday repairs. For example, when a field in a database is limited to 128 characters, but I want to accommodate 200 characters. Or another common task: I need to quickly add another field to a table. This means that I am only using two percent of Adminer's feature set. But it is simply a pleasure to work with Adminer, and the pleasantly simple design maximizes the fun (Figure 1).
I could even create functions and stored procedures with Adminer – but I prefer to take a more hands-off approach than that. When I'm faced with difficult tasks, I prefer to ask one of the trainees from back in the day, the one they now call GRANT
father behind his back.
Infos
- SQL-GRANT-Kommando: https://dev.mysql.com/doc/refman/8.0/en/grant.html
- Adminer: https://www.adminer.org
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
Direct Download
Read full article as PDF:
Price $2.95
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Find SysAdmin Jobs
News
-
LibreOffice 7.5 has Arrived and is Loaded with New Features and Improvements
The favorite office suite of the Linux community has a new release that includes some visual refreshing and new features across all modules.
-
The Next Major Release of Elementary OS Has Arrived
It's been over a year since the developers of elementary OS released version 6.1 (Jólnir) but they've finally made their latest release (Horus) available with a renewed focus on the user.
-
KDE Plasma 5.27 Beta Is Ready for Testing
The latest beta iteration of the KDE Plasma desktop is now available and includes some important additions and fixes.
-
Netrunner OS 23 Is Now Available
The latest version of this Linux distribution is now based on Debian Bullseye and is ready for installation and finally hits the KDE 5.20 branch of the desktop.
-
New Linux Distribution Built for Gamers
With a Gnome desktop that offers different layouts and a custom kernel, PikaOS is a great option for gamers of all types.
-
System76 Beefs Up Popular Pangolin Laptop
The darling of open-source-powered laptops and desktops will soon drop a new AMD Ryzen 7-powered version of their popular Pangolin laptop.
-
Nobara Project Is a Modified Version of Fedora with User-Friendly Fixes
If you're looking for a version of Fedora that includes third-party and proprietary packages, look no further than the Nobara Project.
-
Gnome 44 Now Has a Release Date
Gnome 44 will be officially released on March 22, 2023.
-
Nitrux 2.6 Available with Kernel 6.1 and a Major Change
The developers of Nitrux have officially released version 2.6 of their Linux distribution with plenty of new features to excite users.
-
Vanilla OS Initial Release Is Now Available
A stock GNOME experience with on-demand immutability finally sees its first production release.