How to install Ubuntu Linux Server, Apache Web Server, MariaDB Database Server and phpMyAdmin

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





REFERENCES

============


[1] https://lore.kernel.org/phone-devel/sDCsZEF1dwyF1D_QPeZ8vH04TnTClhMk6dQXiHLLgWt5LTa38ZbIxWTwoe9V2vPLixRhbi2wALMn1CNinkxfyxkabMUCmYHGEnNp_xpMtwA=@protonmail.com/T/#u


[2] https://mail-archive.com/phone-devel@vger.kernel.org/msg00360.html


[3] marc.info - NIL


[4] https://lists.apache.org/thread/ko99h65xd8sdwgbjxv30ncdm7hv80rko


[5] https://mail-archive.com/users@httpd.apache.org/msg70799.html


[6] https://marc.info/?l=apache-httpd-users&m=178767102472370&w=2


[7] https://lists.freebsd.org/archives/freebsd-chat/2026-August/000087.html


[8] mail-archive.com - NIL


[9] https://marc.info/?l=freebsd-chat&m=178767127872530&w=2




Comments

Post a Comment

Popular posts from this blog

Estimated Total Expenses in Taiwan from 6 Aug 2025 to 12 Aug 2025 (Version 15 Aug 2025)

Subject: Estimated Total Expenses in Taiwan from 6 Aug 2025 to 12 Aug 2025 (Version 15 Aug 2025) ========================= Teo En Ming's Government ========================= =============================== Auditor General's Office (AGO) =============================== Scoot return air tickets $401.12 3-star hotel for 7 days 6 nights $446.42 FWD travel insurance $43.88 New backpack/haversack $54 Comfort taxi from home to Changi Airport $28 Cash withdrawal at Changi Airport $100 Changi Wi-Fi Router $55.13 Express Entry tickets to Taipei Red Expo 2025 (Taiwan Adult Expo) for 3 days 3 x $67 = $201 8 Aug 2025 Friday ================== Taiwanese model Bai Yun 20 face vouchers JAV actresses Matsumoto Ichika and Nozomi Aliyoshi 27 face vouchers JAV actress Futaba Sara 3 face vouchers Spent money on 4 girls on Friday 9 Aug 2025 Saturday ==================== JAV actress Jun Amaki round 1 - 8 face vouchers JAV actress Jun Amaki round 2 - 35 face vouchers JAV actress Ashina Honoka 3 face v...
Read more

Teo En Ming’s Book 2 (13 June 2025 Edition) Cloud Storage Download Links

Subject: Teo En Ming’s Book 2 (13 June 2025 Edition) Cloud Storage Download Links [1] Amazon Cloud Drive – Pending [2] https://www.icloud.com/iclouddrive/0e4VABr6DntnxrgSUFZr6ydlw#book_2_-_20250613 [3] https://app.box.com/s/4n5zrbshgxoo5q7tkgu2xgb6oin2n61l [4] https://www.dropbox.com/scl/fi/kb61379g5g70hlro4sate/book-2-20250613.pdf?rlkey=m7cuujx4cb3r5hq6nkmq9byfo&st=ymotp8x0&dl=0 [5] https://mega.nz/file/PDojHAxa#PfzrKz8ON1Z6Tu7BEh6XNsp_QeoeqSgKY5AMqdnGPdg [6] https://1drv.ms/b/c/b51e5540123fa1b6/EZRqzdsm4ZFFo9NKwUhE9J4BOXczJSCGKyoty-qbuRCH6Q?e=euh7KO
Read more

Linux 6.18 Released With Many New Features, Likely This Year's LTS Kernel

Subject: Linux 6.18 Released With Many New Features, Likely This Year's LTS Kernel Good day from Singapore, Here’s a news article I’d like to share. Article: Linux 6.18 Released With Many New Features, Likely This Year's LTS Kernel Link: https://www.phoronix.com/news/Linux-6.18-Released Date of article: 30 Nov 2025 Thank you very much. Regards, Mr. Turritopsis Dohrnii Teo En Ming Extremely Democratic People's Republic of Singapore 3rd December 2025 Wednesday 1.04 PM Singapore Time REFERENCES ============== [1] https://lore.kernel.org/lkml/VHnRPIpRh81FXZ0Ydj0Kez2h5td0VivWZD4wsLiCk2QPGvEjI6CDiomAiSUhhBPoWD5Vrk57nVD5OSj7DvuUYv8wykhw_H2jbUSIB1nDYAA=@protonmail.com/T/#u [2] placeholder for lkml.iu.edu [3] https://lkml.org/lkml/2025/12/3/169 [4] https://lwn.net/ml/linux-kernel/VHnRPIpRh81FXZ0Ydj0Kez2h5td0VivWZD4wsLiCk2QPGvEjI6CDiomAiSUhhBPoWD5Vrk57nVD5OSj7DvuUYv8wykhw_H2jbUSIB1nDYAA%3D%40protonmail.com/ [5] http://yhbt.net/lore/all/VHnRPIpRh81FXZ0Ydj0Kez2h5td0VivWZD4wsLiCk2QPGvEj...
Read more