Subject: How to install Ubuntu Linux Server, Apache Web Server, MariaDB
Database Server and phpMyAdmin
Good day from Singapore,
Author: Mr. Turritopsis Dohrnii Teo En Ming
Date: 25 Aug 2026 Tuesday
Time: 8.05 pm Singapore Time
Country: Singapore
Ubuntu Linux version:
Welcome to Ubuntu 24.04.3 LTS (GNU/Linux 6.8.0-100-generic x86_64)
1. Enable Apache SSL
a2enmod ssl
2. Create a self-signed certificate
mkdir -p /etc/apache2/ssl
openssl req -x509 -nodes -days 3650 \
-newkey rsa:2048 \
-keyout /etc/apache2/ssl/apache-selfsigned.key \
-out /etc/apache2/ssl/apache-selfsigned.crt
3. Create the HTTPS VirtualHost
nano /etc/apache2/sites-available/selfsigned-ssl.conf
<VirtualHost *:443>
ServerAdmin webmaster@localhost
DocumentRoot /var/www/html
SSLEngine on
SSLCertificateFile /etc/apache2/ssl/apache-selfsigned.crt
SSLCertificateKeyFile /etc/apache2/ssl/apache-selfsigned.key
ErrorLog ${APACHE_LOG_DIR}/ssl-error.log
CustomLog ${APACHE_LOG_DIR}/ssl-access.log combined
</VirtualHost>
4. Enable the HTTPS site
a2ensite selfsigned-ssl.conf
apache2ctl configtest
systemctl reload apache2
ss -lntp | grep :443
5. Open firewall port
ufw status verbose
ufw allow 'Apache Full'
ufw status
6. Stop Zabbix
killall zabbix_server
systemctl disable zabbix-server
reboot
=============================================================
I already have MariaDB Database server installed previously
No need to install again
=============================================================
1. Install phpMyAdmin
apt-get update
apt install phpmyadmin
During installation, you may see configuration screens.
When asked “Web server to reconfigure automatically”, select:
[*] apache2
Configure database for phpmyadmin with dbconfig-common?
Choose Yes. You'll normally be asked to create/confirm a password for
phpMyAdmin's database configuration.
2. Enable the required PHP module and restart Apache
phpenmod mbstring
systemctl restart apache2
3. Open phpMyAdmin
https://fqdn/phpmyadmin/
Regards,
Mr. Turritopsis Dohrnii Teo En Ming
Diehard hardcore PAP government supporter
25 Aug 2026 Tuesday 11.10 pm Singapore Time
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
