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

Introduction to pandas

Introduction to pandas

Pandas is a free and open source Python library released under the BSD license. Originally developed by Wes McKinney in 2008, and supported by companies like Intel and Nvidia, it is targeted at data analysis and manipulation. It can be easily used to read and write data from a variety of sources such as Excel spreadsheets, Comma-separated Values (CSV) files, and many more.

Read more

How to Install etcd on Ubuntu

How to Install etcd on Ubuntu

Etcd is a free and open-source distributed and secure key-value store used to store the most critical information of a given distributed system. Etcd is written in Go making it extremely fast in distributed systems without incurring a performance overhead from clustered machines. In this guide, you discover the basics of installing and setting up an etcd cluster on Ubuntu systems.

Read more

Mysql server has gone away - Fix

Mysql server has gone away – Fix

The MySQL server has gone away error can occur when you have an established connection to the MySQL server and for one reason or another, the connection times out or otherwise goes down. In the context of a Linux system, the error can sometimes be seen from the MySQL client. In this tutorial, we will show several solutions for dealing with and troubleshooting the MySQL error.

Read more

PostgreSQL installation on Ubuntu 22.04 Jammy Jellyfish

Ubuntu 22.04 PostgreSQL Installation

PostgreSQL is a database management system, similar to MySQL in many respects but with some key differences. Like MySQL, it’s commonly hosted on Linux. In this guide, we’ll show how to run a PostgreSQL server on Ubuntu 22.04 Jammy Jellyfish, as well as installing the client version in case you just need to connect to an external PostgreSQL database.

Read more

Allowing MySQL connections through firewall and creating a new user that allows connections from all hosts

MySQL: Allow all hosts

If you wish to access your MySQL server remotely, it will be necessary to configure one or more users to allow access from remote hosts. If you do not know all the IP addresses of the connecting hosts, then you can simply allow connections from all hosts.

Read more