Tag mysql

Ghost installation: An Alternative to WordPress for Blogging

WordPress has become a content management platform that is too big and complex for simple blogging. Ghost installation is very simple, think of it as an alternative to WordPress for blogging that easy to use.

April 25, 2023

Install Mattermost on Ubuntu 22.04 server

Mattermost is a collaboration tool designed for teams to communicate efficiently. It have mobiles apps and they are open source which could be white labelled if needed. In this article let me guide you how to install and setup Mattermost on Ubuntu 22.04 LTS server.

March 16, 2023

How to install Snipe-IT on Ubuntu 22.04

Snipe-IT is an asset management system which can be self hosted too. It provides user friendly UI and has a powerful API. In this guide I will show you how to install Snipe-IT on Ubuntu 22.04 LTS with PHP 8.1 and MariaDB.

January 19, 2023

How to get Authorization header in PHP

In order to construct a secure resource that can be accessed through an API, we must utilize an authorization header with a token or bearer. In this article, I will guide you how to obtain the authorization header, extract the token or bearer. Then authenticate it against a database table and return a JSON output in PHP.

January 17, 2023

Setup LAMP stack (Apache, MariaDB, PHP) on Ubuntu 22.04

In this article we will setup/install LAMP stack (Apache, MariaDB, PHP) on Ubuntu 22.04 including SSL via Certbot and basic firewall with UFW.

August 21, 2022

Recover InnoDB MySQL or MariaDB database from raw files

So you have raw files of your database and don't have a dump or backup at hand. Worry not, it's easy to recover an InnoDB MySQL or MariaDB database from raw files.

June 25, 2022