WordPress is the most popular and widely used blogging and content management system in the world. PHP processing and MySQL/MariaDB database are used as a backend in WordPress. It is simplest way to create a Blog, Portfolio Website, webshop etc. In this tutorial, we will show you how to install WordPress with Nginx on...
A LAMP stack is short form of Linux, Apache, MySQL and PHP. In this, L means Linux operating system, A for Apache web server, M is for MySQL database, P for PHP programming language. This guide will help you to install Apache, MySQL and PHP (LAMP) on Ubuntu 22.04 LTS (Jammy Jelllyfish) system. Prerequisites#...
The LEMP is a short name that describes a Linux operating system, with an Nginx (pronounced like “Engine-X”) web server. The backend data is stored in the MySQL or MariaDB database and the dynamic processing is handled by PHP. This tutorial describes how to install a LEMP stack on an Ubuntu 22.04 server. We...
MariaDB is an open-source and multi-threaded database management system. It will organize and provide access to databases where your site can store information. It is a replacement of MySQL and developed by some of the original developers of the MySQL. With the release of Debian 11, MySQL was replaced with MariaDB as the default...
MariaDB is an open-source and multi-threaded database management system which used as alternate of MySQL in LAMP stack. It’s developed by some of the original developers of the MySQL. This tutorial covers how to install MariaDB on Ubuntu 22.04. Prerequisites# How to Install MariaDB on Ubuntu 22.04# Perform the following instructions to install MariaDB...
A collation means a predefined rules to compare and sort character strings in a database server. Generally, this error occurs during the database restoration on another server. In this guide, we will show you how to fix Unknown collation: utf8mb4_0900_ai_ci error. Let us discuss the cause and solution about the issue: Problem – Unknown...
MySQL is the most popular and open-source relational database management system. In this article we will show you how to create MySQL or MariaDB database through the command line. Prerequisite# Make sure MySQL or MariaDB is already installed on your system. User account should have privileges to perform actions or have root user account....
The mysqldump is a utility used to backup and restore MySQL or MariaDB database using command line. It is creating a set of SQL statements while taking backup and those are used while restoring. In this tutorial we will show you how to backup and restore MySQL or MariaDB databases from the command line...
MySQL is one of the most popular open-source RDBMS (Relational database management system). MySQL provides some features for particular version numbers and on particular platforms only, so knowing which version is running on your server is really important. In this quick tutorial, we’ll explain how to check the MySQL or MariaDB version on your...
MariaDB is a multi-threaded and open-source database management system which used as alternate of MySQL. It’s developed by some of the original developers of the MySQL. This tutorial covers how to install MariaDB on Ubuntu 20.04. Read : How to Install MySQL on Ubuntu 20.04 Prerequisites# You must logged in as root or non-root...