Wharfbase
MariaDB
MariaDB databases are found in containers by their image, and on the host by their process and config files (host scan).
| Plan | Community (every plan) |
| Default ports | 3306 |
| Also recognized | MariaDB Galera, Bitnami MariaDB |
| Credential hints from | MARIADB_USER, MYSQL_USER, MARIADB_PASSWORD, MYSQL_PASSWORD, MARIADB_ROOT_PASSWORD, MYSQL_ROOT_PASSWORD, MARIADB_PASSWORD_FILE, MYSQL_PASSWORD_FILE, MARIADB_ROOT_PASSWORD_FILE, MYSQL_ROOT_PASSWORD_FILE, MARIADB_DATABASE, MYSQL_DATABASE |
| Data in the container | /var/lib/mysql, /bitnami/mariadb/data, /bitnami/mariadb, /config/databases |
| On the host (host scan) | mariadbd, mysqld |
What you can do
Section titled “What you can do”The same as MySQL: browse and edit, the SQL editor, exports and imports, with MariaDB’s own syntax and types.
A least-privilege user
Section titled “A least-privilege user”Wharfbase works with any user; give it only what you want it to do.
Read only
Section titled “Read only”CREATE USER 'wharfbase_ro'@'%' IDENTIFIED BY '…';GRANT SELECT, SHOW VIEW ON app.* TO 'wharfbase_ro'@'%';Read and write
Section titled “Read and write”CREATE USER 'wharfbase_rw'@'%' IDENTIFIED BY '…';GRANT SELECT, INSERT, UPDATE, DELETE, SHOW VIEW ON app.* TO 'wharfbase_rw'@'%';For other features
Section titled “For other features”- Live consumers:
GRANT PROCESS ON *.* TO 'wharfbase_ro'@'%'; - Backups (
mariadb-dump): addTRIGGERon the database, and on MariaDB 11.3 and laterSHOW CREATE ROUTINEon the database. Without it, stored procedures are silently left out of the dump.
Checked against MariaDB 11.4, including a dump with and without SHOW CREATE ROUTINE.