Skip to main content

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.

MySQL UI connects directly to any MySQL server using standard credentials — no software to install on your machine beyond a modern browser. Each connection opens in its own tab, so you can work with multiple servers or databases side by side.

Connection form fields

host
string
default:"localhost"
required
The hostname or IP address of your MySQL server. Use localhost to connect to a MySQL server running on the same machine, or enter a remote hostname such as db.example.com.
port
number
default:"3306"
required
The TCP port MySQL is listening on. The standard MySQL port is 3306. Change this only if your server is configured to use a non-default port.
user
string
default:"root"
required
The MySQL username to authenticate as. This user must have permission to connect from the host running MySQL UI.
password
string
The password for the MySQL user. Leave blank if the account has no password set.
database
string
A specific database to open immediately after connecting. This field is optional — if you leave it blank, you can select a database from the sidebar after the connection is established.

How to connect

1

Fill in your connection details

Enter the host, port, username, and password for your MySQL server. If you want to open a specific database straight away, enter its name in the Database field.
2

Click Connect

MySQL UI tests the connection immediately. A spinner appears in the button while the connection is being verified.
3

Start working

If the connection succeeds, a new tab opens in the tab bar and the sidebar loads your available databases. Select a database to begin browsing tables and running queries.

If the connection fails

MySQL UI shows an error message describing what went wrong. Common causes include:
  • Wrong host or port — confirm the server address and that the port is open and reachable.
  • Wrong credentials — double-check the username and password.
  • Firewall blocking the port — ensure port 3306 (or your custom port) is accessible from the host running MySQL UI.
  • MySQL user permissions — the user must be granted access from the connecting host. Check with your database administrator if you are unsure.

Opening multiple connections

You can maintain connections to several servers at once. Click New Connection in the tab bar to open a fresh connection form without closing any existing connections.

Password storage

Passwords are saved in your browser’s localStorage. Anyone with access to your browser profile can retrieve them. Avoid connecting as root on production servers — use a dedicated account with only the permissions your work requires.