- Download the latest version of phpLiteAdmin.
- Unzip and open the downloaded file, phpliteadmin.php, in a text editor.
- If you want to have a directory scanned for your databases instead of listing them manually, specify the directory as the value of the
$directoryvariable. Also, you may choose to have all of its subdirectories scanned infinitely deep by setting the
$subdirectoriesvariable to true.
- If you want to specify your databases manually, set the value of the
$directoryvariable as false and modify the
$databasesarray to hold the databases you would like to manage.
pathfield is the file path of the database relative to where phpliteadmin.php will be located on the server. For example, if phpliteadmin.php is located at
databases/manager/phpliteadmin.phpand you want to manage
pathvalue would be
namefield is the human-friendly way of referencing the database within the application. It can be anything you want.
- Modify the
$passwordvariable to be the password used for gaining access to the phpLiteAdmin tool.
- If you want to have multiple installations of phpLiteAdmin on the same server, change the
$cookie_namevariable to be unique for each installation (optional).
- Save and upload phpliteadmin.php to your web server.
- Open a web browser and navigate to the uploaded phpliteadmin.php file. You will be prompted to enter a password. Use the same password you set in step 4.
- You may optionally edit the CSS or use one of the pre-made themes to customize the look of phpLiteAdmin. Follow the instructions described on the Themes page.
See Configuration for the documentation of all configuration options.
Dependency: SQLite library for PHP
If you do not have a webserver and php installed yet and only want to run phpLiteAdmin, read the NoWebserver wikipage.
You need some SQLite library for PHP installed. This can be either:
- PDO (with the SQLite driver installed)
- SQLiteDatabase (version 2)
Usually PHP 5.3 upwards comes with one of these, but if phpLiteAdmin does not work, make sure one of them is installed.
On Ubuntu (since 16.04) or Debian (since Stretch), you might do so using:
# apt-get install php-sqlite3
On older Ubuntu (precise/trusty) or Debian (Wheezy/Jessie) Linux, you might do so using:
# apt-get install php5-sqlite
Of course you also need PHP >=5.2.4 installed and a webserver like apache.
If you want to work with database files larger than 2 GB, you should use a 64 bit (x64) php version.
The following PHP extensions are recommended to be installed:
On Debian based systems, this can be installed with something like:
# apt-get install php-sqlite3 php-pdo-sqlite php-mbstring openssl