Category: MySQL MariaDB

Install phpMyAdmin 5 on CentOS 8

Install phpMyAdmin 5 on CentOS 8

phpMyAdmin is used to manage MySQL/MariaDB databases graphically from the web browser. phpMyAdmin 5 is the latest version of phpMyAdmin at the time of this writing. In this article, I am going to show you how to install phpMyAdmin 5 on CentOS 8. So, let’s get started. Installing PHP, Apache, MySQL/MariaDB: phpMyAdmin is written on…

Deploying MySQL using Docker-Compose

Deploying MySQL using Docker-Compose

MySQL is one of the most popular database management systems out there. Many applications use it for their backend needs. MySQL essentially has two components one is the MySQL database server which manages the data and interacts with the outside world, providing applications the data they desire, as well as, updating records as new information…

How to Use MySQL JSON Data Type

How to Use MySQL JSON Data Type

MySQL is a relational database system developed to store data in medium to large computer systems. It uses schema to define the structure of the database where the data is stored. Due to its structured nature, it’s often difficult to alter the data with ease, especially when the particular column is linked with several other…

Install MySQL on CentOS 7.5

Install MySQL on CentOS 7.5

In this tutorial I will show you how to install MySQL Database on CentOS 7.5 operating system using the yum commands and the built in utilities of CentOS. It can be installed from source, or additional ways, but we will do it using CentOS native commands. Firstly let’s make sure to update our system before…

MariaDB Dump Tutorial

MariaDB Dump Tutorial

Many websites are now using MariaDB server to store their valuable data. Data is the most important content of any website. So you need to keep regular backups of the database and this will help you to restore your data if your website crashes or the data is corrupted by any system failure. This tutorial…

Using Mytop to Monitor MySQL Performance

Using Mytop to Monitor MySQL Performance

Today, one of the most critical parts of any application is how the databases which power the backend of the applications scale in difficult situations. While most of the teams focus on establishing a controlled number of connections from applications, optimizing database queries at the application level so that it runs fast on the Database,…