Introduction

BetterMyAdmin is a free software tool written in TypeScript that is intended to handle the administration of a MySQL or MariaDB database server. It is a feature-for-feature port of phpMyAdmin to Node.js and React: the same pages, the same configuration directives (with the same names and defaults) and the same Docker variables, with a modern interface and no PHP. You can use BetterMyAdmin to perform most administration tasks, including creating a database, running queries, and adding user accounts.

BetterMyAdmin runs as one Node.js process, or as the Docker image ghcr.io/cb-sigma/better-myadmin, that serves both the web application and its API; it needs no web server in front of it. The intentional differences from phpMyAdmin are listed, each with its rationale, in the parity exceptions register.

Supported features

Currently BetterMyAdmin can:

  • create, browse, edit, and drop databases, tables, views, columns, and indexes

  • display multiple results sets through stored procedures or queries

  • create, copy, drop, rename and alter databases, tables, columns and indexes

  • maintenance server, databases and tables, with proposals on server configuration

  • execute, edit and bookmark any SQL-statement, even batch-queries

  • load text files into tables

  • create [1] and read dumps of tables

  • export [1] data to various formats: CSV, XML, JSON, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Microsoft Word 2000, LATEX, YAML and JavaScript module formats

  • import data and MySQL structures from OpenDocument spreadsheets, as well as XML, CSV, and SQL files

  • administer multiple servers

  • add, edit, and remove MySQL user accounts and privileges

  • check referential integrity in MyISAM tables

  • create graphics of your database layout (SVG, EPS and Dia)

  • search globally in a database or a subset of it

  • transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link

  • track changes on databases, tables and views

  • support InnoDB tables and foreign keys

  • create, edit, call, export and drop stored procedures and functions

  • create, edit, export and drop events and triggers

  • communicate in the languages of phpMyAdmin’s translations

Shortcut keys

Currently BetterMyAdmin supports following shortcuts:

  • k and CTRL+k - Toggle console

  • CTRL+ALT+c - Toggle console

  • h - Go to home page

  • s - Open the navigation panel settings

  • e - Export

  • d + s - Go to database structure (Provided you are in database related page)

  • d + f - Search database (Provided you are in database related page)

  • t + s - Go to table structure (Provided you are in table related page)

  • t + f - Search table (Provided you are in table related page)

  • backspace - Takes you to older page.

  • ? - Show the list of shortcuts

  • CTRL+SHIFT+p (CMD+SHIFT+p on macOS) - Open the command palette, see Command palette

A word about users

Many people have difficulty understanding the concept of user management with regards to BetterMyAdmin. When a user logs in to BetterMyAdmin, that username and password are passed directly to MySQL. BetterMyAdmin does no account management on its own (other than allowing one to manipulate the MySQL user account information); all users must be valid MySQL users.

Footnotes