MySQL database viewer: connect, inspect and export rows
To browse MySQL, you need a running server and the details to connect to it. A viewer gives you a place to open tables and run queries. Installing one won’t create the database you’re trying to inspect.
Get your connection details
You need the host, port, database name if applicable, authentication credentials and the server’s TLS requirements. For a managed service, copy the endpoint from the service console. If the server is on a private network, connect through the required VPN or approved access path before testing the login.
Use a database account with the minimum privileges required for inspection. Sharing a screenshot of the connection form is useful only after removing passwords and other secrets.
Check which database is open
SELECT DATABASE() AS selected_database,
CURRENT_USER() AS authenticated_account,
VERSION() AS server_version;A NULL selected database means no default database is selected. It does not mean the server has no databases. The authenticated account may also differ from the username you expected because MySQL accounts include a host component.
Open a table and read a few rows
Use SHOW DATABASES and SHOW TABLES to find the appropriate objects. Inspect columns before writing a SELECT. This illustrative query assumes an orders table with the named columns:
SELECT id, status, created_at
FROM shop.orders
ORDER BY id DESC
LIMIT 50;Substitute your actual schema and column names. Keep a small sample while exploring and check the environment label before running any modifying statement.
Try the full workflow
Connect, find an order, apply a filter, inspect its values, export a sample, then reconnect. Verify that the exported row count agrees with the tool’s stated scope. If your work depends on SSH or certificate validation, test those settings rather than only trying a local unencrypted connection.
plainDB supports MySQL on Mac and Windows, including shared advanced tools and full filtered-table exports. The platform matrix describes those limits. MySQL binary-log inspection is a separate task: ordinary table browsing does not make plainDB a binlog viewer.
MySQL’s connection documentation is the reference for server/client connection concepts. For a browser-hosted client, first read the online viewer checklist.