Wharfbase
MySQL
MySQL 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 | Percona Server, Bitnami MySQL |
| Credential hints from | MYSQL_USER, MYSQL_PASSWORD, MYSQL_ROOT_PASSWORD, MYSQL_PASSWORD_FILE, MYSQL_ROOT_PASSWORD_FILE, MYSQL_DATABASE |
| Data in the container | /var/lib/mysql, /bitnami/mysql/data, /bitnami/mysql |
| On the host (host scan) | mysqld |
What you can do
Section titled “What you can do”Browse and edit tables and views; the SQL editor with Explain; exports and CSV import. Read-only connections set the session READ ONLY and run one statement at a time.
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'@'%';, or the process list shows only Wharfbase’s own sessions. - Backups (
mysqldump --single-transaction --routines --triggers --no-tablespaces): addTRIGGERon the database, andSHOW_ROUTINEon*.*(MySQL 8.0.20 and later) so stored procedures are included.
Checked against MySQL 8.4: reads work, writes are refused, the process list and the dump work.