JSOPanel Get started
Help Center › Website Owners › Browsing your database

Browsing your database

View and edit the contents of your database directly in your browser, no separate software needed.

JSOPanel includes a built-in database browsing tool (Adminer), so you can view and edit the tables and rows inside any of your databases directly in your web browser, without installing any separate database software on your computer.

Steps

  1. Click Databases in the sidebar.
  2. Find the database you want to open in your list of databases.
  3. Click Adminer next to it.

This opens Adminer in a new tab, automatically signed in with that specific database's own credentials. You won't need to type its username and password again.

What you can do

  • Browse the tables and see the data stored inside them
  • Add, edit, or delete individual rows of data
  • Run your own custom queries, if you're comfortable with database query language

Exporting and importing, from the Databases page itself

Back on the Databases page (not inside Adminer), each database also has its own Export and Import buttons. Export downloads a full copy of the database as a file. Import replaces the content of that one database with a file you upload, a safety copy of what's currently there is taken automatically first, in case the file turns out to be the wrong one.

Changing a database's password or access level

Click Manage next to a database to open its own dialog, from which you can set a new password for it (this also updates the stored credentials, so Adminer sign-on keeps working), or change its privileges to Full access, Read and write only (no schema changes), or Read only, useful for handing a database's credentials to a third party without giving them the ability to change its structure.

Converting an older database to UTF-8

If a MariaDB database is shown with a not UTF-8 badge next to its character set, click Set to UTF-8 beside it to switch it over. This is normally enough for an empty, newly created database. For one that already has data in it, this only changes the database's own default for anything created in it from now on, tables that already exist keep the character set they were made with, converting existing tables with data in them is a separate job best done from a backup.

Tip: editing database contents directly in Adminer can affect how your website or application behaves. If you're not certain what a piece of data does, it's safer to make the change through your application's own admin area instead, where available.

Before making changes

If you're planning a significant edit, it's worth exporting a copy of your database first from the Databases page, or taking a full account backup. See the article on creating a backup, which lets you back up just a single database rather than your whole account if you prefer.