Database-Specific
Using WhoDB with MySQL
Using WhoDB with MySQL
This page covers what is specific to MySQL and MariaDB when you use them through WhoDB: connecting, database switching, and which WhoDB features apply.
Connecting
Select MySQL or MariaDB on the login page. The form asks for:
- Hostname, Username, Password, and Database (all required).
Advanced options include:
- Port — defaults to
3306. - Parse Time (
True) and Loc (UTC) — control how the driver handles date/time values. - Allow clear text passwords (
0). - SSL mode —
DISABLED,PREFERRED,REQUIRED,VERIFY_CA, orVERIFY_IDENTITY.
Tip
For production databases, connect with a read-only account. WhoDB edits rows directly from the grid, so browsing with a read-only user prevents accidental changes.
How WhoDB Presents MySQL
- MySQL has no schema layer inside a database, so instead of a schema dropdown the sidebar offers database switching: pick a different database on the same server without logging in again. System databases (
information_schema,mysql,performance_schema,sys) are hidden. - Tables and views appear as storage units. Tables support row viewing, inserts, updates, deletes, and data import; views are read-only.
- Column types, primary keys, and foreign keys are read from the catalog, so the grid and graph reflect your actual schema.
WhoDB Features with MySQL
- Scratchpad — run MySQL SQL, including multiple statements in one cell. See Scratchpad.
- Graph view — visualizes foreign-key relationships between tables in the current database. See Graph View.
- Where conditions — the filter builder offers MySQL operators such as
=,LIKE,BETWEEN,IN, andIS NULL. See Where Conditions. - Mock data generation — generates rows for tables and follows foreign-key dependencies so parent rows are created first. See Mock Data.
- Export — CSV and Excel from the grid or Scratchpad results. See Export Options.
Tips
- Add a
LIMITto exploratory Scratchpad queries on large tables; unboundedSELECTstatements pull every row. - Foreign keys drive both the graph view and mock data ordering — tables without declared foreign keys show no relationships.
- Filter with the where-condition builder before exporting so the file contains only the rows you need.
Compatible Databases
TiDB is MySQL-compatible and appears as its own entry on the login page (default port 4000) with the same MySQL-style experience in WhoDB.
Further Reading
For server tuning, storage engines, replication, and backup guidance, see the official MySQL documentation or the MariaDB documentation.