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...
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 20.04 server. We...
A LAMP stack is short form of Linux, Apache, MySQL and PHP. Here, L means Linux operating system, A for Apache web server, M is for MySQL database, P for PHP programming language. In this guide, we’ll install Apache 2.4, MySQL 8.0 and PHP 7.4 (LAMP) on Ubuntu 20.04 LTS (Focal Fossa) system. Prerequisites#...
MySQL is most popular open-source database management system. MySQL installation on Ubuntu is very easy and it’s commonly being a part of the popular LAMP and LEMP stacks. This tutorial explain how to install MySQL on Ubuntu 20.04 Focal Fossa systems. Install MySQL on Ubuntu# MySQL version 8.0 is the latest version of MySQL...
WordPress is the 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 Apache on CentOS...
WordPress is the most popular and widely used to create websites, blogs, webshop and much more. PHP processing and MySQL or MariaDB database are used as a backend in WordPress. In this tutorial, we will show you how to install WordPress with Nginx on CentOS 8 system. Prerequisites# We are going to use LEMP...
MariaDB is an open-source relational database management system and a drop replacement of MySQL DB server. It is a fork of MySQL and managed by the original MySQL developers. MariaDB is a multi-user, multi-threaded SQL database server. In this article you will learn how to install and secure MariaDB on CentOS 8 server. Install...
MySQL is most popular open-source database management system. MySQL is no longer available since release of Debian 9 and MariaDB has become the default database system. MariaDB is the default database system in Debian 10. This tutorial will outlines how to install MySQL on Debian 10 Linux from the MySQL Apt repository. Configuring MySQL...