Database

The extensive data ecosystem includes MySQL as one of its most popular technologies. It is a Relational Data Base Management System (RDBMS) developed by Oracle based on Structured Query Language. MySQL is an essential component of many of the most popular stacks for developing effective web applications. Especially for programs built with Linux, Apache, MySQL, and PHP (object-oriented programming language). Without...

If you've ever wondered how websites are made, there are a few important things you should know about website hosting. Just like when you rent a plot of land, you must have a dedicated person managing the web server. This person will be responsible for ensuring that your website is accessible from anywhere in the world, regardless of your...

In this tutorial, you will learn how to install MySQL Workbench on Oracle Linux 8. MySQL Workbench is graphical user interface tool that is used by GUI centric database administrators/architects/developers to administer and manage MySQL servers and databases. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. Install MySQL...

Follow through this tutorial to learn how to install MySQL 8 on Oracle Linux 9. Being a popular open-source relational database management system, MySQL is available and can be installed on Oracle Linux 9. Install MySQL 8 on Oracle Linux 9 MySQL 8 package is provided by Oracle Linux 9 AppStream repos. The default Oracle Linuix AppStream repositories however may not...

Businesses have a lot of data to manage these days. Between customer information, sales data, and marketing metrics, it can be difficult to keep track of it all. This is where data management systems come in. These systems help businesses organize and store their data in a way that makes it easy to access and analyze. There are many...

Welcome to our tutorial on how to install LEMP stack on Ubuntu 22.04.  LEMP Stack is a group of open source tools commonly used for developing and deploying web applications. It consists of the Linux Operating System (Ubuntu 22.04 in this case), lightweight and powerful Nginx (Engine-X) web server, MySQL/MariaDB RDBMS and the server-side scripting language, PHP. Install and Setup LEMP Stack...

Welcome to our guide on how to install LAMP Stack on Ubuntu 22.04. If you are looking at building some web application, LAMP stack is the first thing you might need. As you already know, LAMP is a group of opensource web development softwares; Linux OS, Apache http server, MariaDB/MySQL relational database management systems and PHP web scripting language. Install LAMP Stack on Ubuntu 22.04 As...

This guide provides a step-wise tutorial on how to install MySQL 8 on Ubuntu 22.04. MySQL is a fast, stable and true multi-user, multi-threaded SQL database server with its main goals being speed, robustness and ease of use. To see a comprehensive description of the features offered by MySQL 8, navigate to MySQL 8 Reference Manual. Install MySQL 8 on...

In this tutorial, you will learn how to configure Guacamole MySQL database authentication. Guacamole supports various authentication mechanisms including database authentication via MySQL, PostgreSQL, or SQL Server databases. So how can you can enable and configure Guacamole MySQL database authentication? Configure Guacamole MySQL Database Authentication If you want to install Guacamole on Linux, see our various guides on installation of Apache Guacamole. To...

Follow through this guide to learn how to install MariaDB 10.8 on Ubuntu 20.04. MariaDB 10.8.2 is the current RC release version of MariaDB. Install MariaDB 10.8 on Ubuntu 20.04 To install MariaDB 10.8 on Ubuntu 20.04; (DO NOT USE RC RELEASES IN PRODUCTION yet) Install MariaDB APT Repositories To install MariDB APT repos, head over to MariaDB repositories site to choose your mirrors. Next, execute the...