IMAGEBROWSER

Server Setup

1. upload contents to web folder

Even if PHP is already installed, confirm MySQL and GD support:

sudo apt update
sudo apt install php-mysql php-gd exiftool
php -v
php -m | grep -E 'pdo_mysql|gd'

Create Database

In phpMyAdmin:

Create a database, for example imagebrowser.

Use collation utf8mb4_unicode_ci.

Import:

database/schema.sql

4. Create MySQL User

You can do this in phpMyAdmin, or with MySQL CLI:

CREATE USER 'imagebrowser_user'@'localhost' IDENTIFIED BY 'your-strong-password';
GRANT ALL PRIVILEGES ON imagebrowser.* TO 'imagebrowser_user'@'localhost';
FLUSH PRIVILEGES;