At the First Click
Charly's Column – Adminer
![](/var/linux_magazin/storage/images/issues/2019/222/charly-s-column-adminer/kuehnast_charly_4.png/746031-1-eng-US/Kuehnast_Charly_4.png_medium.png)
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).
![](/var/linux_magazin/storage/images/issues/2019/222/charly-s-column-adminer/figure-1/746034-1-eng-US/Figure-1_large.png)
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
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
![Learn More](https://www.linux-magazine.com/var/linux_magazin/storage/images/media/linux-magazine-eng-us/images/misc/learn-more/834592-1-eng-US/Learn-More_medium.png)
News
-
NVIDIA Released Driver for Upcoming NVIDIA 560 GPU for Linux
Not only has NVIDIA released the driver for its upcoming CPU series, it's the first release that defaults to using open-source GPU kernel modules.
-
OpenMandriva Lx 24.07 Released
If you’re into rolling release Linux distributions, OpenMandriva ROME has a new snapshot with a new kernel.
-
Kernel 6.10 Available for General Usage
Linus Torvalds has released the 6.10 kernel and it includes significant performance increases for Intel Core hybrid systems and more.
-
TUXEDO Computers Releases InfinityBook Pro 14 Gen9 Laptop
Sporting either AMD or Intel CPUs, the TUXEDO InfinityBook Pro 14 is an extremely compact, lightweight, sturdy powerhouse.
-
Google Extends Support for Linux Kernels Used for Android
Because the LTS Linux kernel releases are so important to Android, Google has decided to extend the support period beyond that offered by the kernel development team.
-
Linux Mint 22 Stable Delayed
If you're anxious about getting your hands on the stable release of Linux Mint 22, it looks as if you're going to have to wait a bit longer.
-
Nitrux 3.5.1 Available for Install
The latest version of the immutable, systemd-free distribution includes an updated kernel and NVIDIA driver.
-
Debian 12.6 Released with Plenty of Bug Fixes and Updates
The sixth update to Debian "Bookworm" is all about security mitigations and making adjustments for some "serious problems."
-
Canonical Offers 12-Year LTS for Open Source Docker Images
Canonical is expanding its LTS offering to reach beyond the DEB packages with a new distro-less Docker image.
-
Plasma Desktop 6.1 Released with Several Enhancements
If you're a fan of Plasma Desktop, you should be excited about this new point release.