Traefik HTTPS + Docker

Apache + PHP 7.3 Stack

Web root aktif ada di htdocs/. Halaman ini merangkum link utama, status extension PHP, kredensial default, dan contoh SQL cepat untuk MySQL, MariaDB, dan SQL Server.

Access

Apache/PHP: https://your-app-host
phpMyAdmin: https://your-pma-host
Health JSON: https://your-app-host/health.php
DB test page: https://your-app-host/db-test.php
3 SQL connection test: https://your-app-host/sql-connections.php
3 SQL connection JSON: https://your-app-host/sql-connections.json.php

Akses database dari host VPS tetap local-only.

MySQL: 127.0.0.1:3308
MariaDB: 127.0.0.1:3307
SQL Server: 127.0.0.1:1433

Loaded Extensions

mysqli: loaded
pdo_mysql: loaded
sqlsrv: loaded
pdo_sqlsrv: loaded

Default Credentials

MySQL

Database: mysql_app_db
User: mysql_user
Password: mysql_pass123!
Root: mysqlroot123!

MariaDB

Database: app_db
User: app_user
Password: app_pass123!
Root: root123!

SQL Server

User: sa
Password: StrongPassw0rd!

Quick SQL Usage

MySQL

CLI: mysql -h 127.0.0.1 -P 3308 -u mysql_user -p
Database: mysql_app_db

CREATE TABLE sample_users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO sample_users (name) VALUES ('Hanif');
SELECT * FROM sample_users;

MariaDB

CLI: mysql -h 127.0.0.1 -P 3307 -u app_user -p
Database: app_db

CREATE TABLE sample_users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO sample_users (name) VALUES ('Hanif');
SELECT * FROM sample_users;

SQL Server

CLI: sqlcmd -S 127.0.0.1,1433 -U sa -P 'StrongPassw0rd!'
Database: master

CREATE TABLE sample_users (
    id INT IDENTITY(1,1) PRIMARY KEY,
    name NVARCHAR(100) NOT NULL,
    created_at DATETIME2 DEFAULT SYSDATETIME()
);

INSERT INTO sample_users (name) VALUES ('Hanif');
SELECT * FROM sample_users;