Sometimes you just want to look at your data — see what's in a table, fix one wrong row, run a quick query, or pull a full export. phpMyAdmin is a web interface that does all of that for a MySQL database, and Falix has it built in. No driver, no code, no local install: click a button and you're in.
| At a glance | |
|---|---|
| You need | a MySQL managed database (Add a database) |
| Plan | any |
| Time | ten minutes to find your way around |
Open it — you're already signed in
phpMyAdmin is MySQL-only on Falix. Open the Databases page from your server menu, find a MySQL database in the list, and click its phpMyAdmin button. A new browser tab opens already signed in to that database — the panel logs you in for you, so there's no username or password to type. (PostgreSQL and MongoDB databases don't get the button; they have no phpMyAdmin.)
🎯 Good to know: You land connected to your database only. The account phpMyAdmin uses is your database's own user, which can see nothing but this one database — so you won't find other people's data or a user-management screen here. Falix creates and rotates the database's user and password for you on the Databases page, not in phpMyAdmin.
The left sidebar lists your database and, underneath it, its tables. Click a table name to work with it; the tabs across the top change what you're doing.
The tabs you'll actually use
| Tab | What it's for |
|---|---|
| Browse | See the rows in a table. Edit or delete any row inline with the pencil and bin icons |
| Structure | The table's columns, types, and indexes. Add a column, change a type, or add an index here |
| SQL | A box to run any query — paste a SELECT, INSERT, or UPDATE and press Go |
| Search | Build a filter without writing SQL — pick a column, an operator, a value |
| Insert | A form to add one row by filling in each column |
| Import | Upload a .sql (or .csv) file and run it — how you restore a dump or load seed data |
| Export | Download the table or whole database as a file — a .sql dump for backups or moving data |
| Operations | Rename, empty, or drop the table; other housekeeping |
Browse: read and fix data
Browse is the everyday view — your rows in a grid. Each row has an edit (pencil) and delete (bin) control, so correcting a single wrong value is a two-click job. It's the fastest way to answer "did my app actually write that?".
SQL: run a query
The SQL tab is a plain text box. Anything from Just enough SQL runs here — a SELECT to check data, an UPDATE to fix a batch, a CREATE TABLE to add one. Type it, press Go, and the results (or the row count changed) appear below.
Structure: change the shape
Structure shows every column with its type, and lets you add a new one, change a type, or add an index through a form instead of an ALTER TABLE statement. Handy for a quick tweak — but for a schema that's actively evolving, prefer versioned migrations so every change is repeatable and recorded, not a one-off click.
Export and Import: dumps
Export produces a downloadable file of your data. For a full copy, leave it on SQL format and Quick method and press Go — you get a .sql file that recreates every table and row. Choose Custom when you want only certain tables or a different format like CSV. Import is the reverse: upload a .sql file and phpMyAdmin runs it, which is how you restore an export or seed a fresh database.
💡 Tip: An Export is a genuine backup you can keep off-platform. For scheduled, one-click backups of the whole database instead, use the Manual and Automatic backup tabs on the Databases page — see Database backups.
Be careful in here
⚠️ Heads up: phpMyAdmin runs your commands for real, immediately. A
DELETEorUPDATEwith noWHERE, or Drop on the Operations tab, is permanent — there's no undo button. Take an Export (or a database backup) before anything destructive, and always write theWHEREclause before the rest of the statement.
Verify it works
Open phpMyAdmin on a fresh database and you'll land on it with an empty table list — proof it's live and you're connected. Create a table on the SQL tab, switch to Browse, and you'll see it appear in the sidebar. That round trip — write in one tab, see it in another — confirms everything is wired up.
Troubleshooting
- No phpMyAdmin button — the database isn't MySQL. Only MySQL databases get phpMyAdmin; PostgreSQL and MongoDB don't.
- The button did nothing / an error popped up — the sign-in link is short-lived. Click phpMyAdmin again to get a fresh one, and allow the pop-up/new tab if your browser blocked it.
- I can only see one database — that's correct. Your database user is scoped to this single database; there's nothing hidden.
- An import failed partway — the
.sqlfile references a table or column that doesn't exist yet, or the file is for a different engine. Read the error phpMyAdmin prints; it names the statement that failed.
Everything past this is standard phpMyAdmin — its official documentation at phpmyadmin.net covers every tab in depth.