How to Install and Secure MariaDB on Ubuntu 24.04

MariaDB is a popular, open-source relational database management system, widely recognized as a drop-in replacement for MySQL. It offers robust performance, strong security features, and a flexible structure, making it suitable for a variety of applications. In this tutorial, we’ll walk through the process of installing MariaDB on Ubuntu 24.04, a recent and stable release of one of the most popular Linux distributions. Whether you’re setting up a web server, a cloud application, or just experimenting with database management, this guide will help you get MariaDB up and running on your Ubuntu system.

Read more

Changing MariaDB user password

How to change MariaDB user password

Have you or one of your MariaDB users forgotten the password to a MariaDB account? It’s very easy to reset a MariaDB user password on Linux, and we’ll show you the commands and step by step instructions below.

Resetting the MariaDB root password requires a different set of instructions, which we also cover below. Depending on which account you need to change the password for (a normal user or root), follow the appropriate section below.

In this tutorial you will learn:

  • How to change MariaDB user password
  • How to change MariaDB root password
Changing MariaDB user password

Changing MariaDB user password

Read more

main

Introduction to database normalization: the first three normal forms

The goal of a relational database normalization is to achieve and improve data integrity and avoid data redundancy so to avoid possible insertion, updation or deletion anomalies. A relational database is normalized by applying a series of rules called normal forms. In this article we will discuss the first three normal forms.

In this tutorial you will learn:

  • What is the first normal form
  • What is the second normal form
  • What is the third normal form
main

Read more

Installing XAMPP on Ubuntu Linux

How to install XAMPP on Ubuntu Linux

Hosting a website on a Linux system usually involves multiple software packages that operate together to deliver a web browsing experience to potential viewers. For example, it’s common for PHP to dynamically render web content but retrieve data from a database. These are two separate components and they must both be installed to present a website as intended.

XAMPP is a software stack that can run on Ubuntu Linux and make your life a little easier when it comes to web hosting. XAMPP stands for cross-platform (X), Apache (A), MariaDB (M), PHP (P), and Perl (P). These are all common components used in web hosting, and combining them into a single installation makes the initial setup less complicated. XAMPP also comes with Bitnami, which allows you to install content managements systems, such as WordPress, as well as other apps on top of your XAMPP installation if you choose.

In this guide, we’ll cover the installation of XAMPP on Ubuntu Linux. Follow along with our step by step instructions to get it setup on your own system.

In this tutorial you will learn:

  • How to install XAMPP on Ubuntu Linux
  • How to manage your XAMPP installation
Installing XAMPP on Ubuntu Linux

Installing XAMPP on Ubuntu Linux

Read more

MySQL workbench dashboard on Ubuntu Linux

Install and Configure MySQL Workbench on Ubuntu Linux

MySQL workbench is a graphical application which let us manage data and perform administrative tasks on MySQL databases. In this tutorial we will see how to install the program on Ubuntu 18.04 (Bionic Beaver) and we will perform a brief tour of some of its most basic functionalities to make your Linux system administration job easier.

In this tutorial you will learn:

  • How to install and configure MySQL workbench
  • How to create a schema and a table via MySQL workbench
  • How to crate an E.R diagram by reverse-engineering an existing schema
  • How to execute SQL queries

Read more

Reset root MySQL/MariaDB password on Ubuntu 20.04

How to reset root MySQL/MariaDB password on Ubuntu 20.04 Focal Fossa Linux

In this guide we will reset the lost root MySQL/MariaDB password on Ubuntu 20.04 Focal Fossa. This can be achieved by disabling the root authentication and longing in without the password.

In this tutorial you will learn:

  • How to reset root administrator password on MySQL 8 or higher
  • How to reset root administrator password on MariaDB 10.3 or higher
  • How to disable root authentication and login without password

Read more