How to access a local SQLite database

To access a local SQLite database, you can use Adminer, which is a lightweight and user-friendly web-based database management tool that supports multiple database systems, including SQLite. Here are the steps to access a local SQLite database with Adminer:

1. Download Adminer SQLite 3 with password plugin
2. Copy the PHP file to your web server, such as /var/www/html, you can rename it to a shorter name such as adminer.php.
3. Open the Adminer page in a web browser: Open a web browser and navigate to the URL of the Adminer file on your web server, such as http://localhost/adminer.php.
4. On the webpage, specify the “server file system” path of an existing database. Note it should be a relative path which relative to adminer.php.
   

Why should we choose this plugin instead of Adminer directly?

Adminer 4.6.3 and newer does not support accessing a database without a password due to security concerns, while we don’t really need to provide credentials (username and password) to access a SQLite database. This plugin can solve this problem, however, it should never be used in a production environment.