MySQL UI gets you from zero to a live database connection in under a minute. This guide walks you through opening a connection, navigating your databases, browsing table data, and running your first SQL query.Documentation Index
Fetch the complete documentation index at: https://docs.w22.dev/llms.txt
Use this file to discover all available pages before exploring further.
Open MySQL UI in your browser
Navigate to your MySQL UI instance in any modern browser. You’ll land on the connection screen, which is the starting point for every session.
Enter your connection details
Fill in the fields on the connection form:
Update any values that differ from your setup. If you’re connecting to a local development server, the defaults are likely already correct.
| Field | Default | Description |
|---|---|---|
| Host | localhost | The hostname or IP address of your MySQL server |
| Port | 3306 | The port your MySQL server listens on |
| Username | root | Your MySQL username |
| Password | (none) | Your MySQL password |
| Database | (optional) | A specific database to open — you can also choose one after connecting |
You can save your connection details for quick reuse. Enter an optional name in the connection name field, then click Save before or after connecting. Saved connections appear in a panel on the left of the connection screen, and you can reconnect to any of them with a single click.
Click Connect
Click the Connect button. MySQL UI tests the connection immediately and shows a success message when it establishes contact with your server. If the connection fails, an error message explains what went wrong — check your host, port, credentials, and network access, then try again.Once connected, your database session opens in a new tab in the tab bar at the top of the screen. You can open additional connections at any time by clicking + New Connection in the tab bar.
Select a database
After connecting, use the sidebar dropdown to choose which database you want to work with. The sidebar lists all databases your user account has access to. Select one and the sidebar populates with its tables.
Open a table
Click any table name in the sidebar to open it in the data view. You’ll see a paginated grid of rows with controls to sort by column, filter results, and page through the data. You can also click directly into a cell to edit its value.